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...
In this post, we're launching a new blog series that will take a closer look at what makes good analytics. We'll attempt to home in on various facets of the analytics experience, from the perspectives of developers and end-users alike, and walk through tested methods...
InterWorks takes a lot of pride in both the quality of our work and the quality of our partnerships, and one of our favorite partnerships happens to be with Snowflake. For the past few years, we’ve worked closely with Snowflake to transform how organizations across...
Why do some businesses fail while others succeed? What are the factors that determine their outcome? Answering questions like these is why I’ve chosen a career as an Analytics Consultant. I’ve always been fascinated to learn what drives business outcomes and one of the best...
Ever wondered how to create a circle object on a two-dimensional plane in Snowflake? Among others, here are a few reasons that you may wish to do this: Depicting socially distanced locations on a floorplan Displaying the range or "trade area" from a delivery depot ...
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...
In this webinar replay, Graham Beales, Head of Business Intelligence at Greater Manchester Health and Social Care Partnership, guided us through the challenges they faced when devolving from the NHS and the development of their tech stack. Graham discusses the future vision and how to...
In Snowflake, there are several commands you can use to retrieve metadata from the Snowflake environment without using a virtual warehouse. The following are all examples that fit this approach: SHOW - List all objects of a certain type within the account or within a given...
Wow! What a great conference dbt put on this month. The conference gave us great insights into some work a few dbt enthusiasts are working on. Let’s dive into some of my favorite topics covered during the conference. For those of you who missed it,...
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...
We’re proud to share some exciting news on the cloud data front: InterWorks is now a Snowflake Elite Tier Partner. What does that mean, and why does it matter? The short of it is that InterWorks now holds Snowflake’s highest partner distinction, and entering this...
Network policies don’t exactly sound like a fun subject. Indeed, the phrase conjures an image of a big committee, a gavel being banged repeatedly and some very stern looking folks saying “No” a lot. Instead, I want to show that this function of Snowflake is...
By now, we’ve all seen the blazing speed of Matillion workflows, but we always want more, right? Let’s talk about how to get even more speed from your already-lightning-fast workflows, and – while we’re at it – let’s talk about how to save a few...
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...
Key pair authentication is a method of authenticating with a system using a pair of keys that meet specific security requirements. The pair consists of a private key that is leveraged by the system trying to authenticate and a related public key that the authenticator...
Another month, another roundup! In August, we published 14 new pieces of content and featured 20 contributors to the blog, including a couple first-time bloggers! Our team shares all kinds of data tidbits and new knowledge, from a mini-series on the emerging power of dbt...
The year 2020 produced a mass migration of business processes, enterprise software and internal workloads to AWS in a way that was previously unseen. In the world of data, organizations relied on the flexibility of the cloud to run infrastructure, authentication and analytic workloads at...
Row-level security (RLS) is a data access control concept that pertains to dynamically restricting the rows of data that a certain user can access in a particular dataset. Over the course of my consulting career, I have encountered this business requirement on numerous occasions, such...
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