I am trying to connect to snowflake using data bricks but getting the below error
net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered a communication error. Message: Exception encountered for HTTP request: Connect to xxx.region.snowflakecomputing.com:443 [XXX.region.snowflakecomputing.com/, XXX.region.snowflakecomputing.com/] failed: Read timed out.
user = dbutils.secrets.get("data-warehouse", "snowflake-user")
password = dbutils.secrets.get("data-warehouse", "snowflake-password")
SNOWFLAKE_SOURCE_NAME = "net.snowflake.spark.snowflake"
options = {
"sfUrl": "xxx.snowflakecomputing.com",
"sfUser": user,
"sfPassword": password,
"sfDatabase": "DB",
"sfSchema": "schema",
"sfWarehouse": "wharehouse"
}
snowflake_df = spark.read \
.format(SNOWFLAKE_SOURCE_NAME) \
.options(**options) \
.option("dbtable", "table") \
.load()
display(snowflake_df)
can you please let me know if I am missing something?