Loading CSV files
sgr
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]