Snowflake DB SQL shell/cli
export SNOWFLAKE_ROLE=my_role
export SNOWFLAKE_SERVER=MYDATAART
export SNOWFLAKE_WSID=my-wsid
export SNOWFLAKE_AUTOCOMMIT=False
export SNOWFLAKE_WAREHOUSE=MYWH
export SNOWFLAKE_APP=MYAPP
export SNOWFLAKE_DATABASE=MYDB
export SNOWFLAKE_SCHEMA=MYSCHEMA
export SNOWFLAKE_USER=dev_test
export SNOWFLAKE_PWD=mypwd
export SNOWFLAKE_AUTHENTICATOR=https://test.okta.com;[email protected]
host:/home/user/snowcli $ ~/python3/bin/python3 main.py
Snow>
Snow> COPY INTO MYDB.MYSCHEMA.MY_TABLE FROM '@MY_STAGE/MY_TABLE/'FILES=('test.csv.gz')
https://github.com/pydemo/Snowpipe-For-SQLServer - Memory pipe from SQLServer to Snowflake
https://github.com/pydemo/large-file-split-compress-parallel-upload-to-S3 - Chunked large file upload to S3.