If there has been a lot of hype around how Tableau and Snowflake work so well together, it’s simply because they do! Tableau is a modern BI platform that enables powerful, self-service analytics in a continuously visual process to uncover rapid business insights. Snowflake is...
One question we often get when a customer is considering moving to Snowflake from another platform, like Microsoft SQL Server for instance, is what they can do about migrating their SQL stored procedures to Snowflake. If you’ve read Snowflake’s documentation on the subject, you’ll know that Snowflake’s stored...
Tableau is the #1 visual analytics platform in the world. In part, it has accomplished this by providing its user base with a tremendous amount of flexibility when it comes to data sources. By my last count, Tableau has over 80 native connectors to a...
One of the first things you’ll do when setting up your Snowflake environment is to establish your virtual warehouses. What this boils down to, essentially, is how much compute you want to use and how segregated that compute will be. What Is a Virtual Warehouse? Warehouses are...
What does it look like to go from zero to hero with Snowflake? In this PYD episode, host Ben Du talks with Geoff Soon, the company’s managing director for South Asia, about the value of Snowflake, what we can expect in its future and some...
Two weeks ago, my fellow content connoisseur Andrea Avey sat down with InterWorks IT gurus Scott Matlock and Tim Rhymer to talk about the impact of the cloud on IT over the past ten years. That’s some serious ground to cover, and they did a...
In the entire history of the world, sharing information has never been easier. This becomes obvious just by looking at social media platforms. Their technological innovations have enabled billions of users worldwide to share Instagram stories, TikTok videos, World War 3 memes, baby/yoga/kitten videos and...
This month, we hit refresh on a new year and a new decade, aiming to breathe new life into existing solutions and reframe the way we think about and approach our work. In looking to lay a strong foundation for the year to come, we...
Data can be stored in many different formats. In the previous post in this series, we discussed semi-structured file formats, focusing on a particular approach called JSON, which is formed of arrays, objects and key value pairs. This is one of many semi-structured data formats...
It’s the dawn of a new year and, indeed, a new decade, which brings with it a good amount of self-reflection for individuals and organizations alike. Think for a second about how much has changed in the world of technology these past ten years. We...
In the world of data, getting near-real-time data is kind of like the holy grail for reporting. The benefits are easy to see: reporting on things as they happen opens up a world of decisions that didn’t before exist. While I could write a full...
Snowflake is a versatile powerhouse of cloud-based data storage. As in previous posts, I want to start this blog by reviewing the types of structured and semi-structured data that Snowflake can support: *Note: The XML preview feature link can be accessed here As always, an updated list of...
Data can be stored in many different formats. Before we can import any data into Snowflake, it must first be stored in a supported format that Snowflake can interpret. At time of writing, the full list of supported is contained in the table below: *Note: The...
Various people come by our house, whether it be someone delivering mail, an Amazon Prime package or from the utilities. However, there are times when people try to come by who are not wanted. It is our responsibility to ensure that we do not give...
Surprise, surprise … another year in the books. I genuinely contemplated copying and pasting the opening paragraph of last year’s blog, but here I am writing an original opening to close out the decade. Start strong, finish strong, right? And as we begin a new...
And just like that, another decade is in the books. But don't worry; this good thing doesn't have to come to an end. Find all of the content we released last month in this blog roundup. While it may have been a quieter month on...
As a Snowflake user and a Python enthusiast, I was very happy to learn that Snowflake has created its own Python package to connect to Snowflake and execute commands. As these commands are executed locally and transmitted to Snowflake, the full SnowSQL functionality is available...
Note: This blog was updated in October 2023 with minor updates. Our previous post in this series explained how to import data via the Snowflake user interface. You can also stage your data and load it into tables with code via SnowSQL, which is what this blog...
There are many ways to import data into Snowflake, with the simplest being via the standard user interface. To import data, we must meet the following requirements: The data must be in a suitable file format A warehouse in Snowflake must exist to perform the...
A critical part of any Snowflake database is the storage of the data. Snowflake is capable of both storing data within the environment and accessing data that is stored in other cloud storage environments. Regardless of whether the data is stored internally or externally, the...
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