DuckDB and Native CSV Tables
Not new, but I’m light on content. I told my team about this trick the other day, and it’s one of my favorites: using duckdb to ingest various CSV exports from various sources and then using SQL to poke at that data. Details from the docs over at: DuckDB CSV Import But in short, I export various datasets from Snowflake pretty regularly, from different databases and datasets that aren’t naturally joined; I download various JSON reports from APIs and convert the Results to CSV. Then I bring them both into duckdb: ...