Snowflake itself is really strong at reporting task schedules and history. If you ever use the TASK_HISTORY table function, you can even view the NEXT_SCHEDULED_TIME for each scheduled task. However, it is common to be in a situation where you are leveraging another tool for your pipeline orchestration,...
In another post earlier this year, we discussed how to store the results of a Snowflake SHOW/LIST/DESCRIBE metadata command in a table. Refresher To refresh our memory, in Snowflake, there are several commands that can be used to retrieve metadata from the Snowflake environment without using a...
We've made it to the tail end of 2022. Holiday season is upon us, and it's fitting that Snowflake is the most blogged about topic for us to share in this edition of the InterWorks Blog Roundup — we randomly had a night of golfball-sized...
I recently read this great post by Sarah Battersby about using QGIS to isolate a specific geography on a map in Tableau. Isolating geography is a great way to draw your user’s attention to the focus area, reduce dashboard clutter and give your map a...
There is a simple and effective way to ingest and transform ad reporting data from multiple platforms by using Fivetran and dbt in tandem. Fivetran is used to ingest the data from a variety of platforms including Apple Search, Facebook, Google, LinkedIn, Microsoft, Pinterest, Snapchat,...
This is the third and last installment of the three-part series on SSO, SAML and user provisioning in general. Today, we’ll focus on SAML and setting up SSO between Snowflake and Azure AD / ADFS. What Is SAML, ADFS, Azure AD, Okta, Etc.? It is useful to...
We are so excited to be launching our new product “Care Quality Analytics” and thought what better way to do this than with a blog and a demo! So, here goes! Let’s first take a look at the why we built this product, you may well...
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...
In diesem Webinar geben wir einen Überblick über einige der exotischeren Charts in der Analysis-Landschaft, und wie wir sie in Tableau Desktop bauen. In diesem Webinar geben wir einen Überblick über einige der exotischeren Charts in der Analysis-Landschaft, und wie wir sie in Tableau Desktop bauen. ...
When building out a Tableau Centre of Excellence, it’s often useful to show the power of the tool using engaging games or apps. The following is a more advanced example of what’s possible to do in Tableau to get users exited about the capabilities of...
Tableau offers many different types of certifications open to anyone who wants to assess their skills in using or implementing Tableau. These are broken down into the following certification categories or types: Tableau Desktop Specialist, Tableau Data Analyst and Tableau Server Certified Associate. These are...
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...
Every Snowflake account comes with a shared database called "SNOWFLAKE" which stores a fantastic amount of account-level and organisation-level information. Most notably, this shared database contains a series of account usage views which covers all of the activity that has taken place in the account. This...
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...
I know the endoplasmic reticulum is a thing. I know the Inuit people have 50 words for snow. I couldn’t tell you what the endoplasmic reticulum does, nor do I know a single Inuit word for snow. But, to a biologist or someone from Nunavut...
Well, spooky season may have come and gone like a ghost in the night, but that doesn't mean we didn't have fun while it was here. Parties, trick or treating and (probably) too much candy marked our scariest time of year, and I think we're...
In this episode of Podcast Your Data, analytics consultants Emily Miley and Jack Hulbert catch up with podcaster, professor, author and journalist Alberto Cairo for the third time on the PYD Podcast to discuss the intersection between data and journalism, Cairo's new book and data...
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...
In the modern analytics stack, data is constantly on the move. While all data originates somewhere, it typically must go somewhere else before it becomes valuable for the data analysts/engineers/scientists. However, when working with pipelines that deal with large amounts of data, it is important...
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