Get Started — Cut BigQuery Costs in 5 Minutes
Set up QueryFuser in under five minutes. No credit card required for the Starter plan.
Create Your Account
Sign up through the QueryFuser dashboard. You can register with an email and password, or sign in with your Google account for faster setup.
Open DashboardAdd a BigQuery Project
In the dashboard, click "Add Project" and enter your BigQuery project ID and dataset name. Upload your service account key JSON, or select "Use my Google account" if you prefer OAuth-based access.
Your service account needs the following BigQuery roles:
roles/bigquery.dataViewer — Read table data roles/bigquery.jobUser — Run queries roles/bigquery.user — List datasets and tables (metadata) roles/bigquery.metadataViewer — Optional, for deeper metadata sync
Configure Merge Settings
Each project has configurable merge parameters. The defaults work well for most workloads, but you can tune them:
| Setting | Default | Description |
|---|---|---|
| merge_window_ms | 150 | How long to wait for concurrent queries before flushing |
| min_table_overlap | 1 | Minimum shared tables required to merge two queries |
| max_merge_group_size | 50 | Maximum queries to fuse into a single merged query |
| merge_enabled | true | Kill switch to disable merging for a project |
Connect Your BI Tool
Point your BI tool at QueryFuser as if it were a PostgreSQL database. Use these connection settings:
Host: your-queryfuser-host.com Port: 5433 Database: your-project-name (or BigQuery project ID) Username: your-queryfuser-username Password: your-account-password
QueryFuser supports any tool that speaks PostgreSQL wire protocol:
Run Queries and Monitor
Start using your BI tool as normal. QueryFuser works transparently. Check the dashboard merge logs to see which queries were merged, how much data was scanned, and where fallback execution occurred.
The merge log shows every group: how many queries were fused, total duration, bytes processed, and any errors. Individual query logs are linked back to their merge group for full traceability.
Verify It Works
After connecting, run a quick test from the command line to confirm everything is wired up correctly.
# Connect via psql psql -h your-queryfuser-host.com -p 5433 -U your-username -d your-project # Run a test query against your BigQuery data SELECT COUNT(*) FROM your_dataset.your_table; # If you see results, QueryFuser is working. # Open multiple psql sessions and run queries simultaneously # to see merging in action. Check the dashboard merge logs.
What to Look for in the Merge Logs
Ready to Go?
Create your account, add your BigQuery project, and connect your BI tool. Merging starts automatically on the first concurrent query.