Cirro has a built-in SQL Query tool for use on Data Puppy datasources. It also recognises Cirro's four-part table names.
Open Federated Query Builder
- Click Data Puppy 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.
|Datasource_Name||Datasource is connected.|
|Datasource_Name||Datasource is disconnected.|
|Mouseover and click to paste the node to the editor.|
Tip: Hover your mouse pointer over each node to get a connection message (e.g., Last successful connection, Timed Out, etc. )
Use the Editor for your SQL query. You’ll find supported SQL grammar in our SQL Guide.
|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.|