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...
We have much to be thankful for here at InterWorks. This blog roundup features 16 posts and 19 contributors and covers everything from Tableau Conference 2019 and the big news revealed there - like the Modern Cloud Analytics initiative - to other fun posts, like...
Following our successful Brewalytics events in Perth and Sydney, the InterWorks ANZ team continued our data journey in Melbourne. Joined by partners Snowflake, Alteryx and Tableau, we welcomed the Melbourne data community to Downtown Data & Drinks in the heart of the city. Building an Empowered Culture This...
Today is the day! Snowflake is now in preview on Google Cloud Platform (GCP) in the us-central1 region. This news is something Snowflake fans have been looking forward to for quite some time, but now that it’s finally here, I wanted to share why this...
Earlier this week, at Tableau Conference 2019, Tableau and Amazon Web Services (AWS) unveiled a new initiative that will change the way Tableau users scale self-service analytics in the cloud: Modern Cloud Analytics (MCA). This initiative combines the deep well of partner resources from both...
A critical part of any data warehouse is how new data is brought in and prepared for consumption. Depending on the order of events, this process is known either as ETL or ELT. So, what do these acronyms mean? ETL is the process of extracting data...
If you’ve played a video game in your life (so basically everyone), then you’re familiar with the frustrating feeling of being stuck on that one insanely difficult level. How do you get past that? How do you break through to beat the big boss? These...
Snowflake is very much a global data warehousing company these days, as evidenced by their recent Snowflake Summit World Tour. San Francisco, Chicago, NYC, London and Sydney were all major stops. Each featured informative sessions, great keynote speeches from the Snowflake team and plenty of...
You've probably heard about Snowflake by now, but if you haven't, it needs to be a part of your analytics practice. This series will lay out all the essentials for getting started with this cloud-based data warehouse. Snowflake is built differently from other data warehouses. Its...
Following the tremendous success of Brewalytics events across the US, Europe and Australia, InterWorks was extremely eager to bring Brewalytics to Singapore! Brewalytics brings together beer, analytics and amazing data people for a premier networking event. For those who do not like beer, there was...
Following the success of our Brewalytics and Data in the Clouds events in Perth and Melbourne, we were thrilled to bring Brewalytics to Sydney. Beer and analytics—what a combo! Oh, did I mention we held the event at an inner-city brewery? Once again, Snowflake and Tableau...
Building on top of my initial post about Matillion’s API Profile functionality, I have discovered some new information I just had to share with the kind readers of the InterWorks blog. In my original post about Matillion’s API functionality, I covered the ability to read,...
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
