Connect Python to Snowflake (with password and external authentication)
The requred pacakges include the snowflake connector and the pandas-compatable version of the snowflake connector, these can be installed using:
pip install "snowflake-connector-python[secure-local-storage,pandas]"
For more code examples and further instructions, head to the DotPi webpage for connecting Python to Snowflake http://dot-pi.com/connect-python-to-s...
The code used in this video is pasted below
#import the snowflake connector
import snowflake.connector
#open a database connection
ctx = snowflake.connector.connect(
user = USERNAME
password = PASSWORD
account= ACCOUNT
region = REGION
Role = ROLE (Optional)
Warehouse = WAREHOUSE (Optional)
)
#create a cursor object
cs = ctx.cursor()
city = 'Christchurch'
sql_query = '''
SELECT *
FROM "ExampleDB"."EXAMPLESCHEMA"."EXAMPLEWEATHERDATA"
WHERE "CITY" = ''' + "'" + city + "'"
cs.execute(sql_query)
#convert the data to a pandas dataframe
data_df = cs.fetch_pandas_all()
Смотрите видео Connect Python to Snowflake (with password and external authentication) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь DotPi 25 Март 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 11,53 раз и оно понравилось 8 людям.