Comment by jasonjmcghee
16 hours ago
Yours looks much better for your use case, but fwiw you can do it in a single command with duckdb too (but not interactive etc.):
duckdb -c "from 'foo.parquet'"
but maybe still useful for other formats or multi-file or remote situations
I use a little shell alias that drops me into duckdb with the file loaded into a table for interactive querying:
https://github.com/llimllib/personal_code/blob/c1a74b1b9527f...