Blog

Jul 26, 2024

Illustration of three people discussing the comparison between Looker, Looker Studio, and Looker Studio Pro, with charts and graphs in the background.

Understanding the differences between Looker, Looker Studio, and Looker Studio Pro

Jul 16, 2024

Image of a futuristic language model (LLM) represented as a central hub with multiple connections extending to numerous databases, symbolizing the integration and processing power of LLMs in managing and analyzing large datasets.

Leveraging Gemini LLM in BigQuery for Classification Tasks

Jun 20, 2024

Image showing a flowchart: "Custom alerts" box with icons representing data and analysis on the left, labeled "Findings," pointing to the "Google Security Command Center" shield icon in the center, and a security officer with a telescope on the right.

Logging & Alerting Data Product on Google Cloud

Jun 19, 2024

Anomaly Detection with dbt and Elementary

Jun 10, 2024

Illustration of musicians are immersed in a neon-lit environment, symbolizing the flow of data. The scene blends traditional musical elements with advanced technology, represented by musicians wearing virtual reality headsets and digital elements in the background.

Airflow: From Zero to Data Hero

May 29, 2024

How I became Google Cloud Champion Innovator in less than 1 year - by Alex De La Cruz López

May 24, 2024

A large crowd of people gathered in a city square at night, looking up at a massive digital billboard that displays the text 'dbt 1.8' with vibrant, orange bokeh lights in the background.

dbt 1.8 it is just wow

May 24, 2024

An architectural diagram of a production data platform showing a workflow where Cloud Scheduler triggers Cloud Workflows on a recurrent basis, which in turn triggers a Dataform pipeline with a date variable, resulting in SQL transformations in BigQuery.

Dataform and Terraform: Automate SQL pipelines in production

Apr 26, 2024

Refactor your way to Success: A practical guide to dbt Core code Optimization

Apr 23, 2024

Ilustration of a terminal with code and a data contract being validated.

Data Contract CLI — The future of Data Contract definition?

Apr 22, 2024

The image is a three-level diagram categorizing types of logs. Level 1 has "Platform," "Component," "Security," "Multi-Cloud," and "User-Written Logs." Level 2 shows "Access transparency" and "Cloud Audit logs" beneath Level 1, excluding "User-Written Logs." Level 3 details "Cloud Audit logs" into "Admin activity," "Data access," "Policy Denied," and "System events logs." The diagram is titled "Types of logs.

Google Cloud logging: Complete guide on usage and pricing optimization

Apr 15, 2024

Protect your data on Google Cloud with VPC service controls

Apr 5, 2024

The image is a digital illustration of a high-tech data warehouse, depicted as running incrementally with glowing connections between server racks and surrounding infrastructure.

How to change partition column in dbt incrementally without losing any data in BigQuery

Mar 25, 2024

The diagram illustrates a data pipeline starting with code in a Git repository, automated builds in Cloud Build, storage in Artifact Registry, workflow orchestration with Apache Airflow, data modeling with dbt, and querying in BigQuery.

Running dbt in production: Strategy comparison

Mar 18, 2024

Practical FinOps on Google Cloud

FinOps

Mar 14, 2024

A businessman in a modern office analyzing financial growth on a large digital screen showing complex graphs and data. The office has a sleek design with a large window, a desk with a laptop, documents, and a calculator, highlighting a professional and analytical atmosphere

Fastest Integration of Period-Over-Period Comparison in Looker

Feb 22, 2024

Google Cloud Workstations: Crafting the Perfect Development Ecosystem

Feb 19, 2024

A simple GA4 BigQuery model

Feb 9, 2024

Laptop on a desk displaying colorful data analytics dashboard with various charts and graphs, including bar graphs and line charts indicating performance metrics, next to a holder with pencils, all in an office environment with a blurred background

Adding Tooltips to Your Looker Dashboard

Jan 26, 2024

Secure dbt docs and elementary UI with Cloud run and IAP

Jan 22, 2024

Artistic architectural design of a tunnel-like structure with wooden blocks protruding asymmetrically from the walls and floor, leading to an open exit with a view of a misty forest

Bigquery partitioned & clustered table with dbt — Overwrite only what you need

Jan 22, 2024

Futuristic control panel interface with three sections labeled 'Node Selector', 'Affinity', and 'Taint/Tolerance', each displaying holographic structures and connectivity diagrams, symbolizing advanced computing concepts or data processing modules.

Mastering Kubernetes Cluster Management: Node Selector, Affinity, and Taint/Toleration

Jan 19, 2024

Digital 3D illustration of interconnected shipping containers with glowing edges, representing a concept of logistics, networked supply chain, or containerized data center architecture on a dark background.

dbt-loom: Bringing Multi-Project Integration to dbt-core

Nov 20, 2023

An open laptop on a desk displaying a colorful Slack application interface, with a vibrant, abstract backdrop of interconnected clouds symbolizing networked communication and cloud computing

Interactive Slack commands with Cloud Function

Nov 10, 2023

Illustration of a man analyzing a large, interactive analytics dashboard screen displaying various colorful charts and graphs, including bar graphs, line graphs, and pie charts, indicating different data metrics and trends in a business or marketing context, set against a background with abstract shapes and leaves.

Adding Images to Your Looker Dashboard

Oct 31, 2023

A dynamic 3D infographic featuring a colorful circular element with a keyhole at the center, surrounded by rising bar graphs in various colors, suggesting data security and analytics concepts. The background is adorned with scattered geometric shapes, adding to the sense of innovation and digital technology.

Understanding GA4 vs UA gap in E-commerce Analytics

Oct 13, 2023

Isometric digital art of a vibrant cloud computing network. It features 3D icons of databases, servers, and security shields interconnected with lines and set against a dark background with floating clouds, symbolizing a complex and secure data network infrastructure

Leveraging Google Cloud Workload Identity for Seamless Gitlab CI/CD Authentication

Oct 10, 2023

Isometric illustration of colorful 3D bar graphs and abstract data blocks arranged in a cloud environment, representing cloud computing, data management, and digital transformation concepts

Deploy Airflow on Google Cloud Platform using Terraform

Oct 3, 2023

Uncle Scrooge keeping an eye on its organisation's cloud billing activity.

FinOps: Unveiling Clarity in Cloud Cost Management

Sep 29, 2023

Close-up of a female humanoid robot with a partially transparent face showing intricate cybernetic components and circuitry. The backdrop features abstract digital graphics, symbolizing advanced artificial intelligence technology and futuristic concepts.

Towards Autonomous Versatile Universal AI Agents

Sep 7, 2023

A man in a suit is seated at a desk, working on a computer with multiple screens, in a dark room illuminated by complex engineering schematics and digital blueprints that are projected onto the wall in front of him, suggesting a high-tech research or design environment

Data Vault 2.0 — a hands-on approach with dbt and BigQuery (Part 2)

Sep 7, 2023

Digital illustration of a complex network with interconnected lines and glowing nodes, featuring 3D cubes with various bright colors like orange and blue, representing a blockchain network or advanced data structure concept.

Data Vault 2.0 — a hands-on approach with dbt and BigQuery (Part 1)

Sep 7, 2023

A man in a business suit and a humanoid robot with glowing blue eyes are sitting opposite each other at a desk, both using laptops in a high-rise office with a cityscape in the background, symbolizing human-robot collaboration in the workplace.

Building a Custom Robust Retrieval Augmented Generation Chatbot

Sep 6, 2023

Logos of HashiCorp Terraform and Google Cloud side by side, representing the integration of infrastructure as code with cloud services

Authenticate to Google Cloud from Terraform Cloud using workload identity

Aug 30, 2023

Automatize app deployment behind an HTTPs load balancer in GKE using Istio and Terraform on Google Cloud

Aug 28, 2023

Data Analysts in a command centre room analysing BigQuery logs displayed on various Business Intelligence dashboards.

How to get full visibility on your BigQuery workloads

Aug 14, 2023

Midjourney: In a gleaming, high-tech factory of tomorrow, envision AI quality assurance at its finest. Show us a hyper-advanced robotic arm meticulously inspecting and sorting products on a conveyer belt with unparalleled precision and speed. The vibrant neon lights accentuate the futuristic aura of the scene. Futuristic style

AI Code Reviewer: Enhancing Code Review Efficiency with ChatGPT

Jul 26, 2023

Flowchart depicting a data validation process, starting with executing a PodOperator in Airflow, fetching contracts from a bucket, mapping tables in BigQuery, validating schemas with Great Expectations, and ending with sending alerts via a communication channel.

Implementation of the Data Contracts with dbt, Google Cloud & Great Expectations: Part 3

Jul 18, 2023

Illustrative flowchart showing the data contract update process. Data Producers edit contracts and submit a pull request. Data Consumers review and approve it. Changes in the 'Data Contracts Repo' trigger a CI/CD pipeline, which updates and stores the contracts in a versioned 'Data Contracts Bucket'.

Implementation of the Data Contracts with dbt, Google Cloud & Great Expectations: Part 2

Jul 18, 2023

Implementation of the Data Contracts with dbt, Google Cloud & Great Expectations: Part 1

Jul 18, 2023

Midjourney: duck carrying tons of paper running super quickly, visible sweat, incredible speed, in a disney animation 3d rendered style, happy upbeat color palette

Leveraging DuckDB for enhanced performance in dbt projects

Jun 23, 2023

Illustration of a data processing workflow showing stages from 'Ingestion with Airbyte', through 'data contracts with Great Expectations', to 'Transformation with dbt', and leading to various operations like triggering DAG runs, publishing/subscribing, and updating a data catalog

Data Quality with Great Expectations

May 9, 2023

Batch/Online Predictions with Pytorch Hugging Face Models on Google Cloud

Apr 26, 2023

Screenshot of a cloud services expense summary notification. It lists yesterday's total expense as 7.74 CHF, a 23.43% decrease, with a breakdown of costs by product and project. Compute Engine tops the list at 5.81 CHF, followed by costs for Cloud SQL, KMS, and others. The project 'astrafy-gke' incurs the highest cost at 5.91 CHF. Total expenses for the month to date are 35 CHF, a decrease of 56.96%

Google Cloud Expenses Summary Report

FinOps

Apr 6, 2023

Our top dbt packages pick

Nov 11, 2022

Comparison of On-Premise versus Cloud costs depicting On-Premise with high Capex and low Opex, including hidden costs like software licensing, hardware, utilities, cooling, and real estate; versus Cloud with low Capex and high Opex, including transparent costs such as subscriptions, physical security, disaster recovery, IT support headcount, and training

FinOps with Infracost

FinOps

Sep 19, 2022

Diagram of a network setup for an ops project with multiple Terraform-managed services including Airbyte, Lightdash, and Airflow. Features include an Identity-Aware Proxy, load balancer, GKE cluster, and a separate DBT node pool, indicating a cloud-based infrastructure with various data processing tools

Modern Data Stack: One K8S cluster to rule them all

Aug 25, 2022

An image of a dbt Labs certification stating that Charles Verleyen has been awarded the title of dbt Certified Developer. The certificate was issued on August 10, 2022, by Erin Vaughan, VP of Customer Success at dbt Labs, and is set to expire on August 10, 2024. There's also a link to verify the credential online.

dbt certification feedback

Aug 11, 2022

Photograph of a power plant's multiple tall, cylindrical smokestacks against a clear blue sky, with red warning lights on the stacks' rims

Airflow DAG Python Factory

Jul 18, 2022

Diagram depicting a Terraform configuration for Google Cloud Platform (GCP). It shows a multi-provider setup with one main 'Google Provider (ops)' connecting to three separate service account providers labeled 'SA p1', 'SA p2', and 'SA p3', each linked to their own GCP resources within an 'ops' project environment

Terraform provider using multiple credentials

Jul 11, 2022

Flowchart depicting an Airflow Directed Acyclic Graph (DAG) for data processing with stages for ingestion, data quality checks using 'Great Expectations,' followed by dbt run stages for staging layer, data warehouse, and datamart layer. The DAG concludes with optional PubSub, Python, and other unspecified operators for further data operations.

dbt at scale on Google Cloud — Part 3

Jul 4, 2022

dbt at scale on Google Cloud — Part 2

Jul 4, 2022

dbt at scale on Google Cloud — Part 1

Jul 4, 2022

Master your SEO data and don’t let LLMs make your website obsolete

Jul 26, 2024

Understanding the differences between Looker, Looker Studio, and Looker Studio Pro

Jul 16, 2024

Leveraging Gemini LLM in BigQuery for Classification Tasks

Jun 20, 2024

Logging & Alerting Data Product on Google Cloud

Jun 19, 2024

Anomaly Detection with dbt and Elementary

Jun 10, 2024

Airflow: From Zero to Data Hero

May 29, 2024

Master your SEO data and don’t let LLMs make your website obsolete

Jul 26, 2024

Understanding the differences between Looker, Looker Studio, and Looker Studio Pro

Jul 16, 2024

Leveraging Gemini LLM in BigQuery for Classification Tasks

Jun 20, 2024

Logging & Alerting Data Product on Google Cloud

Jun 19, 2024

Anomaly Detection with dbt and Elementary

Jun 10, 2024

Airflow: From Zero to Data Hero