InterWorks were delighted to hear that NHS Greater Manchester Integrated Care has earned a Matillion Emerald Award as a Visionary in 2023. NHS Greater Manchester is helping organisations work better together with people and communities. Professionals are working together across sectors, sharing skills and knowledge as...
BOO! Did I scare you? Of course I didn't, it's November already. You're immune to scary things now. With Halloween in the rear view mirror, the only scary things that should be happening for the rest of the year are Black Friday and holiday dinners with...
What Are Variables? If you have ever done any programming, and since you are reading this blog post you most likely have, you will be familiar with the concept of variables. They are these little helpers in which you can store almost anything, except any physical...
Step right up, data enthusiasts! Get ready to kick up your heels and waltz into a world of simplified access, unbridled fun and electrifying efficiency with OpenID Single Sign-On (SSO) for Matillion ETL! Prepare to groove to the beat of seamless authentication, enhanced security and...
What are the differences or similarities between Matillion and Alteryx Designer? Both Matillion and Alteryx are popular low-code/no-code tools that help with data transformation and integration, so it’s no surprise we have to clarify these two tools with clients from time to time. While on the surface...
2022 was a massive year for the InterWorks Australia team, and we’re thrilled to cap it off with the news that Matillion just named us their ANZ Partner of the Year for 2022! We have a strong relationship with Matillion globally, but our Australian team...
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...
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...
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,...
You can mark your calendars: we’re officially halfway done with 2022. We’ve been winding down the data conference season this month by attending Snowflake Summit 2022, Alteryx Inspire 2022 and the Dataiku Everyday AI Conferences in both New York City and London. While we certainly have...
Our relationship with Matillion has been incredibly strong these past few years, and that relationship just reached new heights. We’re proud to announce that InterWorks is now a Matillion Global Platinum Partner! This is the highest partner designation in the Matillion Partner Network, and we’re...
If you have spent any time working with data, you know that it’s rare when you only have a single table to move. While there are several ways to move tables around, I thought it might be a good idea to share with you a...
Snowflake Summit has returned to an in-person event format, and we are excited to see everyone in Las Vegas! It has been a long time since we have seen everyone, and this year is poised to be a great event. We'll have numerous InterWorks partners...
I thought I would step away from my usual style of blogs today. The vast majority of my blog posts in the past have been written to achieve a specific technical goal, and you can think of them as guides or how-to’s. Today, I'd like...
Wow, this year sure is flying by. It seems like just yesterday that we were accidentally writing “2021” on the date line. For some of us, that was literally yesterday. No, I will not be naming any names. I will, however, look into the mirror...
Recently, I came across a request from a member of the Matillion community to leverage the values of a Matillion grid variable in a SQL Script component. To be more precise, they had populated a grid variable with a list of values and wanted to use...
If you ever want to ingest data from an Excel file into Snowflake using Matillion, you can do so with the Excel Query component. If you know the name of the sheet you want to ingest, you can simply enter the name into the component and...
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...
And just like that, the first quarter of the year is nearly finished! We've been busy here at InterWorks, dreaming up new ways to expand products like Curator by InterWorks and strategizing around how to enhance the agility, efficiency and impact of data and tech....
Matillion is a versatile ELT tool. It has many connectors to numerous data sources already at our disposal, but sometimes a situation arises when your use case is a little bit different than just data extraction—for example, extracting a list of files from a remote...
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