Pratap Vardhan
Blog
Media
Work
About
sql
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,
home
about
media
contact