At InterWorks, we regularly build data pipelines for customers that include tools for migrating and transforming data such as Fivetran or Matillion. Tools such as these have connectors for many common sources of data to save us the hassle of building and maintaining our own...
An important step towards ensuring the security of your Snowflake account(s) is the appropriate use of network rules and policies to prevent unauthorised access. These policies are leveraged to ensure that access is only allowed through restricted methods and to/from exclusive sources. Without this protection, you...
If you are familiar with SQL, you would be familiar with the concept of aggregate functions. For those who are still a bit fuzzy on what these aggregate functions intend to do, here’s a quick couple of quick examples: When you want to find the...
As Snowflake becomes more and more feature rich, we’ve become surrounded by all manner of suffixes to the word “Snow.” In this post, I’ll summarise the tools available and what their intended use is. This is only meant to be a brief overview, so I’ve...
File formats are database objects used by snowflake to ingest flat files. Consider file formats as your way of giving snowflake information about the file so it knows how to ingest those flat files in an optimal fashion. You specify the type of file along...
This article intends to provide a brief overview of what all the talk about Snowflake Native Apps Marketplace is about, how organizations can utilize the space to monetize their offerings, and how consumers can benefit from these third-party off-the-shelf applications, ending with detailed instructions to...
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to complete all manner of tasks. For example, external access could be used...
Python is a first class language in the Snowflake eco system, and there are multiple ways to use Python with Snowflake: Snowflake Connector for Python: Listed in Snowflake drivers, this is a standard connector to Snowflake written using Python. It supports developing applications using the...
I want you to know, my first draft of this blog post was almost entirely made up of me slipping "May" into casual sentences or trying to come up with puns surrounding the month's name. I've spared you from reading all that, don't worry. It...
As many are already aware, there has recently been a lot of noise about security on the Snowflake platform. On June 2nd, 2024, Snowflake issued this statement regarding a targeted threat campaign against some Snowflake customer accounts. This appeared to be a targeted campaign directed...
As many are already aware, recently there has been a lot of noise about security on the Snowflake platform. On June 2, 2024 Snowflake issued this statement regarding a targeted threat campaign against some Snowflake customer accounts. This appeared to be a targeted campaign directed at users...
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to complete all manner of tasks. For example – external access could be...
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to complete all manner of tasks. For example, external access could be used...
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to complete all manner of tasks. For example, external access could be used...
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to complete all manner of tasks. For example, external access could be used...
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world and can therefore communicate with external APIs to complete all manner of tasks. For example, external access could be used...
In previous articles, we have discussed how to set up private connectivity with Snowflake for both Azure and AWS: Configure Azure Private Link Connectivity with Snowflake Configure AWS PrivateLink with Snowflake On its own, private connectivity is an excellent way to secure traffic between your network...
In today's data-driven landscape, artificial intelligence (AI) has permeated every corner of industry and technology. From personalized recommendations on streaming platforms to optimizing supply chains in manufacturing, AI algorithms are revolutionizing how we approach problems and extract insights from data. As organizations race to leverage...
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...
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