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 réponse
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
répondu il y a un an
  • Thanks Riku

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions