Load parquet into managed databases and query it

Parquet dumps and other one-offs usually need to live next to warehouse tables. Load them into a managed 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 a managed 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 managed 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 managed-database tables.
• Automation that reads uploaded tables by name instead of parsing attachments ad hoc.