Load parquet into instant databases and query it

Parquet dumps and other one-offs usually need to live next to warehouse tables. Load them into an instant database, inspect the shape, then join them with everything else without standing up another pipeline.

How it works

Step 1: Upload from a file

Create an instant database with catalog q2, declare a targets table, and load targets.parquet into it. What do I type in SQL to read it?

Step 2: Load more files into the same database

Load accounts.parquet as an accounts table into the same q2 database.

Step 3: Inspect before you join

Show my instant databases and list the tables inside q2.

Step 4: Query like any other table

Match my Q2 targets to sales accounts on account id. Give me account_id and plan for up to 50 pairs.

Who uses this

• Ops bringing in recurring CSV extracts without touching warehouse DDL.
• Analytics freezing cohort definitions as stable instant-database tables.
• Automation that reads uploaded tables by name instead of parsing attachments ad hoc.