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…6 min read·Jun 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…2 min read·Apr 13, 2021----
Alessandro PuccettiReal-Time data delivery at scale with BigQueryOriginally published at https://www.puccetti.io4 min read·Mar 31, 2021----
Alessandro PuccettiTime Travel with BigQueryHow to use BigQuery superpowers to rewind time.2 min read·Mar 9, 2021----
Alessandro PuccettiinThe StartupServerless S3 Access Logs Analytics using BigQuery.Originally published at https://www.puccetti.io on May 10, 2020.6 min read·May 10, 2020--3--3
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…2 min read·Jan 30, 2020--1--1
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…5 min read·Jan 21, 2020--2--2
Alessandro PuccettiBigQuery WildcardsBigQuery supports the “*” wildcard to reference multiple tables or files. You can leverage this feature to load, extract, and query data…2 min read·Jan 6, 2020--2--2
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…3 min read·Aug 1, 2019----
Alessandro PuccettiGoogle Cloud Composer: Overcoming The Short-living Tasks ProblemOptimising how to run thousands of short-living tasks on Airflow.5 min read·Jul 15, 2019----