The query operation allows you to execute a SQL query against one or more data sources configured in your Connect AI account. SELECT, INSERT, UPDATE, DELETE, and EXEC statements are all supported (though the /exec operation should be preferred for the latter).
Basic Authentication with username and password. Use your PAT as the password. You can get your PAT from Connect AI by selecting Settings > Access Tokens.
If your query contains a workspace, the workspace name must be specified here.
The SQL query to execute. Must be a valid SQL query.
1The default catalog to use for the query if none is specified in the query itself.
The default schema to use for the query if none is specified in the query itself.
If true, only the schema of the result set is returned without any data rows. The default value is false.
1 <= x <= 300