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...
If we cast our minds back to April 2021, fans of football around Europe came together to squash the proposed “European Super League” idea, which would see a select few teams played against each other in a closed shop league with no relegation or promotion. The...
In my last blog, I discussed how to do an Upsert in Snowflake using Matillion. Using the same workflow, I will discuss how we got the key value using the MD5 hash functionality available in Snowflake and why we need to do it. The why...
Comparing Upgrades for Different Versions of Tableau I’ve built a Tableau dashboard here to help see the new features between your existing Tableau version and potential planned upgrades. It also includes options for Tableau Server, Desktop, Mobile and Cloud. If you want to know more about why...
A first look at Alteryx Designer Cloud powered by Trifacta. As an Alteryx (Designer) user like me, you have probably heard of Alteryx Designer Cloud powered by Trifacta. If you want to know more about Alteryx Designer Cloud and how it compares to the traditional desktop...
Let’s go deeper and see what happens when we break the cardinality, or in other words, use it in a way it’s not designed for. Also, it helps to understand everything a bit better. For those looking for more of an introduction to performance, you...
Have you wondered how you can venture into the land of data science without being a data scientist? Most of us get intimidated with this idea of writing thousands of lines of code to build a machine learning algorithm. Well, that was true maybe a...
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...
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...
The Introduction I picked this topic to blog about for two reasons. The most important reason is because it’s one of my biggest hobbies. I love to invest, research companies and explore the data associated with them. These things have always interested me, and I noticed...
A video replay for this webinar is available at the bottom of the blog. A lot of analytics tools are fantastic at visualizing data, but they don’t really have a good solution for presenting that data in a clean and effective way. That’s where Curator by...
Fun trivia fact about August you probably learned at school: the month was named after the Roman Emperor Augustus by, well, himself! Actually, all of the English language month names are carried over from Roman naming conventions. I'm a sucker for history, and month names...
Last year's Fantasy Football saw some wild rides, with early favorite Christian McCaffrey injured early and Cooper Kupp going absolutely HAM in PPR especially. COVID didn’t impact the season as much as it could have, fortunately and we’re not likely to see any further major...
Now, let’s look into the second part of the Performance Options: Referential Integrity. What a daunting phrase! Sounds scary, but it’s actually simpler than the Cardinality. With this option, we tell Tableau whether it should expect values to have a match in the other table or...
Snowflake have developed a simple command line tool that can be used to investigate snowflake connectivity issues. This tool's full name is the Snowflake Connectivity Diagnostic Tool, however it is more commonly referred to as SnowCD. If you are seeing connection issues with Snowflake, I would...
Have you wondered how you can venture into the land of data science without being a data scientist? Most of us get intimidated with this idea of writing thousands of lines of code to build a machine learning algorithm. Well, that was true maybe a...
It may happen that we work with really big tables that are not just a few rows but millions or even billions of rows. Tableau’s VizQL’s SQL (what a beginning of a sentence!) has to query all these tables, and that takes time. When we...
From here on out (at least for a few posts), we will have a look into the Performance Options of Relationships that are shown when we design a relation between two tables. If you have no idea what I am talking about, chances are that...
In my last blog, I showed you how to iterate through a variable to bring multiple tables into the raw layer of your data warehouse. Today, I’m going to build on that concept by creating a DIM table and performing an UPSERT. Now, to start,...
The new data model brought us the Logical Layer, from which we can draw specific tables without being forced to load the data from all the related tables. Remember, with traditional joins, all sheets that worked with that join had to load the full data...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072