Community Articles

Find and share helpful community-sourced technical articles.
Rising Star

This article explains how to connect to Snowflake from Cloudera Machine Learning.

 

  1. Save your Snowflake password for your account.
    Go to Account Settings > Environment Variables and create a new entry with Name: "SNOW_PASSWORD" and Value: <your password>peter_ableda_3-1649340312919.png
  2. Create a new session in your CML Project. You can use any of the editors, and a Python kernel:peter_ableda_2-1649340024388.png

  3. Install required Python packages
    pip install pandas snowflake-connector-python snowflake-connector-python[pandas]
  4. Initiate the Snowflake connection.
    You need to set your Snowflake Account ID and your username for the connection. Your Snowflake password is retrieved from the environment variable that you configured in the Account Settings. I'm using the default Snowflake warehouse and a sample database/schema.
    import os 
    import pandas as pd
    import snowflake.connector
    
    conn = snowflake.connector.connect(
        account='<Account ID>',
        user='<Username>',
        password=os.environ['SNOW_PASSWORD'],
        warehouse='COMPUTE_WH',
        database='SNOWFLAKE_SAMPLE_DATA',
        schema='TPCH_SF1'
    )
    
    query = '''
    select * from SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.CUSTOMER limit 100
    '''
    
    pd.read_sql(query, conn)
  5. Once you execute the code, you can see the results:peter_ableda_1-1649339461033.png
684 Views
0 Kudos
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.
Version history
Last update:
‎04-07-2022 10:43 PM
Updated by:
Top Kudoed Authors