'Snowflake with On-premise
I've started learning Snowflake and have few questions about its functionality.
My company requires to extract/source data from Oracle & SQL Server databases, which are in their on-premise. Now while going through functionalities of Snowflake, I found that it can consume data only from cloud provider selected (i.e. AWS/Azure/GCP). Does this mean, we will first have to move our data from on-premise to one of the cloud provider and then only we can use Snowflake for processing?
One of the thread in discussion suggested that we first load data in file, then move it to Amazon S3 bucket and then get it consumed by Snowflake.
Can someone let me know about this or any tutorial to get my doubts clear?
Solution 1:[1]
As Mike Walton already mentioned, you can load data from your on-premises DB to Snowflake with any ETL tool. This is very typical scenario using Snowflake. No need to upload fist to any other cloud service.
Snowflake provides ODBC drivers so you can access the database from your workstation or integration server just like any other DB. Further reading in here: https://docs.snowflake.com/en/user-guide/odbc-download.html
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | ex4 |