- INFORMATION
-
gcloud alpha bq translation translateis supported in universe domainuniverse; however, some of the values used in the help text may not be available. Command examples may not work as-is and may requires changes before execution. - NAME
-
- gcloud alpha bq translation translate - translate a SQL query from a source dialect to BigQuery
- SYNOPSIS
-
-
gcloud alpha bq translation translate--location=LOCATION--source-dialect=SOURCE_DIALECT[--input-file=INPUT_FILE] [--output-file=OUTPUT_FILE] [--translation-log-file=TRANSLATION_LOG_FILE] [GCLOUD_WIDE_FLAG …]
-
- DESCRIPTION
-
(ALPHA)Translate a SQL query from a source dialect to BigQuery.The command reads a SQL query from standard input (or an input file) and prints the translated query to standard output (or an output file).
- EXAMPLES
-
To translate a Snowflake query from stdin, run:
echo 'SELECT * FROM test.my_table;' | gcloud alpha bq translation translate --source-dialect=SNOWFLAKE --location=usTo translate a Snowflake query from a file and save the output and logs to files, run:
gcloud alpha bq translation translate --source-dialect=SNOWFLAKE --location=us --project=my-project --input-file=input.sql --output-file=output.sql --translation-log-file=translation_logs.yaml - REQUIRED FLAGS
-
--location=LOCATION- Google Cloud Storage location to use for the translation.
--source-dialect=SOURCE_DIALECT- Source dialect of the query.
- OPTIONAL FLAGS
-
--input-file=INPUT_FILE- File from which to read the SQL query to translate. Can be piped through stdin as well.
--output-file=OUTPUT_FILE- File to which to write the translated SQL. Writes to stdout if not provided or if set to ``-´´.
--translation-log-file=TRANSLATION_LOG_FILE- File to which to write the translation logs.
- GCLOUD WIDE FLAGS
-
These flags are available to all commands:
--access-token-file,--account,--billing-project,--configuration,--flags-file,--flatten,--format,--help,--impersonate-service-account,--log-http,--project,--quiet,--trace-token,--user-output-enabled,--verbosity.Run
$ gcloud helpfor details. - NOTES
- This command is currently in alpha and might change without notice. If this command fails with API permission errors despite specifying the correct project, you might be trying to access an API with an invitation-only early access allowlist.
gcloud alpha bq translation translate
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-04-07 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2026-04-07 UTC."],[],[]]