DuckDB: Querying JSON files as if they were tables

Re:DuckDB: Querying JSON files as if they were tables by benjaminwootton on Friday March 03, 2023 @01:56PM (#35013583)

What’s the workflow with JDBC? Say you connect Tableau to it. How would you populate it with data?

[ Parent | on HN ]

Re:DuckDB: Querying JSON files as if they were tables by orthoxerox on Friday March 03, 2023 @02:04PM (#35013662)

My workflow is that I have a connection to c:\temp\scratchpad.db in DBeaver that I populate via

  create table some_data as select * from 'c:\temp\whatever.csv'

  create table other_data as select * from read_parquet('c:\temp\000000_0')

which I then can transform using SQL and export the result into CSV, Parquet or SQLite when needed.

[ Parent | on HN ]