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...
Imperative vs. Declarative Programming There are essentially two primary approaches to coding: imperative and declarative. To put it simply, these approaches determine whether you instruct the compute engine on how to perform the program's tasks (imperative) or what outcome you want to achieve (declarative). My colleague,...
In this blog post, we will dive into the realm of Snowflake External Tables, a feature redefining data management and analysis. If you find yourself grappling with massive datasets, complex data structures or ever-increasing data volumes, you're not alone. In this age of information abundance,...
Welcome, everyone, to the recap of our August blogs. You may look at your calendars and say, "Mark, my friend, it's September 12. We're almost halfway through September. Why is this recap so late?" That, my dear reader, is an astute question. It actually has...
SHP Files in Tableau Shape files (.shp) allow us to encode geospatial information like countries, continents or more specific custom regions specific to our use cases. These work similarly to dot-to-dot puzzles. One file stores a series of shapes, each with a series of points (or...
Tray.io is an easy-to-use low code API Integration tool that’s great at streamlining your workflows and data in the workplace. I recently tried it out! I wanted to create a basic data flow that pulls Typeform survey data into a Snowflake server for use later in...
Recently, I was involved in a project which required using geospatial (basically maps) data for an analytical application. Now, with ESRI shape files being around for more than three decades, any sincere BI application like Tableau can easily read and work with these spatial files....
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