Slots to the (Wallet) Rescue | Alessandro PuccettiAt Huq Industries, we collect and process 30 billions geo-events a month from more than 8 million devices. At the time of writing we…Jun 15, 2021Jun 15, 2021
BigQuery Authorized Views with TerraformIn one of my previous blog posts, we have seen how, at Huq Industries, we used authorised views to reduce costs, complexity, and delivery…Apr 13, 2021Apr 13, 2021
Real-Time data delivery at scale with BigQueryOriginally published at https://www.puccetti.ioMar 31, 2021Mar 31, 2021
Published inThe StartupServerless S3 Access Logs Analytics using BigQuery.Originally published at https://www.puccetti.io on May 10, 2020.May 10, 20203May 10, 20203
BigQuery Geography ClusteringThe BigQuery team rolled out support for geography type a while ago and they have never stopped improving performances and GIS (Geographic…Jan 30, 20201Jan 30, 20201
Published inAnalytics VidhyaBigQuery Partitioning & ClusteringIn this blogpost, I will explain what partitioning and clustering features in BigQuery are and how to supercharge your query performance…Jan 21, 20202Jan 21, 20202
BigQuery WildcardsBigQuery supports the “*” wildcard to reference multiple tables or files. You can leverage this feature to load, extract, and query data…Jan 6, 20202Jan 6, 20202
A Journey Through Big Data Using Google BigQueryBack in the early days of Huq we were ingesting a just few millions records per day into our geo-behavioural insights platform. Today that…Aug 1, 2019Aug 1, 2019
Google Cloud Composer: Overcoming The Short-living Tasks ProblemOptimising how to run thousands of short-living tasks on Airflow.Jul 15, 2019Jul 15, 2019