InterWorks Causes: Food Insecurity in Oklahoma
Giving back is a major component of the InterWorks philosophy. Being deliberate and encouraging employees to spend time in the community to help organizations and causes they are passionate about is equally important as growing our business. Above: InterWorkers volunteer at the Regional Food Bank of Oklahoma. Throughout 2022, many employees from our Oklahoma offices […]
9 Tableau Desktop Time Savers
For those who live by the Benjamin Franklin-inspired mantra “every second saved is a second earned” (or maybe that was actually about pennies?), this Tableau time saver post is for you. It’s incredibly refreshing to know that regardless of whether you have been using Tableau Desktop for seven years or seven months, you can always […]
Snowflake with Python: Determine Next Event from CRON with a Python UDF
Snowflake itself is really strong at reporting task schedules and history. If you ever use the TASK_HISTORY table function, you can even view the NEXT_SCHEDULED_TIME for each scheduled task. However, it is common to be in a situation where you are leveraging another tool for your pipeline orchestration, such as Matillion, and may have set up a monitoring […]
Using a Python Stored Procedure to Execute Snowflake Metadata Commands into Tables (SHOW/LIST/DESCRIBE)
In another post earlier this year, we discussed how to store the results of a Snowflake SHOW/LIST/DESCRIBE metadata command in a table. Refresher To refresh our memory, in Snowflake, there are several commands that can be used to retrieve metadata from the Snowflake environment without using a virtual warehouse. The following commands are all examples […]
InterWorks Blog Roundup — November 2022
We’ve made it to the tail end of 2022. Holiday season is upon us, and it’s fitting that Snowflake is the most blogged about topic for us to share in this edition of the InterWorks Blog Roundup — we randomly had a night of golfball-sized snow clumps roll in out of nowhere at the beginning […]
Using Mapbox to Make Better Maps in Tableau
I recently read this great post by Sarah Battersby about using QGIS to isolate a specific geography on a map in Tableau. Isolating geography is a great way to draw your user’s attention to the focus area, reduce dashboard clutter and give your map a nice, clean feel. For example, if you were building a […]
How to Use the Fivetran + dbt Ad Reporting Package
There is a simple and effective way to ingest and transform ad reporting data from multiple platforms by using Fivetran and dbt in tandem. Fivetran is used to ingest the data from a variety of platforms including Apple Search, Facebook, Google, LinkedIn, Microsoft, Pinterest, Snapchat, TikTok and Twitter. Then a dbt model created by the […]
Configuring Azure Active Directory SSO for Snowflake
This is the third and last installment of the three-part series on SSO, SAML and user provisioning in general. Today, we’ll focus on SAML and setting up SSO between Snowflake and Azure AD / ADFS. What Is SAML, ADFS, Azure AD, Okta, Etc.? It is useful to understand what SAML is in the context of […]
Care Quality Analytics
We are so excited to be launching our new product “Care Quality Analytics” and thought what better way to do this than with a blog and a demo! So, here goes! Let’s first take a look at the why we built this product, you may well be familiar with the Care Quality Commission (CQC), an […]
A Definitive Guide to Creating Python UDTFs in Snowflake Using Snowpark
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their own Snowflake environment. I would understand if you wanted to […]