Assist by InterWorks has been helping hundreds of InterWorks clients for years now. Assist got its beginnings as an on-demand, Tableau assistance offering connecting users directly with our consultants. Tableau users could easily hop on a call, wherever they are in the world, and chat...
I was doing some performance tuning for a client recently, trying to improve their query performance from a SQL Server Parallel Data Warehouse. As part of the benchmarking process, I compared performance of a classic star schema (separate fact and dimension tables) with a single...
Hey, howdy, hey readers! Welcome back to our monthly blog roundup, where we're going to list out all of the blogs we published in February for your easy perusal. Scroll through, find a blog that tickles your fancy, and read on! Or, you just came...
What Is Data Virtualization? Data virtualization is an approach to data integration that can be thought of as an alternative to the more common ETL/ELT + data warehouse based approach. With data virtualization, the source data is left in place and accessed on the fly as...
This is the second and last part of the series on managing Snowflake users and roles via Okta. In our first part, we introduced a user named John Doe in Okta and assigned him the attribute DATA_VIEWER. Our Okta Rule then zipped John right into an...
In an insightful blog series, my colleague Danny dived into setting up SCIM and SSO with Azure Active Directory (AAD) - a must-read for organizations using AAD for managing Snowflake users and roles. AAD's popularity is clear, but it's not without workflow challenges, especially since high-level Azure roles such as Group...
Welcome to the blog recap for January! You may ask yourself, "Mark, my friend, it's already halfway through February. Why are you just now getting to recap January?" To that, dear reader, I would say, "We already did this bit with the hypothetical reader and the...
Snowflake and Azure are incredibly capable of storing data securely. You can see all reports available to customers through their pages of security and compliance reports for both Azure and Snowflake. This is fantastic for data stored in the platform, though we must still consider how...
Securely Loading Data into Snowflake In a previous article, I wrote about how to configure AWS PrivateLink to work with Snowflake so that your employees can access your favourite data warehouse in a secure manner. In this article, we’ll go one step further: loading data. But let’s...
Row Access Policies are a convenient way to apply row-level security to multiple tables or views in one go. You simply create one policy and can apply that to as many objects as you like. Best of all, if you need to make adjustments, you...
I've been a huge fan of Streamlit for years as it enables analysts and data scientists to easily create interactive web apps without the hassle of managing a backend development. I was always happy to read the announcements of new Streamlit features being released and...
Happy holidays, loyal readers! I thought about lacing this whole intro with subtle references to common holiday season slogans ("It's the most wonderful time of the year, isn't it?" for reference), but I figured that might be a bit too cliche. I'll spare you. This year...
Snowflake and Azure are incredibly capable of storing data securely. You can see all reports available to customers through their pages of security and compliance reports, for both Azure and Snowflake. This is fantastic for data stored in the platform; though, we must still consider how...
Earlier this year, Snowflake released Column Lineage functionality into general availability to much applause from data governance champions. Now hang on – I know data governance doesn’t have the most gravity as a reading topic, but I promise this will be worth it. In fact, I’ll...
Organizations are constantly collecting and analyzing vast amounts of sensitive information. Protecting this data has become more important than ever. Snowflake’s masking policies are a powerful tool in keeping sensitive information safe while still allowing easy access for those with the proper credentials. This blog...
Snowflake, a leading cloud-based data warehousing platform, has become instrumental in modern data analytics and processing. However, when you connect to Snowflake, your data traverses the public internet before reaching its destination. This can raise significant security and performance concerns, particularly in sensitive industries like...
Ever tracked astronomical objects at a planetarium, watched real-time flights via Flightradar24 or followed your pizza delivery make its way to your door? Each of these experiences relies on the magic of streaming data, specifically benefiting from row-level data ingestion to minimize latency and maximize efficiency. With...
Earlier this year, Snowflake announced the availability of Snowpark ML during its Snowflake Summit. Snowpark ML is a set of tools, including SDKs and underlying infrastructure, to build and deploy machine learning models; all within Snowflake. It works with Snowpark for Python, so you can...
Ah, September. The breaking of the summer heat, state fairs, the winds of change beginning to usher in a new season and children returning to school. Idyllic, for sure, but we haven't been taking too much time to stop and smell the roses. We kicked things...
As Snowflake has developed over the years, we have seen the introduction of more and more table types, and it isn't always immediately clear what the differences are and when they should be used. Today, I hope to shed some light on this by outlining...
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