pydemo / Snowpipe-for-Oracle Public

Notifications You must be signed in to change notification settings
Fork 1
Star 3

Data transfer from Oracle to Snowflake using Python/pyodbc

3 stars 1 fork Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
README.md		README.md
snowpipe.py		snowpipe.py

Repository files navigation

Snowpipe-for-Oracle

Data transfer from Oracle to Snowflake using Python/pyodbc

Stream data from Oracle database to Snowflake using pyodbc.

1. Connect to Oracle 12G
    -> loop
        - fetchmany
        - multipart upload to s3
    -> Bulk COPY INTO Snowflake table

I'm looking for a new gig

About

Data transfer from Oracle to Snowflake using Python/pyodbc

python data etl bigdata snowflake boto pyodbc oralce etl-pipeline snowflakedb

Report repository

Releases

No releases published

Packages

No packages published

Languages

Python 100.0%