Peter BeckinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceEnhancing Your Data: Historical Weather Data Using Snowflake External Network AccessExternal Network Access is a powerful Snowflake feature that opens up a whole world of opportunities for enhancing your data. External…Aug 3Aug 3
Peter BeckinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceData Governance Using Aggregation Policies in SnowflakeSeveral years ago I spent some time with a Canadian financial institution working with housing price data. This data was provided to us…Jul 3Jul 3
Peter BeckinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceSecuring Columns in Snowflake Using Projection PoliciesProjection Policies are an interesting Snowflake feature that can be very helpful in securing data, but also maintaining the data’s…Jun 16Jun 16
Peter BeckinSnowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data ScienceMonitoring Data Quality using Snowflake Data Metric FunctionsData governance and data quality are top-of-mind in more and more organizations. Snowflake’s Data Trends 2024 report (available here) lists…Jun 10Jun 10
Peter BeckExploring Snowflake Dynamic Data Masking with Conditional Column MaskingSnowflake’s Dynamic Data Masking is a powerful, flexible and easy-to-implement solution for column level security that can greatly simplify…May 291May 291
Peter BeckMaking Life Easier: Time Series Analysis With The Snowflake ASOF JoinTime series analysis can be a little painful in SQL. A not uncommon occurrence for me when I was working with HR data was to have to locate…May 14May 14
Peter BeckSimple — Really Simple — Sentiment Analysis in Snowflake (Part 2)In part 1 of this series we imported some fictional product reviews for sporting goods, and then performed sentiment analysis on the…May 7May 7
Peter BeckSimple — Really Simple — Sentiment Analysis in Snowflake (Part 1)“Sentiment Analysis” generally refers to the machine-learning assisted process of determining the emotional tone of a given body of text…May 6May 6
Peter BeckCreating (and displaying!) a Simple Predictive Model in Snowflake — Part 2In Part 1 of this 2-part series we used Snowflake Cortex ML to create a simple predictive model to predict commercial truck crossings into…Apr 30Apr 30
Peter BeckCreating (and displaying!) a Simple Predictive Model in Snowflake — Part 1Predictive analytics has numerous real-world applications, but structuring a robust data set, creating a predictive model, and publishing…Apr 29Apr 29