{"repo":"analyticsdurgesh/DBT-Project-Pipeline","free":true,"listed":false,"github":"https://github.com/analyticsdurgesh/DBT-Project-Pipeline","clone":"git clone https://github.com/analyticsdurgesh/DBT-Project-Pipeline.git","description":"Public Snowflake and dbt pipeline transforming Blinkit retail sales data into staging and mart analytics models.","language":"Python","stars":25,"topics":["analytics-engineering","data-pipeline","dbt","retail-analytics","snowflake","sql"],"license":null,"category":"data-pipelines","readme_excerpt":"Blinkit Snowflake dbt Pipeline Public portfolio project showing an end-to-end analytics engineering workflow: load Blinkit retail sales data into Snowflake, transform it with dbt, and publish clean staging and mart models for reporting. What This Project Demonstrates - Snowflake warehouse, database, schema, file format, stage, and raw table setup - S3-to-Snowflake raw ingestion pattern - dbt staging model for cleaning raw CSV columns - dbt mart models for fact and outlet-level analytics tables - Schema tests for uniqueness, null checks, and accepted values - Public-safe credential handling with ignored local config files - One-command local runner for bootstrap, dbt build, and row-count checks Architecture dbt Lineage Final Models Layer Model Purpose --- --- --- Source BLINKIT DB.RAW.BLINKIT ORDERS RAW Raw CSV data loaded from S3 Staging STAGING.STG BLINKIT ORDERS Cleaned and typed source records Mart MARTS.FCT BLINKIT SALES Sales fact table with generated sale keys Mart MARTS.MART OUTLET SALES Outlet-level sales and rating summary Repository Structure Public-Safe Credential Setup This public repository does not commit real credentials and does not require environment variables. Create local-only files from the examples: Then edit both local files with your Snowflake and AWS values. These files are ignored by git: - profiles.yml - config/local credentials.json - .user.yml Install Run the Full Pipeline The runner will: 1. Read local credentials from config/local credentials.js","default_branch":null,"files":null,"tree":[],"storefront":"/r/analyticsdurgesh","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/analyticsdurgesh/DBT-Project-Pipeline/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}