πŸ“€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