CSV Guide

Introduction

Sheetloom provides a useful feature to upload a CSV file and convert it into a database table that can be queried like any other data source.

A CSV file and the database table it creates can be replaced or appended in future uploads.

When a CSV is uploaded into Sheetloom, a folder of the same name is created to store it. A database table with the same name as the CSV is created from the CSV.

Data Stitches that reference the database table can be created in the same way as any other SQL Stitch

Custom Columns

During the initial CSV upload process, a custom column with a preassigned default value can optionally be added. At runtime the custom column name is used as a parameter to permit filtering on an appended file using the default custom column default value supplied.

At runtime the default value for the custom column parameter is input as a query filter.

See custom columns for further details.