Loading CSV files

Link to example

Splitgraph supports importing data from CSV files into Postgres tables. It uses TableSchema's schema inference functionality and Postgres' COPY FROM STDIN command to ingest the actual data.

To create a Splitgraph image from a CSV file:

sgr init [repository_name]
sgr csv import -f [filename] -k [primary_key] ... [repository_name] [table_name]

# Import more data or alter the schema of table_name as you see fit
sgr commit [repository_name]