Channel
Snowflake Tag
Understanding Snowflake Alerts and Notifications
Establishing customer trust and satisfaction is crucial for any business, and observability plays a major role in achieving this goal. In fact, it is one of the top trends in the data landscape. To enable more observability and measurability of data workloads, Snowflake has been...
InterWorks Blog Roundup — April 2023
April showers bring may flowers, but what do may flowers bring? Pilgrims! Never figured out if I should be telling that joke in April or November for Thanksgiving, but I figure that it’s timely enough either way! We had some great blog content this month. I’ll go...
Trigger Snowpark Functions When Files Are Uploaded to Azure Storage
In previous articles in this series, we have demonstrated how to set up Azure Functions to leverage Snowpark for Python. This allows us to interact with Snowflake from an Azure Function, unlocking a wide range of opportunities for scripting activity. In this article, we will focus...
InterWorks Blog Roundup — March 2023
Clocking in at 28 blog entries this month, March was easily one of the most jam-packed months we've had on the InterWorks blog. I feel like I've written that exact same intro several times since I took over compiling these monthly roundups, but the number...
Event Recap: Snowflake Data for Breakfast
Snowflake recently held their 2023 Data for Breakfast series in Australia. InterWorks was a black diamond partner for two events in the series (Perth and Melbourne), and I was lucky enough to attend both of these events and present on behalf of our amazing company...
How to Install the Snowflake Python Connector in AWS Lambda
If you've ever tried running SQL queries against Snowflake from an AWS Lambda function using Python, chances are you may have run into an error message like this: ⛔️ No module named 'snowflake' Fear not, there's a simple solution you can apply in no time. In this...
API Access Using Snowflake External Functions and Azure
Welcome back to our mini-series on Snowflake External Functions with Azure. Before we proceed, please read the previous post on how to set up these functions and how Snowflake interacts with Azure: A Definitive Guide to Setting up Snowflake External Functions with Azure Why Choose an...
A Definitive Guide to Setting up Snowflake External Functions with Azure
As you may be aware, Snowflake has a cool feature which allows its standard functionality to be extended through the use of external functions. Among several other capabilities, this includes the ability to leverage Azure Functions within Snowflake. This unlocks a whole new realm of...
Quick Start Guide: Connecting VSCode to AWS
There are several ways to develop, debug and deploy serverless applications to Amazon Web Services (AWS). One of my favorite tools to achieve this locally is the AWS Toolkit for VSCode because it streamlines the application development process in a simple and pain-free manner. For...
InterWorks Blog Roundup — February 2023
February may be the shortest month of the year, but it's definitely been one of the busiest here at InterWorks! There's 28 days in the shortest month, but we've got a whopping 25 blog posts here for your review. You'll notice that there's a new...
Automated Ingestion from AWS S3 into Snowflake via Snowpipe
To stream/ingest data automatically from an AWS S3 bucket into Snowflake using native functionality, Snowpipe is likely the solution you're seeking. We do have two related posts you can explore for related content: Configuring Storage Integrations Between Snowflake and AWS S3 Automated Ingestion from Azure...
Configuring Storage Integrations Between Snowflake and AWS S3
To ingest data stored in AWS S3 into Snowflake, you can use either direct COPY INTO statements or a Snowpipe for automation. Both options require a Snowflake object called an external stage to connect Snowflake to AWS. It's recommended to use Storage Integrations for authentication...
Using Azure Key Vault to Authenticate Snowflake with Python
This article is builds on the following two previous articles: Intro to Azure Functions and Snowpark: Populating Snowflake Control Tables Using Azure App Settings to Authenticate Snowflake with Python The above articles do a great job at building a foundation for building Azure Functions that leverage...
InterWorks Blog Roundup — January 2023
New year, new me! Tired of hearing that one yet? It's the time of year to start (and potentially abandon) your New Year's Resolutions. If you're kinda over the whole trend, I recommend this video from CGP Grey that replaces a single resolution with "Themes"...
Using Azure App Settings to Authenticate Snowflake with Python
Earlier this month, my colleague Jason Hoehn published the following article: Intro to Azure Functions and Snowpark: Populating Snowflake Control Tables Jason's article did a great job at building a foundation for building Azure Functions that leverage Snowpark for Python to interact with Snowflake. However, the focus...
Automated Ingestion from Azure Storage into Snowflake via Snowpipe
If you wish to automatically stream/ingest data from an Azure Storage container into Snowflake, using native functionality, you will most likely be considering what is commonly referred to as a Snowpipe. In real terms, a Snowpipe for Azure is actually a combination of multiple components: ...
Configuring Storage Integrations Between Snowflake and Azure Storage
If you have data stored in an Azure Storage container and wish to ingest it into Snowflake using native functionality, you will most likely be considering either direct COPY INTO statements or an automated Snowpipe to ingest the data. Both of these options would expect...
Scripting Made Easy with ThoughtSpot Modeling Language
If you’ve heard about ThoughtSpot, you are probably as excited as we are here at Interworks about its potential. If you are not too familiar with this tool I’d strongly suggest this article series. Several of our clients in Sydney and Melbourne all agree on one...
Intro to Azure Functions and Snowpark: Populating Snowflake Control Tables
Snowflake is a powerful software that can store data points that are important for auditing the ETL process. This is done by creating a control table, which tracks ETL jobs that have been run and their statuses. There are a variety of methods for populating...
