BigQuery Snippets


Topic Replies Views Activity
About the BigQuery Snippets category
0 334 July 16, 2021
Latest Row (deduplicate)
clean-data ,  window-functions
4 1295 December 11, 2021
Random Number Between 2 Integers
analysis
1 671 September 9, 2021
Advanced Date Dimension with Fiscal Calendar
window-functions ,  date-time
1 446 August 23, 2021
Basic Date Dimension
date-time
0 420 August 22, 2021
Formatting Date Cheat Sheet
date-time
0 475 August 12, 2021
Extract/Trunc WEEK starting on Mon (not Sun)
date-time
0 215 August 9, 2021
Generate Uniform Distribution
statistics ,  generating-data
0 460 July 16, 2021
Last day of the month
analysis ,  date-time
4 822 August 5, 2021
First row of each group
2 586 August 4, 2021
UDF: Weekday
date-time ,  udf
0 333 August 4, 2021
UDF: Quarter
date-time ,  udf
0 175 August 4, 2021
UDF: Month of Year
date-time ,  udf
0 198 August 4, 2021
Compound growth rates
statistics
0 272 July 16, 2021
Cohort Analysis
charts ,  analysis
0 1066 July 26, 2021
UDF: Least Value in an Array
udf
0 230 July 26, 2021
PIVOT in BigQuery
0 464 July 28, 2021
Identify Outliers in BigQuery
analysis
0 1461 July 26, 2021
Extract repeating word from string
regex
0 262 July 26, 2021
Split a string on uppercase characters
clean-data ,  regex
0 192 July 26, 2021
Least/Greatest value in an array
arrays
0 1168 July 26, 2021
Replace or Strip out multiple different string matches from some text
clean-data ,  regex
0 361 July 24, 2021
Yearly cohorts
1 374 July 26, 2021
Concatinate text handling nulls
arrays ,  transform
1 203 July 26, 2021
Count NULLs
clean-data
0 378 July 16, 2021
Bar Chart
charts
0 301 July 16, 2021
Horizontal Bar Chart
charts
0 285 July 16, 2021
100% Stacked Bar Chart
charts
0 322 July 16, 2021
Median
statistics
0 239 July 16, 2021
Rank by Group
analysis ,  window-functions
0 273 July 16, 2021