Question

A data engineer is writing a Python automation script that must upload several local CSV files from the application server into an existing internal named stage, then trigger a bulk load into a table. They want to execute the file transfer programmatically without shelling out to SnowSQL. Which approach correctly moves the local files into the stage from within the Python Connector?

Accepted Answer

Execute a PUT command through the connector's cursor (e.g., cursor.execute("PUT file://... @my_stage")), then run COPY INTO.

Answer

Use the write_pandas() helper to push the raw CSV files directly into the internal stage before running COPY INTO.

Answer

Call a GET command through the cursor to transfer the local files up to the internal stage, then run COPY INTO.

Answer

Configure Snowpipe auto-ingest on the internal named stage so the local files are copied automatically.