mstrba
mstrba

Reputation: 31

What data sources Snowflake support?

As mentioned in the title, I'd like to know what data sources Snowflake supports. I'm not completely sure how to even approach this question. I know you can create an external stage in the cloud storage of supported cloud providers, but what if I want to load data from the Oracle database, for example. What's the best solution in that case, is it to use the ODBC driver, or?

And please feel free to give me any suggestions, or advice on where to continue my research. Also, let me know if any part of my question is unclear so that I can rephrase it :)

Upvotes: 1

Views: 687

Answers (2)

patrick_at_snowflake
patrick_at_snowflake

Reputation: 453

Snowflake natively supports AVRo, Parquet, CSV, JSON and ORC. These are landed in a stage for ingestion --- your ELT/ETL tool of choice or even a home-built application must land the data in a stage, either internal or external. That file is then ingested into Snowflake utilizing a COPY command either automated by said tool or using something like Snowpipe. We have documentation on Firehose / Kafka pipelines landing data for Snowpipe to ingest either through AUTO_INGEST notifications (limited to external stage) or calling our REST API.

All supported by our documentation, simply google the terms I have mentioned and there will be tons of documentation

Upvotes: 3

Lukasz Szozda
Lukasz Szozda

Reputation: 176104

Multiple existing ETL Tools allow to define Snowflake as destination, supporting a wide variety of sources.

Native Programmatic Interfaces

Snowflake Ecosystem - Data Integration

Upvotes: 2

Related Questions