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...
Hello, 2022! Another year is here, and we're excited to discover all of the new changes and innovations it will bring. Our last month on the blog featured 15 new posts and 16 contributors and covered lots of foundational tips to start the new year...
This post does not cover all of the functionality of Git as there is far too much content to cover. You can find a far more comprehensive overview of all of the functionality by directly reviewing the Git documentation. The objective of this post is to...
The InterWorks team will be providing updates to this blog as we continue to work on vulnerability remediation with our customers. (Last Updated: 12/23/2021 3:00 PM CST) Overview The morning of December 10, 2021, our team became aware of a Java web server vulnerability known as log4shell that...
Another day, another blog roundup! The fall harvest season here in the U.S. has overflowed into content production at InterWorks. With one of our favorite events of the year - Tableau Conference - falling this month, November really does kick off the most wonderful time...
This post covers how to automate the fetching and pushing of a Matillion project's local git repository with its remote counterpart and uses the Bash Script component to do so. If you would prefer, I have also written a similar post which leverages the Python Script...
This post covers how to automate the fetching and pushing of a Matillion project's local git repository with its remote counterpart using the Python Script component. If you would prefer, I also have a similar post that leverages the Bash Script component. Requirements Your Matillion project...
When following this content, I would recommend first reading through the following two posts: How to Access a Linux Virtual Machine (e.g. Matillion Server) via SSH from Windows How to Configure Remote Git Integration for Matillion Leveraging SSH Keys These two posts have been written to...
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