Pratap Vardhan

bigquery

  • 2023
  • 19. Apr 2023 BigQuery - Set date to April 1st based on current date
  • When you need to set start_date to current financial year’s starting date. 2023-02-14 set to 2022-04-01 2023-10-34 set to 2023-04-01 DECLARE start_date date; SET start_date = CURRENT_DATE(); S
  • 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 na
homeaboutmediacontact