CODEWITHSUNDEEP
pythonairflowsnowflake-cloud-data-platformdirected-acyclic-graphssnowflake-connector
Rajalakshmi
Rajalakshmi

Reputation: 771

Get Snowflake query result in Python

I am currently working on a POC where we would like to get the snowflake query results into an email using Python.

For example : When executing an Insert statement in Snowflake, I would like to capture the result showing how many records were inserted. Please note that we are using Python Connector for Snowflake to execute our queries from Python script. Also we are using dataframes to store and process data internally.

Any help is appreciated!

Upvotes: 0

Views: 1062

Answers (1)

Dave Welden
Dave Welden

Reputation: 1918

Following the INSERT statement, you can retrieve the number of rows inserted from cursor.rowcount.

Upvotes: 1

Related Questions