How to copy CSV file to snowflake using snowflake connector, SQL Alchemy & pandas

Описание к видео How to copy CSV file to snowflake using snowflake connector, SQL Alchemy & pandas

Uses Pandas SQL write capability with the Snowflake Connector for Python (via SQL Alchemy)

Prerequisites : pip install pandas
pip install sqlalchemy
pip install snowflake


Script:
import os
import pandas as pd
import sqlalchemy
import snowflake.connector
from snowflake.sqlalchemy import URL
from sqlalchemy import create_engine
import io
#import getpass

#enter respective account, user and password info
engine=create_engine(URL(account=account1,user=user1,password=password1,warehouse='COMPUTE_WH',database='TEST_NEW_db',schema='MY_SCHEMA',role='ACCOUNTADMIN'))
#connection = engine.connect()
data=pd.read_csv('C:\\Users\\Public\\Data\\loan_10k.csv')
data.to_sql("mortgage_new",engine, index = False)

Комментарии

Информация по комментариям в разработке

Похожие видео