InGoogle Cloud - CommunitybyPatrick Dunn·Dec 11, 2020Time series analytics with BigQuery part 2Defining sliding windows and session windows
InGoogle Cloud - CommunitybyPatrick Dunn·Nov 13, 2020Time series analytics with BigQueryTechniques for tumbles, fills, and interpolationA response icon2A response icon2
InGoogle Cloud - CommunitybyPatrick Dunn·Oct 29, 2020Conditionally 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…A response icon1A response icon1
InGoogle Cloud - CommunitybyPatrick Dunn·Sep 29, 2020Scheduling BigQuery SlotsReliably adding and removing short term slot capacity on a schedule
InGoogle Cloud - CommunitybyPatrick Dunn·Aug 7, 2020Yet another way to generate fake datasets in BigQueryWrapping faker.js with a Javascript UDFA response icon2A response icon2
InGoogle Cloud - CommunitybyPatrick Dunn·Jul 6, 2020Breaking up very large BigQuery jobsUsing integer range partitions with BigQuery scriptingA response icon2A response icon2
InGoogle Cloud - CommunitybyPatrick Dunn·Apr 22, 2020Optimize 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…A response icon3A response icon3