📤File Uploads
Guide to integrate your CSV or Excel files with Sprinkle
You can ingest CSV or Excel files into Sprinkle. Sprinkle will create a table in the warehouse for the uploaded file.
Watch Video 📺
Step-by-Step Guide
Step 1: Configure Files Datasource
To learn about Data sources, refer here.
Navigate to Ingest -> File Uploads Tab -> Setup files
Provide the name -> Click on Create.
Step 2: Add File
'Add File' button
Click the 'Browse' button or drag and drop your CSV file.
Step 3: Add details and upload
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>.
Last updated