On a recent project, I heard a colleague recommend dbt and it sounded amazing. Every feature of this product seemed to address challenges I run into on almost every data project. I decided it was time to take a look. Unravelling the Spaghetti As a consultant, I...
Snowflake is a powerful software that can store data points that are important for auditing the ETL process. This is done by creating a control table, which tracks ETL jobs that have been run and their statuses. There are a variety of methods for populating...
Happy New Year, everyone! We hope you all had a fantastic holiday season and are coming into the new year refreshed and ready for a fantastic 12 months. To cap off 2022, we opted for quality over quantity on the blog front. (It also helps...
In diesem Webinar tauchen wir tiefer in die Formatierung in Tableau Desktop ein und lernen die unterschiedlichen Formatierungsebenen kennen: - Was kann alles formatiert werden, was nicht? - Formatierungshierarchien – warum ändert sich mein Text nicht immer, wenn ich ihn formatiere? - Globale Formatierungen (Worksheets, Dashboards) und Tipps...
Snowflake Secure Data Sharing enables users to provide specific data points to consumers using the same cloud provider within the same region. Providers can share tables, external tables, secure views, secure materialized views or secure user defined functions with consumers. Data sharing is customizable, and...
For those who live by the Benjamin Franklin-inspired mantra "every second saved is a second earned" (or maybe that was actually about pennies?), this Tableau time saver post is for you. It’s incredibly refreshing to know that regardless of whether you have been using Tableau Desktop...
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...
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