Learn how to submit sync queries and get their status.
SELECT
statement, retrieves and prints the result using the Python SDK. For other languages, consult the specific driver for details.
INSERT
, continue to run by default, while SELECT
statements are cancelled. You can modify this behavior using the cancel_query_on_connection_drop setting.
To avoid connection issues, consider submitting long-running queries as asynchronous queries.
Error Type | Cause | Solution |
---|---|---|
Connection loss | The HTTP connection is interrupted. | Depending on the type of query, the query may still be running. Check engine_running_queries to verify, and use the cancel_query_on_connection_drop setting to modify behavior. |
Engine does not exist or you don’t have permission to access it | The user lacks required permissions. | Ensure the user has USAGE permission on the engine and that the engine exists. |