- 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.