InStackademicbyNoah KennedyReducing BigQuery Costs by 100–200x with dbt Incremental ModelsMany models my team works with at Tempus are large, but not “big data” large. Usually, our tables hover around the hundred-million rows…Feb 7, 20242Feb 7, 20242
InGeek CulturebyJason Tragakis10 Advanced public BigQuery functions to elevate your game in NLP PreprocessingLearn how to effectively perform text preprocessing using public BigQuery UDFs.Feb 6, 2023Feb 6, 2023
InGoogle Cloud - CommunitybyAxel Thevenot 🐣Deduplication in BigQuery Tables: A Comparative Study of 7 ApproachesAnalyzing and comparing 7 ways of deduplicating rows in a BigQuery table.Dec 14, 20229Dec 14, 20229
InGeek CulturebyJason TragakisUnderstanding IP Addresses for Data Analysis — A practical example using BigQueryLearn the basics of IP addresses and how to analyze the geographic distribution of your users through a practical example.Jan 7, 20232Jan 7, 20232
InGeek CulturebyJason TragakisMicroservices as Functions in BigQuery — Offline IP Address Lookup using SQL (Part 2)Learn how to retrieve geolocation information for an IP address using SQL.Dec 19, 2022Dec 19, 2022
Jason TragakisExpand your professional network using Google Search and PythonGather all Senior Data Engineer profiles in GreeceNov 25, 2022Nov 25, 2022
Jason TragakisExtend BigQuery NLP armory with StemmersImplement English, Spanish and Greek stemmers using Javascript UDFs.Dec 8, 2022Dec 8, 2022
