My Learning Space
Space to take notes, learn and share.
Snowflake Object Model
The Snowflake object model is a hierarchical framework that organizes and manages data within the Snowflake cloud data platform . An "object" itself refers to a logical container or structure that is used to either Store data, Organize data, or Manage data. From the...
Exporting GA4 data from BigQuery to Snowflake
Exporting GA4 data from BigQuery to Snowflake In a previous article, we have already explored how to export data grom GA4 to BigQuery. In instances, where we want to migrate data from BigQuery to another platform like snowflake, BigQuery offers a few options. BigQuery...
Implementing tests in DBT (Data Build Tool)
Data Build Tool ( DBT ) offers functionalities for testing our data models to ensure their reliability and accuracy. DBT tests help in achieveing these objectives . Overall, dbt testing helps achieve these objectives: Improved Data Quality: By catching errors and...
Creating data pipeline with dbt & snowflake
In this article we will follow along complete dbt(Data Build Tool) bootcamp to create an end-to-end project pipeline using DBT and Snowflake. We begin by outlining the steps we will be performing in this hands-on project. 1.Loading Data from AWS to Snowflake: Data...
Architectural patterns for managing slowly changing dimensions
What are SCDs ? Slowly Changing Dimensions (SCDs) are an approach in data warehousing used to manage and track changes to dimensions over time. It plays an important role in data modeling especially in the context of a data warehouse where maintaining historical...
Association Rule Learning in Marketing Analytics
Association Rule Learning is used to find relationships between items or events in large data sets. The primary goal of Association Rule Learning is to identify frequently occurring patterns in data to reveal hidden relationships. How Association Rule Learning works?...