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” for the year. I made the switch a few years […]
Hazards on the Road to Self-Service Analytics
The term “Self-Service Analytics” gets thrown around a lot these days and for good reason. It’s what a driven-driven organization strives for, and at InterWorks, it’s the goal we help our clients achieve. I don’t know if there is a specific definition for self-service analytics, but I tend to think of it this way: In […]
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 of Jason’s post was not on security and […]
Dashboarding is Like Music: Communication
Welcome to our new series, Dashboarding is Like, where we will explore connections between data visualization and other creative pursuits! For our first set of posts, Dashboarding is Like Music, we will delve into the sometimes surprisingly rich relationship between, as the title suggests, dashboarding and music. Though we joined InterWorks about two years apart […]
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: Azure Storage Container – stores files to be ingested into […]
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 to use a Snowflake object called an external stage, which […]
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 aspect of the delivery of BI solutions: the development […]
Setting Up Tableau Dashboard Data Alerts
Data Driven Alerts in Tableau Server and Tableau Cloud is a built-in feature that allows you to tell Tableau Server you want to be notified if your data reaches a set threshold for your business. When they’re set up, data driven alerts can automatically notify people who are subscribed to the alert notification. They can […]
Getting to Know dbt
On a recent project, I heard a colleague recommend dbt and it sounded amazing. Every feature of this product seemed to address challenges I run into on almost every data project. I decided it was time to take a look. Unravelling the Spaghetti As a consultant, I often get introduced to new data sets. If […]
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 a control table and in this post, I will review […]
