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...
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...
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...
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...
Data in the real world is a lot messier than we’d imagine it to be. More often than not, working with data will involve multiple sources. For example, you might want to combine two tables, like sales from subsequent quarters. In Tableau Desktop, this is made...
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...
We are beginning to enter a golden age for business intelligence. We have been steadily moving in this direction for the 10+ years I have been involved in the industry, but until now, there always seemed to be some blocker. The volume of data, the...
Video replays for this webinar are available at the bottom of the blog. Today, we’re going to dive into the world of Natural Language Processing (NLP), some popular industry use cases for NLP and how you can leverage NLP in a common business intelligence workflow. Natural Language...
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...
Any data pipeline will fail from time to time. Errors can come from hardware failures, networking issues or simple bugs. Sometimes, an error can occur because somebody forgot to update a password or pay the bill for a cloud service. To keep things running, you...
Many of us have seen the recent news that dbt received another round of funding to continue growing its platform. For those unfamiliar with dbt, now is the perfect time to give you an introduction and discuss how it can play a role in your...
Tableau Prep is a part of the Tableau stack, and many of our users can benefit from having it in their BI portfolio. However, there are a few downsides of using this product users should bear in mind. Knowing what Tableau Prep is not designed...
Over the past few years, InterWorks and our clients have received immense value from Matillion’s data transformation capabilities for cloud data warehouses. Loved by our global team, Matillion has carved out a firm place in our recommended technology stack for organizations of all shapes and...
Recently, one of my colleagues had an interesting issue with a client’s request. The client they were working with was getting a file in a specific structure from their source system. This file was, of course, only available as an Excel export. For simplicity’s sake,...
A regular expression, also commonly known as RegEx (pronounced as /reh-JEKS/), is a powerful text-processing framework that uses a sequence of characters to define a search pattern. It is a widely used method to identify if a pattern exists in a chunk of text, and...
When talking about the “doing” part of data engineering, folks usually want to say something about ETL like, “How are your ETLs running today?” This is a horrible term and even worse in plural form. The new hotness is to flip the “T” and the...
Surprise, surprise … another year in the books. I genuinely contemplated copying and pasting the opening paragraph of last year’s blog, but here I am writing an original opening to close out the decade. Start strong, finish strong, right? And as we begin a new...
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