[benjaminwootton]

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

[orthoxerox]

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'

or

  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.