Cirro has a built-in SQL Query tool for use on Data Management datasources. It also recognises Cirro's four-part table names.

Open Federated Query Builder

  • Click Data Management then Federated Query.

The treeview gives access to all the datasources you’re granted through direct privileges and roles.

  • Expand each node to view the database structure.

  • Hover your mouse pointer over each node to get a connection message (e.g., Last successful connection, Timed Out, etc.)

Tree Icons Description
Cirro Cirro-specific databases.
Datasource_Name Datasource is connected.
Datasource_Name Datasource is disconnected.
Mouseover and click to paste the node to the editor.
Click… Description
Fetch… Choose up to 10,000 rows to fetch with your query. The default is 1000.
Select a specific line or execute the entire your query.
Query tab View query results
Script Output View runtime messages and errors.
Download the query results as a .csv file.

See Also