Quick SQL DB to Snowflake Export Tool

Quick SQL DB to Snowflake Export Tool

Since I started working for Snowflake & witnessed how it can totally change the way organizations use data to enhance their businesses, getting their inital data quickly into Snowflake to see the difference for themselves was the biggest challenge I came across for anyone who wanted to try out Snowflake.

Especially for quick testing & POC purposes where you don't want to spend hours on resources, learning ETL tools or open up firewalls but just want to get your data very easily into Snowflake.

Since Snowflake is fully ANSI-Compliant and uses nothing but SQL, I decided to create a lightweight windows app that can be installed and used to push data to Snowflake without knowing much about our platform. Something that is Point & Click which does the data type conversions, table & schema creation, generating flat files, uploading & ingesting them to Snowflake along with executing all the necessary SQL to do all these tasks.

One thing that was missing was SAP HANA which I finally had a chance to add that as a source as well. As a result, if you have SAP Hana, MsSQL, Oracle, Postgres or MySQL, you can use this tool to quickly ingest a sample set of tables from your sources into your Snowflake account quickly to try what Snowflake can do for your workloads.

A little disclaimer: This is my personal project & not associated with Snowflake, Inc. hence it is not a supported product:

The tool is located in GitHub:

https://github.com/NickAkincilar/SQL_to_Snowflake_Export_Tool



No alt text provided for this image
Ankit Agarwal

Data Analytics Leader | Data Strategy | Senior Solution Architect | AWS x 2 | Snowflake x 1 | Azure x 3 | GCP x 1

2 年

What about security of SF credentials

回复
Bertand Batenburg

Freelance Data Architect/Engineer

2 年

Wilma Timmerman-Hupkes Danny ter Haar, could be useful for onetime data transfer purposes

Rob O'Neill

Transforming healthcare through technology | Ex-DataRobot | NHS Digital Academy | 20 Yrs Healthcare AI, analytics and data delivery

4 年

Looks fantastic Nick Akincilar!

回复

要查看或添加评论,请登录

Nick Akincilar的更多文章

社区洞察

其他会员也浏览了