将数据从Pandas存储到Snowflake的最佳方法

import snowflake.connector
import pandas as pd

# Snowflake连接信息
account = 'your_account_name'
user = 'your_username'
password = 'your_password'
database = 'your_database'
warehouse = 'your_warehouse'
schema = 'your_schema'
table = 'your_table'

# 创建Snowflake连接
conn = snowflake.connector.connect(
    user=user,
    password=password,
    account=account,
    warehouse=warehouse,
    database=database,
    schema=schema
)

# 将Pandas数据转换为CSV格式
data = pd.DataFrame({'column1': [1, 2, 3], 'column2': ['A', 'B', 'C']})
csv_data = data.to_csv(index=False)

# 加载数据到Snowflake表
cursor = conn.cursor()
cursor.execute(f"CREATE OR REPLACE TABLE {table} (column1 INT, column2 STRING)")
cursor.execute(f"COPY INTO {table} FROM (SELECT $1, $2 FROM @%your_stage) FILE_FORMAT=(FORMAT_NAME='your_format')")
cursor.execute(f"PUT file://your_csv_data.csv @%your_stage AUTO_COMPRESS=TRUE")

# 关闭Snowflake连接
cursor.close()
conn.close()