Importing Data using Java Table Functions
When the analytics screen running on our main operational database got too slow, we moved a year of data into DuckDB on the same server. Getting the data in was the hard part. This is the story of every method we tried, and why a table function written in pure Java is the one we shipped.
Sources
- T1Importing Data using Java Table FunctionsDatabricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale