CSV to PostgreSQL with primary key

[alberttwong]

I was expecting that you could import a CSV into postgresql and set one of the imported columns to a primary key.

atwong@Albert-CelerData tpcds-csv % sling run --src-stream 'file://customer.csv' --src-options '{ header: false }' --tgt-conn POSTGRESLOCAL source_options: --tgt-object 'public.customer' --mode full-refresh --primary-key col_001

10:56PM INF connecting to target database (postgres)
10:56PM INF reading from source file system (file)
10:56PM INF writing to target database [mode: full-refresh]
10:56PM INF streaming data
10:56PM INF created table "public"."customer"
10:56PM INF inserted 100000 rows into "public"."customer" in 0 secs [145,183 r/s]
10:56PM INF execution succeeded

but col_001 is still nullable.

[flarco]

Yes, there is an open issue for this: #226

[flarco]

You could use post_sql for now.