Adding a Source SQL tab
To add a Source SQL tab, do one of the following:- In a new tab, click Query source data, or use the Source tables tab.
- Open the dropdown next to Paste semantic SQL query and select Paste source SQL query.
- In an existing tab, pick Source SQL query in the query type picker.
SqlRunnerRead).
The built-in Admin and Developer roles have it. Without it, these options are
hidden, and dashboard widgets based on source SQL show No access to source
SQL.
Data sources
The Source schemas pane lists every source declared on the deployment — both the default source and any named sources added under Settings → Data Sources. Newly added sources show up immediately; you don’t have to wire them into a cube first. Expand a source to browse its schemas, tables, and columns. Click Query table to select the first 100 rows of a table and run the query.Querying methods
You can query source SQL in two ways:- Write SQL manually – Write standard SQL queries directly against your data source for maximum flexibility
- Ask AI – Use the AI agent to help you research your data source, build SQL queries, and refine results in real-time
CREATE or DROP, run only when Enable DDL
operations in SQL is turned on in the deployment’s Settings →
Configuration.