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...
Spooky season has come and gone, but you can rest assured you'll find nothing but treats here! October on the blog saw 17 new blog posts with contributions from over 20 InterWorkers, kicking off the final quarter of 2021 strong. We have lots of resources to...
When using Matillion to load data into Snowflake, temporary stages are often created in Snowflake to store the data before it lands in the destination table. Often, this is not an issue as Matillion provides a handy load option called "Clean Staged Files," which cleans...
Remote git integration is a way of backing up a local git repository to an online git management provider, such as GitHub, GitLab or Azure DevOps. If a customer has multiple Matillion instances for any reason, this also allows them to make changes on one...
This is a walkthrough for adding a task that automatically starts the Matillion instance at a certain time and another task that shuts down (deallocates) the resources of the Matillion instance via an API endpoint. These two tasks are intended to be deployed in Azure...
And just like that, another month gone! September on the blog saw 13 new posts and 18 contributors, and a lot of this month's focus was on security, convenience and recognition of individual contributions to the data community and beyond. It was a fun month,...
Often when working with Matillion Support or investigating other Matillion issues, you will need to retrieve the logs from the Matillion virtual machine. This could be for several reasons, including: The logs available through the UI may be trimmed whilst the virtual machine itself stores...
There are various reasons you may wish to access the backend of a Linux virtual machine. In regards to a Matillion server, which is hosted on a Linux operating system, this could be for a variety of reasons, including but not limited to: Retrieving historic...
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