Streams and Tasks workflow in Snowflake
Snowflake streams and tasks provide a mechanism for automatically updating one table, as soon as data is loaded into another table. A Snowflake stream tracks...
Martin Palkovic
Howdy! 
I’m Martin. I’m a data engineer, mountain biker and new dad living in Canada.
Posts by Tag
Snowflake
Creating Python stored procedures in Snowflake
A really great feature of Snowflake is the ability to write stored procedures and functions in Python! You can then use these stored procedures or functions ...
Backloading json data to Snowflake using Snowpark for Python
Recently I needed to backload a few years of json data from an API to Snowflake. This felt like a great opportunity to test out Snowpark for Python!
How to shorten large union queries in Snowflake
Recently I was trying to reduce the size of a large union query in Snowflake where the only thing that changed between the queries was the schema name. If yo...
Python
Creating Python stored procedures in Snowflake
A really great feature of Snowflake is the ability to write stored procedures and functions in Python! You can then use these stored procedures or functions ...
Backloading json data to Snowflake using Snowpark for Python
Recently I needed to backload a few years of json data from an API to Snowflake. This felt like a great opportunity to test out Snowpark for Python!
SQL
Streams and Tasks workflow in Snowflake
Snowflake streams and tasks provide a mechanism for automatically updating one table, as soon as data is loaded into another table. A Snowflake stream tracks...
Docker
How I set up my Dev Container for Data Engineering
Dev Containers allow you to open a directory inside of a Docker container and use it as a complete development environment in Visual Studio Code or GitHub Co...
VS Code
How I set up my Dev Container for Data Engineering
Dev Containers allow you to open a directory inside of a Docker container and use it as a complete development environment in Visual Studio Code or GitHub Co...
GitHub
How I set up my Dev Container for Data Engineering
Dev Containers allow you to open a directory inside of a Docker container and use it as a complete development environment in Visual Studio Code or GitHub Co...