Run queries

How do I run queries against my data sources?

For troubleshooting purposes, it is often handy to run a SQL/DAX query against a specific data source in your open CAT project file.

You first need to have an open CAT project file, use open_project function. (If you ran invoke_project, the project is already open).

🙀

This function is meant for troubleshooting and is not designed to work with large amounts of data.

cat.open_project(cat_project_path)
queryResult = cat.invoke_command('CsvData', 'select table_schema, table_name from information_schema.tables')
print(queryResult)

This function is an exception compared to others - it returns native Python stuff - it returns list of dictionaries.