SQL
Snowflake EDW Naming Conventions
Consistent and standardized naming conventions can help speed up both development and understanding. It's critical to establish a pattern and while exceptions do occur, make sure it's communicated and followed to the extent possible.
ReadIntegrate Snowflake with Git
Integrating git repos in a data engineering platform can help speed up development cycles and CICD workflows dramatically. In this walkthrough, I'll show how to setup a repo hosted on github to interact with your snowflake environment.
ReadLearning SQL, Part 6 - Joins
This is the sixth article in a series where I'll be walking you through the basics of SQL. In this article, joins are explained.
ReadLearning SQL, Part 5 - Aggregations and Group By Statements
This is the fifth article in a series where I'll be walking you through the basics of SQL. In this article, aggregations and GROUP BY statements are explained.
Read