Using SnowFlake with the Python Data Connector

To use Python and SnowFlake you need the data connector

pip install snowflake-connector-python

This code block would run a basic select statement

import snowflake.connector
ctx = snowflake.connector.connect(
    user='datadog_user',
    password='xxx',
    account='ORG-REGION'
    )
cs = ctx.cursor()
try:
    cs.execute("Select * From *")
    one_row = cs.fetchone()
    print(one_row[0])
finally:
    cs.close()
ctx.close()

To encrypt your password see this post.