📤File Uploads
Guide to integrate your CSV or Excel files with Sprinkle
Last updated
Guide to integrate your CSV or Excel files with Sprinkle
Last updated
You can ingest CSV or Excel files into Sprinkle. Sprinkle will create a table in the warehouse for the uploaded file.
To learn about Data sources, refer here.
Navigate to Ingest -> File Uploads Tab -> Setup files
Provide the name -> Click on Create.
'Add File' button
Click the 'Browse' button or drag and drop your CSV file.
Provide the name for this file.
Skip before header: Specify the number of top rows to skip before the header line when reading CSV. Do not skip the column header itself; the next available row is used to extract column names.
Exclude columns: List of columns to be excluded when reading the CSV.
Note: There are a few validation checks that Sprinkle does to ensure the quality of the data being ingested.
1️ Empty Column Headers: No column header should be empty. Use Skip before headers if you want to skip a few rows at the top. In that case, the next row available is used to extract column names.
2️ Invalid Column Headers: Remove special characters or white spaces. Make sure each column name is unique and begins with an alphabet or underscore.
To guide you through the errors and fix them, in-place error markings are shown on the Preview table.
Preview: Shows a preview of the table. You can change the headers and also change the variable type of the data in the columns.
Click Proceed.
After successful ingestion, a table in the warehouse will be created with the name pattern as ds_<datasourcename>_<filename>.
