Hi all! When trying to load from a Snowflake tabl...
# questions
t
Hi all! When trying to load from a Snowflake table according to these docs, I am getting the following error:
Copy code
Certificate did not match expected hostname:                         connection.py:547
                             XXX.west-europe.azure-1.snowflakecomputing.com. Certificate:                   
                             {'subject': ((('commonName',                                                          
                             '*.prod3.us-west-2.snowflakecomputing.com'),),), 'subjectAltName':                    
                             [('DNS', '*.prod3.us-west-2.snowflakecomputing.com'), ('DNS',                         
                             '*.us-west-2.snowflakecomputing.com'), ('DNS',                                        
                             '*.global.snowflakecomputing.com'), ('DNS',                                           
                             '*.snowflakecomputing.com'), ('DNS',                                                  
                             '*.prod3.us-west-2.aws.snowflakecomputing.com')]}
My credentials file looks as follows (just like in the docs):
Copy code
snowflake_client:
  connection_name: "xxx.west-europe.azure"
  account: 'xxx.west-europe.azure-1'
  port: 443
  warehouse: "xxx"
  user: "xxx@xxx.com"
  authenticator: "externalbrowser"
My catalog looks like:
Copy code
raw.demographics:
  type: kedro_datasets.snowflake.SnowparkTableDataset
  table_name: "xxx"
  database: "xxx"
  schema: "xxx"
  credentials: snowflake_client
I tested the above with python
3.8.19
and
3.12.6
Any ideas what I could do to solve this?
m
Is date in your system correct?
Can you use those credentials successfuly outside of Kedro?