Table to Storage SQL file
This is the description of the SQL file used for a Table to Storage data operation.
Previous[V3] Table to Storage configuration fileNext[V1-V2: deprecated] Table to Storage configuration file
Last updated
Was this helpful?
This is the description of the SQL file used for a Table to Storage data operation.
Last updated
Was this helpful?
To run a Table to Storage data operation, you first need to prepare a SQL query that will extract the data to export.
The SQL file must contains a BigQuery Standard SQL query. You can write it directly in the query editor of and then save it to a .sql file.
Example:
This query will be executed when the data operation is deployed, and the result will display in the CSV export file and the table copy if specified.