How to ingest data from oracle on premise to SnowFlake

0

Hi, i need to ingest data from Oracle on premise to SnowFlake, what would be the right way to do it?, using DMS? or which other options can i use?, if i have to use DMS, how to do that ingest?, thanks

1 Answer
0

AWS DMS does not support SnowFlake as a target.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.Targets.html

Another possible approach is to set the DMS target to S3.
I believe it is possible to load data from SnowFlake after importing data into S3.
https://docs.snowflake.com/en/user-guide/data-load-s3-create-stage

profile picture
EXPERT
answered 9 months ago
  • Thanks Riku

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions