bq
Verified for current stable LTS
Bq Command: Run Parameterized Query
Use for run parameterized query with Bq. Exact CLI syntax to run parameterized query using Bq.
When to use this: Use for run parameterized query with Bq.
Command Syntax
bq query --use_legacy_sql=false --parameter='ts_value:TIMESTAMP:2016-12-07 08:00:00' 'SELECT TIMESTAMP_ADD(@ts_value, INTERVAL 1 HOUR'bq query --use_legacy_sql=false --parameter='ts_value:TIMESTAMP:2016-12-07 08:00:00' 'SELECT TIMESTAMP_ADD(@ts_value, INTERVAL 1 HOUR'Command Breakdown
--use_legacy_sql=false- Command Option
- Tool-specific option used by this command invocation.
--parameter='ts_value:TIMESTAMP:2016-12-07- Command Option
- Tool-specific option used by this command invocation.
FAQ
Purpose: Exact syntax to run parameterized query using Bq.
Test path: Replace placeholders and run destructive commands in a disposable workspace first.
Flag behavior: Tool version, platform, and shell can change behavior.
Improve This Command
Suggest a correction, safer default, or version-specific note for this entry.
Related Operations
Bq Command: Batch Load Data From A File In Various Formats To A Table
bq load --location <location> --source_format <CSV|JSON|PARQUET|AVRO> <dataset>.<table> <path/to/source> Bq Command: Copy A Table To Another Table Within The Same Dataset bq cp <dataset>.<OLD_TABLE> <dataset>.<new_table> Bq Command: Create A New Dataset Or Table In A Specified Location bq mk --location=US <dataset_name>.<table_name> Bq Command: Display Help For Bq Commands bq help Bq Command: List All Datasets In A Project With Filters bq ls --filter labels.<key>:<value> --max_results <integer> --format=prettyjson --project_id <project_id>