Welcome back, welcome back, readers! This is, as you can tell from the title, the InterWorks Blog Roundup for March of 2024. Yes, I just read the title back to you for word count purposes. No, I will not apologize. Anywho, we're listing out here all...
To best use ThoughtSpot, we need to have a good understanding of the data structure being used. The best way to work with that data is in ThoughtSpot’s data pane. In the data pane, we need to connect to a data source (in our case...
Snowflake is like that friend who's always got something new up their sleeve! Snowflake is all about staying up-to-date and cool, regularly spicing up its lineup of awesome features to keep up with the changing times in the world of data. So, in this blog...
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...
From its inception, Snowflake has always supported the ANSI standard version of the SQL language. As much as we may enjoy using SQL to manipulate data – how cool is it to write in a language based on something called lambda calculus? Still, it doesn't quite...
In the modern analytics stack, data is constantly on the move. While all data originates somewhere, it typically must go somewhere else before it becomes valuable for the data analysts/engineers/scientists. However, when working with pipelines that deal with large amounts of data, it is important...
Joins—they are happening everywhere. That’s actually a cool tagline! And it’s definitely true. I haven’t encountered a data warehouse, a data lake or a BI tool that didn't include some sort of join somewhere. But I also know there are a lot of explanations about...
Today, I will cover how to make these two great platforms, Tableau and Amazon Athena, work together in just a few steps. We will be using the guides provided by AWS and Tableau as reference points to effectively open a connection from Tableau to a...
In Snowflake, there are several commands you can use to retrieve metadata from the Snowflake environment without using a virtual warehouse. The following are all examples that fit this approach: SHOW - List all objects of a certain type within the account or within a given...
Often when using grid variables in Matillion, the order of the values is important. For example, you could be iterating through the values of a grid variable sequentially using the Grid Iterator component and need the iterations to complete in a desired order. You may even have...
If you're working with a bunch of sources within your dbt project, maintaining a single-source file (or even a couple) can quickly become cumbersome to manage, especially if you have multiple people editing and committing changes to the same file. It is much better to have...
After you’ve finished setting up your dbt environment and begun working in dbt, you may find that you’ll need more than just the basics. As mentioned in The Transformational Power of dbt in Analytics, dbt allows data teams to leverage the capabilities of software engineering teams. Here,...
In our last post, we talked about the differences between dbt Cloud and dbt Core. Once you’ve decided which environment works best for your team, it’s time to start development. In this post, we’ll walk through some of the basic setup of dbt and briefly...
One question we often get when a customer is considering moving to Snowflake from another platform, like Microsoft SQL Server for instance, is what they can do about migrating their SQL stored procedures to Snowflake. If you’ve read Snowflake’s documentation on the subject, you’ll know that Snowflake’s stored...
Various people come by our house, whether it be someone delivering mail, an Amazon Prime package or from the utilities. However, there are times when people try to come by who are not wanted. It is our responsibility to ensure that we do not give...
As a Snowflake user and a Python enthusiast, I was very happy to learn that Snowflake has created its own Python package to connect to Snowflake and execute commands. As these commands are executed locally and transmitted to Snowflake, the full SnowSQL functionality is available...
There are things in this world that data engineers love and hate. For example, they love green and hate red. Green is good, but when you see red, the ETL job is dead! Data engineers also love seeing the word “success” because it subconsciously triggers...
The Evolution of InterWorks Assist InterWorks Assist was launched back in 2016 for clients who needed quick, personal attention to their requests via email. As the offering continued to grow, we thought about how we could make it even easier for clients to access our experts. Introducing...
After attending an in-depth technical training in Dallas, Texas, I thought it could be beneficial to give some examples of how Snowflake is unique in a series of blog posts moving forward. This week, I’m talking about JSON (although Snowflake’s functionality displayed in the article...
I rarely ever receive pristine data, and I’d wager that’s true for most of us working in data analysis or business intelligence. Data can come to us from dozens—if not hundreds—of sources, and it certainly requires some preparation to make it useful. One of the...
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