Golden Queries
Bring your organization's trusted SQL queries into Solid to improve SQL generation accuracy and consistency.
Golden Queries let you explicitly tell Solid which SQL queries are trusted and important. Solid gives them higher priority when generating SQL for business questions, helping produce more accurate, consistent answers based on your organization's business logic.
Why Golden Queries
Solid uses query history and other context to understand how your organization works with data. But some of your most valuable SQL queries may be rarely executed — or never appear in query history at all. Golden Queries let you fill that gap by directly providing the queries Solid should treat as authoritative.
Previously, custom SQL queries were local to individual semantic models. Golden Queries are persistent, reusable assets that can be shared across models, automatically enriched, and prioritized whenever they're relevant.
What you can do
Bulk upload with CSV
Add multiple trusted queries at once instead of entering them one by one. Provide a CSV with SQL queries and optional names and descriptions. Solid can generate missing metadata automatically, making it easy to onboard an existing collection of trusted SQL.
Query validation
Solid validates queries as they're added, identifies invalid queries, and provides feedback so you can resolve issues before they're saved.
Automatic enrichment
Solid processes each query so it can be understood and reused across relevant semantic models — no manual tagging required.
Prioritized SQL generation
When a business question is relevant to a Golden Query, Solid gives that query higher priority in its SQL generation, so answers stay consistent with your organization's established logic.
How to add Golden Queries
- In Solid, go to Semantic Models → Golden Queries
- To add queries one by one, click Add query and paste your SQL
- To bulk upload, click Import CSV and upload a file with the following columns:
| Column | Required | Description |
|---|---|---|
sql | Yes | The SQL query |
name | No | A short label — Solid generates one if omitted |
description | No | What the query does — Solid generates one if omitted |
- Solid validates and enriches the uploaded queries automatically
- Queries are now available across all semantic models in your organization
Availability
Golden Queries are fully available in production for all organizations.
Updated 13 days ago
