Third-Partying with Snowflake to get the most out of your Cloud Analytics
We know Snowflake as one of the leading Data Management Platforms in the Cloud. But, it does not make much sense to use Snowflake completely on its own. Fortunately, Snowflake integrates really well with a selection of partners. Third-Partying with Snowflake shows how Snowflake benefits from its surrounding Technology Partners. There are various categories of partners like the following;
- Business Intelligence (BI) → “analyzing, discovering, and reporting on data”
- Data Integration → For Extracting, Transforming and Loading. Not necessarily in that order. It’s either ETL or ELT.
- Advanced Analytics → “covers a broad category of vendors, tools, and technologies that provide advanced capabilities for statistical and predictive modeling”
- Programmatic Interfaces → “Using native clients (connectors, drivers, etc.) provided by Snowflake, you can develop applications using any of the following interfaces”
- SQL Editing / Querying Tools → “a variety of 3rd-party SQL editors and data querying/modeling tools”
- Security & Governance → tools to “support a wide range of operations, including risk assessment, intrusion detection/monitoring/notification, data masking, data cataloging, and more”
Partner Enablement — Part I
Find below some of the integrations I already tried out.
- Of course, because I come from an Oracle background. I had to connect Oracle Data Visualization with Snowflake.
- With Snowflake you want to load the data as quickly as possible into the database. For instance, one of the options is; Partner Enabled Data Loading with Fivetran into Snowflake.
- Another option to load data into Snowflake quickly is via Stitch. Partner Enable Data Loading with Stitch is similar to Fivetran.
- One of the preferred partners to visualize the data is Looker. Therefore we had a Looker into Snowflake.
This was Part I of; “Third-Partying with Snowflake”. I am looking forward to show some other integrations. Some of the Third-Party tools I want to cover are the following.
Partner Enablement — Part I I
Alteryx is a Self-Service Data preparation tool. It integraties really well with Snowflake. Since Pong is an Alteryx Partner, Alteryx is on top of my list.
Matillion, which is; “Purpose-built for Snowflake, Matillion leverages Snowflake’s powerful compute and storage resources to perform powerful data transformations.”. Enough reason to check it out.
I hear some interesting stories about; DBT. This DBT (data build tool) is a command line tool that enables data analysts and engineers to transform data in their warehouses by simply writing select statements.
And last but not least (for now), SqlDBM which is a Data Modeling Tool for Snowflake.
In conclusion, Third-Partying with Snowflake is not a detailed explanation of how to work with the Snowflake Third-Party integrations. Still it does shows how easy it is to integrate Third-Party solutions with Snowflake.
Keep checking back at this blog for Part II as the list will increase.
Thanks for reading.
Originally published at https://daanalytics.nl on August 28, 2019.