BigQuery Snippets


Topic Replies Views Activity
About the BigQuery Snippets category
0 297 July 16, 2021
Latest Row (deduplicate)
clean-data ,  window-functions
4 637 December 11, 2021
Random Number Between 2 Integers
analysis
1 346 September 9, 2021
Advanced Date Dimension with Fiscal Calendar
window-functions ,  date-time
1 333 August 23, 2021
Basic Date Dimension
date-time
0 336 August 22, 2021
Formatting Date Cheat Sheet
date-time
0 371 August 12, 2021
Extract/Trunc WEEK starting on Mon (not Sun)
date-time
0 160 August 9, 2021
Generate Uniform Distribution
statistics ,  generating-data
0 324 July 16, 2021
Last day of the month
analysis ,  date-time
4 499 August 5, 2021
First row of each group
2 384 August 4, 2021
UDF: Weekday
date-time ,  udf
0 246 August 4, 2021
UDF: Quarter
date-time ,  udf
0 131 August 4, 2021
UDF: Month of Year
date-time ,  udf
0 150 August 4, 2021
Compound growth rates
statistics
0 223 July 16, 2021
Cohort Analysis
charts ,  analysis
0 701 July 26, 2021
UDF: Least Value in an Array
udf
0 191 July 26, 2021
PIVOT in BigQuery
0 379 July 28, 2021
Identify Outliers in BigQuery
analysis
0 729 July 26, 2021
Extract repeating word from string
regex
0 194 July 26, 2021
Split a string on uppercase characters
clean-data ,  regex
0 130 July 26, 2021
Least/Greatest value in an array
arrays
0 444 July 26, 2021
Replace or Strip out multiple different string matches from some text
clean-data ,  regex
0 170 July 24, 2021
Yearly cohorts
1 321 July 26, 2021
Concatinate text handling nulls
arrays ,  transform
1 163 July 26, 2021
Count NULLs
clean-data
0 339 July 16, 2021
Bar Chart
charts
0 266 July 16, 2021
Horizontal Bar Chart
charts
0 213 July 16, 2021
100% Stacked Bar Chart
charts
0 277 July 16, 2021
Median
statistics
0 209 July 16, 2021
Rank by Group
analysis ,  window-functions
0 224 July 16, 2021