Alessandro PuccettiSlots 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
Alessandro PuccettiBigQuery 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
Alessandro PuccettiReal-Time data delivery at scale with BigQueryOriginally published at https://www.puccetti.ioMar 31, 2021Mar 31, 2021
Alessandro PuccettiTime Travel with BigQueryHow to use BigQuery superpowers to rewind time.Mar 9, 2021Mar 9, 2021
Alessandro PuccettiinThe StartupServerless S3 Access Logs Analytics using BigQuery.Originally published at https://www.puccetti.io on May 10, 2020.May 10, 20203May 10, 20203
Alessandro PuccettiBigQuery 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
Alessandro PuccettiinAnalytics 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
Alessandro PuccettiBigQuery 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
Alessandro PuccettiA 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
Alessandro PuccettiGoogle Cloud Composer: Overcoming The Short-living Tasks ProblemOptimising how to run thousands of short-living tasks on Airflow.Jul 15, 2019Jul 15, 2019