Native Snowflake Connector for Google Analytics
At InterWorks, we regularly build data pipelines for customers that include tools for migrating and transforming data such as Fivetran or Matillion. Tools such as these have connectors for many common sources of data to save us the hassle of building and maintaining our own scripted solutions. Snowflake have developed their own set of connectors, […]
IT Sales Simplified: Recap and Lessons Learned
In this episode, InterWorks Content Manager Garrett Sauls sits down with IT Intern Genna Callahan to review what she learned over the course of her IT Internship, and how she feels about continuing her internship through through the fall.
InterWorks at CDAO Melbourne 2024
InterWorks recently attended CDAO Melbourne 2024, a three day event that took place on September 2-4, 2024. Featuring keynote speakers, panel discussions and interactive workshops, the conference addressed topics like data governance, culture and transformation. We had a great time there, and loved to interact with the over 600 registrations, with more than 400 attendees […]
How I Played the Long Game with InterWorks
I’m writing this post after all of eight days on the InterWorks payroll, but I’m not exaggerating when I say that walking into the office already feels like a homecoming. I learned about InterWorks a few years ago when I got involved at my local community theater and made a forever friend, Renae Perry, who […]
Lateral Thinking in Games and Data
Or, What Nintendo’s Game Boy has to do with Analytics Back before the success of the Nintendo Switch or the motion-controller craze of the Nintendo Wii, there was a device that encapsulated a central driving philosophy of Nintendo and was key to its long-term success in the video game industry. Like other elementary-aged kids of […]
Mutation Testing: An Unknown Known Solution in Software Development
We All Suck at Something I want to let you in on a journey I’ve been on lately, just in case it can be as profound for you as it has been for me. Picture this: You’ve been in auto racing for decades. You were self-taught in the beginning, quickly won several big races, led […]
Hardening Snowflake Security with Network Rules and Policies
An important step towards ensuring the security of your Snowflake account(s) is the appropriate use of network rules and policies to prevent unauthorised access. These policies are leveraged to ensure that access is only allowed through restricted methods and to/from exclusive sources. Without this protection, you have one less wall to prevent potential bad actors […]
A Use Case for Rank Dense in Tableau
Oftentimes, I find myself in training or enablement sessions, showing the full list of possible functions available to use in Tableau. It’s quite a list of possibilities that starts with ABS (for the absolute value of an integer) and runs through the ZN (zero null function) — they run alphabetically top to bottom from the […]
InterWorks Blog Roundup — August 2024
Welcome, dear readers, to the August 2024 Blog Roundup. Up here in the Northern Hemisphere, kids are back and school and the heat of the summer has finally broken. Fall’s on the horizon (until Indian Summer shows up in a week or two and we’re all sweating again…) First, my usual music recommendations, then on […]
How to Use MIN_BY / MAX_BY in Snowflake
If you are familiar with SQL, you would be familiar with the concept of aggregate functions. For those who are still a bit fuzzy on what these aggregate functions intend to do, here’s a quick couple of quick examples: When you want to find the total sales of all the product categories in your sales […]