ROW_NUMBER() OVER(PARTITION BY dept_name ORDER BY salary) AS rn, --(123456) RANK() OVER(PARTITION BY dept_name ORDER BY salary) AS r, --(123446) DENSE_RANK() OVER(PARTITION BY dept_name ORDER BY ...

This repository tracks the build of an end-to-end Snowflake data engineering solution—from source data analysis and ingestion design to layered stage/raw/curated modeling, automation with DAG + GitHub ...