Pratap Vardhan

sql

  • 2024
  • 21. Jul 2024 BigQuery - Sampling
  • Table sampling allows you to query subsets of large BigQuery tables, providing diverse records and reduces the cost of scanning the entire table. This query ~selects 10% of a data: SELECT * FROM datas
  • 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 DEFAULT CURRENT_DATE(); SET start_d
  • 22. Apr 2023 BigQuery - calculating median
  • You can use PERCENTILE_CONT and PERCENTILE_DISC to calculate ~median. However, it doesn’t work as aggregate function in GROUP BY. APPROX_QUANTILES comes handy here using APPROX_QUANTILES(column,
  • 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