Tag Archives: data

Snowflake: Getting Started Stored Procedures

I’ve been primarily a SQL Server developer for the majority of my career, but along the way have needed to use a variety of database technologies including Oracle, Vertica, Teradata, PostgreSQL, and several others. A common behavior between them all is the ability to write some flavor of a stored procedure to encapsulate a blockContinue reading “Snowflake: Getting Started Stored Procedures”

Snowflake: Upload to Stage With Snowpark

So far in this series we’ve uploaded files using the Snowsight UI, which has a limitation of 50mb currently. In my experience, not many data files are 50mb or less (even when compressed). For testing and demo purposes, this shouldn’t be an issue; however, in practice, data engineers need to stage files much larger thanContinue reading “Snowflake: Upload to Stage With Snowpark”