A Definitive Guide to Python Stored Procedures in the Snowflake UI
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 […]
Tableau Relationships: LODs
LODs (Level of Detail expressions) are not the easiest topic in Tableau, though they are a glorious one! It took me some time to get the hang of it, but today I don’t want to miss them. What they do – in a nutshell – is move the level of aggregation somewhere that is not […]
Tableau Relationships: Tips and Tricks
There are quite a few tips and tricks out there for Relationships in Tableau; just not nearly as many as for every other topic in Tableau, which is a shame. Nevertheless, this article is supposed to grow over time, and we start with something very simple! Root Swapping What Is a Root Table? Like with […]
A Definitive Guide to Python UDFs in the Snowflake UI
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 […]
Tableau Relationships: Basics – The Ground Rules
Until Tableau version 2020.1, whenever we had two or more tables that we wanted to connect with each other, we had to either join them or blend them. If you aren’t sure about joins, please take a minute and get yourself up to speed. We will need them later on, or rather we need to […]
InterWorks Keeping an Eye Out at Eyeo Festival
The Eyeo Festival can probably be best described by the way in which it was named, which you can find in a Medium article from one of the festival’s founders: “I came up with the name, Eyeo, which doesn’t mean anything specific, but riffs on the idea of eye-opening and I/O at the same time. […]
DataWomen Event Recap: Everyday AI
Information technology is one of the world’s fastest growing sectors. Data, analytics and technology have permeated through all aspects of our lives, and it is safe to say that in all sectors and industries, there are data problems to be solved. Just in Australia, the IT sector is forecast to grow by 5.4% on average […]
Using Snowflake’s Generator Function to Create Date and Time Scaffold Tables
Of the many useful functions available in Snowflake, one of my favourites is the GENERATOR function. This function allows you to create rows of data from nothing and can be useful in many ways. Any time you don’t have physical data to get you started but you know how you want to create it, I […]
Webinar Replay: Driving Adoption with User-Centered Dashboard Development
A video replay for this webinar is available at the bottom of the blog. In this webinar, we go over how to think like a consultant to elevate your dashboarding experience into something enjoyable for both devs and users alike. The Three Principles There are three cornerstones of the UCDD development philosophy that will be […]
InterWorks Blog Roundup – July 2022
I certainly can’t speak for every InterWorker around the globe, but July was a scorching hot month for us in InterWorks’ home state of Oklahoma. The highest we saw at our satellite office in Oklahoma City was somewhere around 114 degrees Fahrenheit (or somewhere around 45 Celsius for our metric friends). While the heat kept […]