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.
ReadConnect to Snowflake from Python with Key-Pair Authentication
Setting up secure, MFA-compatible authentication for Snowflake using Python and Snowpark. This walkthrough covers environment setup, RSA key-pair generation, and connecting to Snowflake without interactive authentication prompts.
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.
Read