Skip to content

Instantly share code, notes, and snippets.

@torgeir

torgeir/bq-table-suffix-different-schema.sql

Last active March 16, 2023 12:03
Show Gist options
  • Save torgeir/3f887be4727f243bf19afbd58cd86529 to your computer and use it in GitHub Desktop.
Save torgeir/3f887be4727f243bf19afbd58cd86529 to your computer and use it in GitHub Desktop.
Download ZIP
BQ table suffix when schema differs
Raw
bq-table-suffix-different-schema.sql
# one: string
#INSERT INTO `torgeirtester.schema_one` values ("one");
# one: string, two: number
#INSERT INTO `torgeirtester.schema_two` values ("one", 2);
# three: boolean
#INSERT INTO `torgeirtester.schema_three` values (true);
SELECT * FROM `torgeirtester.schema_*`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment