Occasionally I needed to choose the greatest or least value from a set of columns during a project in SQL Server and use that value to make another decision in my logic. For example, choosing the most recent or oldest date. Depending on how the data is modeled, this could be relatively simple and useContinue reading “SQL Server: Greatest and Least Functions”
Author Archives: Eric Heilman
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”
Eric Heilman 