Matillion ETL is a GUI-based orchestration and transformation tool for data movement that has many functionalities, including querying external data via API. There are three primary ways to query this data from Matillion ETL: Create a custom Python script to send requests to the API...
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to complete all manner of tasks. For example, external access could be used...
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world and can therefore communicate with external APIs to complete all manner of tasks. For example, external access could be used...
In this blog, I will guide you through various methods to navigate the Matillion Data Productivity Cloud (DPC) Git functionality. The purpose of any Git process is to manage version control in technical/software projects. It allows for work to be contributed to by all involved,...
Sometimes when you’re developing a data pipeline in Matillion ETL, you may find that a component that you’re working on just isn’t behaving as you expect. It might be producing unexpected output, or it might just be behaving in an odd way but with no...
Welcome to Matillion Hub: the main spot for handling your Matillion tools. It's like a control center where you can manage everything easily. In this blog post, we'll talk about how to manage users, discuss the differences between DPC and METL, look at billing and...
Welcome to our journey into the world of AWS automation! In this blog post, we'll be exploring how to automate the start and stop times of Amazon EC2 instances using a combination of AWS services: Lambda, EventBridge and Simple Notification Service (SNS). Managing EC2 instances...
It's officially award season, both in the film industry and for technology consulting partners like InterWorks. On Friday, March 8, our friends and partners at Matillion announced that the InterWorks team won four of their Emerald Partner Network Awards for 2024: Matillion APAC Partner of...
Assist by InterWorks has been helping hundreds of InterWorks clients for years now. Assist got its beginnings as an on-demand, Tableau assistance offering connecting users directly with our consultants. Tableau users could easily hop on a call, wherever they are in the world, and chat...
Last month, Matillion launched the Data Productivity Cloud (DPC). In our introductory blog post, we highlighted how this new SaaS product simplifies managing multiple data sources and performing transformations — all from a single pipeline and right within your web browser. This was made possible...
Following on from the wonderful blog by Fadi Al Rayes, Getting SaaSy with Matillion’s Data Productivity Cloud, we're going to look at the Matillion Agent deployment and why you may want to opt for this solution vs. the automatically deployed agent provided by Matillion. Let’s first...
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,...
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