Snowpark编译错误:角色名称中的意外“-”

Question

当尝试使用以下包含角色、数据库、架构和仓库名称的会话方法连接到斯诺公园时，由于它包含破折号，因此存在一个带有角色名称的SQL编译错误。

dbname = "MY_DB"
schemaname = "MY_SCHEMA"
warehouse = "MY_WH"

read_session.sql(r"USE ROLE MY-SNOWFLAKE-ROLE").collect()
read_session.sql(f"USE WAREHOUSE {warehouse}").collect()
read_session.sql(f"USE DATABASE {dbname}").collect()
read_session.sql(f"USE SCHEMA {dbname}.{schemaname}").collect()

Answer 1

角色必须包含在双引号中，而整个USE语句需要在单引号中。

dbname = "MY_DB"
schemaname = "MY_SCHEMA"
warehouse = "MY_WH"

read_session.sql(r'USE ROLE "MY-SNOWFLAKE-ROLE"').collect()
read_session.sql(f"USE WAREHOUSE {warehouse}").collect()
read_session.sql(f"USE DATABASE {dbname}").collect()
read_session.sql(f"USE SCHEMA {dbname}.{schemaname}").collect()