bigquery

  • 2022
  • 11. Nov 2022 BigQuery - Quickly mock a table
  • Sometimes to test queries, you might want to quickly mock tables like table_inplace. Here’s one way to do it. WITH table_inplace AS ( SELECT * FROM UNNEST([ STRUCT (1 AS num, ‘Sun’ AS name), (2,