How to Migrate from MongoDB to Snowflake
Skippr is the easiest way to migrate from MongoDB to Snowflake and get fully cleansed and modeled data in one run command.
Source: MongoDB. Destination: Snowflake.
Sample config
yaml
skippr:
workspace: mongodb_to_snowflake
pipelines:
mongodb_to_snowflake:
data_source: data_sources.source
data_sink: data_sinks.warehouse
data_sources:
source:
Mongodb:
connection_string: "mongodb://user:pass@host:27017"
database: mydb
collection: users
data_sinks:
warehouse:
Snowflake:
database: ANALYTICS
schema: RAW
warehouse: COMPUTE_WH
role: ACCOUNTADMINEnvironment
bash
export SNOWFLAKE_ACCOUNT="MYORG-MYACCOUNT"
export SNOWFLAKE_USER="myuser"
export SNOWFLAKE_PRIVATE_KEY_PATH="/path/to/snowflake_key.p8"Source connector: mongodb. Destination connector: snowflake.
See Quick start.
