Patrick DunninGoogle Cloud - CommunityTime series analytics with BigQuery part 2Defining sliding windows and session windows4 min read·Dec 11, 2020----
Patrick DunninGoogle Cloud - CommunityTime series analytics with BigQueryTechniques for tumbles, fills, and interpolation7 min read·Nov 13, 2020--2--2
Patrick DunninGoogle Cloud - CommunityConditionally unmask columns in BigQuery using Authorized UDFsThe BigQuery data warehouse has extensive flexibility in how an administrator sets up access control and column level security. However…5 min read·Oct 29, 2020--1--1
Patrick DunninGoogle Cloud - CommunityScheduling BigQuery SlotsReliably adding and removing short term slot capacity on a schedule3 min read·Sep 29, 2020----
Patrick DunninGoogle Cloud - CommunityYet another way to generate fake datasets in BigQueryWrapping faker.js with a Javascript UDF3 min read·Aug 7, 2020--2--2
Patrick DunninGoogle Cloud - CommunityBreaking up very large BigQuery jobsUsing integer range partitions with BigQuery scripting4 min read·Jul 6, 2020--2--2
Patrick DunninGoogle Cloud - CommunityOptimize BigQuery costs with Flex SlotsGoogle Cloud recently added Flex Slots as a new pricing option for BigQuery. Users on Flex Slots no longer pay for queries by bytes…4 min read·Apr 22, 2020--3--3