Query Tool runs a SQL query in BigQuery using the REST API. Use proper BigQuery SQL syntax, e.g., SELECT * FROM `project.dataset.table` WHERE column_name = 'value'. Results are returned under data.rows; an empty rows array means no matching data. Large result sets may be returne…
queryRequiredstringQuery to run on BigQuery. Use standard SQL syntax.
locationstringGeographic location where the query should run (e.g., 'US', 'EU', 'us-central1'). Defaults to 'US' multi-region. Must match the dataset's actual geographic location; mismatched regions cause query failure.
project_idRequiredstringThe project ID to run the query against.
timeout_msintegerQuery timeout in milliseconds. Defaults to 10000 (10 seconds).
max_resultsintegerMaximum number of rows to return. If not specified, returns all rows.
use_legacy_sqlbooleanWhether to use legacy SQL syntax. Defaults to False (standard SQL).
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
OAuth connection. Risk level 2 of 5.
Free Action