The goal is to build an example of a simple data collection pipeline which collects data from multiple customers and uploads the data to Snowflake could look like. The OpenMeteo Api acts as the "customer system" in this case.

End-to-end ETL pipeline for live cricket streaming data using AWS, Snowflake, and Power BI for visualization.

Snowflake DataScience Realtime HandsOn Projects

Designed a cloud-to-cloud migration pipeline through migrating data with event-driven architecture and automated data loads. Implemented data quality checks at each stage, ensuring data consistency and reliability.

This is an end-to-end AWS Cloud ETL project. This data pipeline orchestration uses Apache Airflow on AWS EC2 as well as Snowpipe. It demonstrates how to build ETL data pipeline that would perform data transformation using Python on Apache Airflow as well as automatic ingestion into Snowflake data warehouse via Snowpipe. Also features Power BI.

Analyze real-time global market data using AWS Kinesis and Snowflake. We utilize CSV datasets extracted via API calls, stream them through Kinesis Firehose, and transform them with Snowflake. Our agile workflow ensures efficiency, providing a one stop comprehensive solution for real-time data insights.

Implemented Snowflake project on AWS for efficient data storage and transformation. Utilized JSON-to-CSV conversion, Snowpipe for real-time ingestion, and reader accounts for secure data access. Employed streams, tasks, and materialized views for data synchronization and optimization. Implemented masking policies for enhanced data security.

Automated Snowflake pipeline using Snowpipe, Streams, Tasks, MERGE logic, and AWS S3.

Get the streaming data from the S3 bucket with SQS queue. Load into Snowflake with Snowpipe and modify the data with Snowflake task

Advanced Healthcare Claims Pipeline using Snowflake, Snowpipe, Streams, Tasks, SCD Type 2, and AWS S3. Automates ingestion, CDC, dimensional modeling, and data quality checks for healthcare patient and claims data.

Building a Seamless Data Pipeline with AWS and Snowpipe

Vibecoded Snowpipe Streaming .NET SDK

ETL with AWS Lambda and Snowflake with automation using Snowpipe.

Retail data analysis pipeline utilizing AWS S3, Snowflake, Python, SQL, and Tableau. It demonstrates data transformation and setup in Jupyter Notebook, integrates real-time retail insights via an automated Tableau dashboard with Snowflake, and employs a CRON job in Jupyter Lab connected to Amazon SQS for consistent data updates.

This project demonstrates a fully automated ETL pipeline built on AWS Cloud to extract playlist data from the Spotify API, transform it using AWS Glue (Apache Spark), and load it into Snowflake for analytics and visualization via Power BI.

Automatically move data from AWS S3 to Snowflake datawarehouse continuously with snowpipe

Source code and files for Projects I have worked on.

Automated Data Loading in Snowflake using Snowpipe (End-to-End Implementation).

Generating Streaming Data for Snowpipe Streaming