CSV Integration

In this article, we’ll integrate a CSV file as a data source with Y42.

Y42 allows you to upload a spreadsheet, in CSV format, to your instance. You can upload it directly through your browser on our app.

 

Overview

Authentication: None
Settings: None
Schema type: Dynamic
Update Type: None
 

Authentication

This integration requires no authentication.

 

Import Settings

This integration has no import settings.

 

Schema

Dynamic Schema is a schema which will be dynamically loaded at run-time.
 
Each sheet from your CSV file is imported as a separated table.

 

Note: If none of your rows have numeric values, the column names from the CSV file will not be imported as heading onto the Google BigQuery. However, if there's a number in any of the columns data, then the import will successfully take the first row as column headers. Therefore, we recommend creating an index column to avoid the issue.

 

Updating your data

There's no update schedule feature for this integration.

 

CSV Setup Guide:

  1. On Integrate, click on "Add..." to search for CSV and select it.

  2. Name your integration.

  3. Simply press Browse Files (or Drag & Drop), select your preferred CSV files and upload them into the system.


Note: You must have a CSV file in your files to upload it.

 

Screenshot_2021-01-06_at_3.36.43_PM.png

Note: You can always import and reimport other tables as well, or delete them.

Was this article helpful?
0 out of 0 found this helpful