Patrick DunninGoogle Cloud - CommunityTime series analytics with BigQuery part 2Defining sliding windows and session windowsDec 11, 2020Dec 11, 2020
Patrick DunninGoogle Cloud - CommunityTime series analytics with BigQueryTechniques for tumbles, fills, and interpolationNov 13, 20202Nov 13, 20202
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…Oct 29, 20201Oct 29, 20201
Patrick DunninGoogle Cloud - CommunityScheduling BigQuery SlotsReliably adding and removing short term slot capacity on a scheduleSep 29, 2020Sep 29, 2020
Patrick DunninGoogle Cloud - CommunityYet another way to generate fake datasets in BigQueryWrapping faker.js with a Javascript UDFAug 7, 20202Aug 7, 20202
Patrick DunninGoogle Cloud - CommunityBreaking up very large BigQuery jobsUsing integer range partitions with BigQuery scriptingJul 6, 20202Jul 6, 20202
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…Apr 22, 20203Apr 22, 20203