Quick SQL DB to Snowflake Export Tool
Nick Akincilar
Analytics, AI & Cloud Data Architect | Solutions Whisperer | Tech Writer
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:
Solutions Architect @ FIS
2 年Doug Dickson ??
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
Freelance Data Architect/Engineer
2 年Wilma Timmerman-Hupkes Danny ter Haar, could be useful for onetime data transfer purposes
Transforming healthcare through technology | Ex-DataRobot | NHS Digital Academy | 20 Yrs Healthcare AI, analytics and data delivery
4 年Looks fantastic Nick Akincilar!