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....
Snowflake is like that friend who's always got something new up their sleeve! Snowflake is all about staying up-to-date and cool, regularly spicing up its lineup of awesome features to keep up with the changing times in the world of data. So, in this blog...
There are several features in Snowflake that contribute to your environment's performance and scalability. Two of the most important in my experience have been micro-partitions and clustering. In short, micro-partitions are the fundamental storage units of Snowflake, and clustering is a feature that organizes data...
The Day Before: Bringing our Snowflake Data into Tableau As the week began, we entered the development stage of our big intern project. My role thus far has been preparing for development by creating wireframes for the new dashboards. For this project, we used a Snowflake-held data...
As modern applications expand in complexity, effectively managing workflows can become a significant challenge. AWS Step Functions provides a comprehensive solution for orchestrating multi-step workflows in the cloud. Whether it's invoking Lambda functions in Task states, separating branches of execution with Parallel states or running...
Establishing customer trust and satisfaction is crucial for any business, and observability plays a major role in achieving this goal. In fact, it is one of the top trends in the data landscape. To enable more observability and measurability of data workloads, Snowflake has been...
April showers bring may flowers, but what do may flowers bring? Pilgrims! Never figured out if I should be telling that joke in April or November for Thanksgiving, but I figure that it’s timely enough either way! We had some great blog content this month. I’ll go...
In previous articles in this series, we have demonstrated how to set up Azure Functions to leverage Snowpark for Python. This allows us to interact with Snowflake from an Azure Function, unlocking a wide range of opportunities for scripting activity. In this article, we will focus...
Clocking in at 28 blog entries this month, March was easily one of the most jam-packed months we've had on the InterWorks blog. I feel like I've written that exact same intro several times since I took over compiling these monthly roundups, but the number...
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
