From its inception, Snowflake has always supported the ANSI standard version of the SQL language. As much as we may enjoy using SQL to manipulate data – how cool is it to write in a language based on something called lambda calculus? Still, it doesn't quite...
The purpose of this post is to step through the processes involved in setting up a new Snowflake account to replicate an existing one. There are several reasons to do this, the main two being: Fully migrating to a new account, for example if you...
We've all seen situations where, for whatever reason, we have more data than we need in a table and we want to deduplicate. There are plenty of reasons for this, from dodgy ingestion processes to deliberate intent. Without diving into the "why" of it all,...
Well, we survived the heat of the summer! With autumn on our doorstep and the summer heat finally breaking here in the northern hemisphere, our US and EMEA teams are looking forward to dusting off our boots, jackets and pants again. For me, personally, I'll...
This is the second part of the three-part series on SSO and user provisioning. This one is a follow up on my previous post, which went over the core concepts of how SSO (and SCIM) work. Now we are going to delve deeper into actually...
Single sign on is something we take for granted (I certainly have), mostly because it seems to just work or perhaps I've just been lucky? Sure getting the login and account can be a challenge and take a bit of time; but once you’ve got...
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their...
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...
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their...
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their...
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...
Snowflake have developed a simple command line tool that can be used to investigate snowflake connectivity issues. This tool's full name is the Snowflake Connectivity Diagnostic Tool, however it is more commonly referred to as SnowCD. If you are seeing connection issues with Snowflake, I would...
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their...
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their...
Of the many useful functions available in Snowflake, one of my favourites is the GENERATOR function. This function allows you to create rows of data from nothing and can be useful in many ways. Any time you don't have physical data to get you started...
I certainly can’t speak for every InterWorker around the globe, but July was a scorching hot month for us in InterWorks' home state of Oklahoma. The highest we saw at our satellite office in Oklahoma City was somewhere around 114 degrees Fahrenheit (or somewhere around...
Disclaimer: The author is solely responsible for views and opinions in this article. Snowflake Summit 2022 was a success. Enough has already been written about what came out of it and the exciting new announcements, so I will not be repeating any of that. Instead, this...
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...
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...
2022 is shaping up to be a fantastic year for the InterWorks team, and we have another reason why: InterWorks was just named the 2022 Snowflake APJ Innovation Partner of the Year! This award recognizes excellence in formulating unique and effective solutions to help clients...
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