When running the generator for Looker explore, the execution fails when using optional database here.
ProgrammingError: 090236 (42601): Stored procedure execution error: Unsupported statement type 'USE'.
Traceback:
File "/usr/lib/python_udf/bd7d5b38bff98b61dd9539087622e48c69f4db9566f8186a9f3bd5fbbe514357/lib/python3.10/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 592, in _run_script
wrapped_fragment()
File "/usr/lib/python_udf/bd7d5b38bff98b61dd9539087622e48c69f4db9566f8186a9f3bd5fbbe514357/lib/python3.10/site-packages/streamlit/runtime/fragment.py", line 288, in wrapped_fragment
result = non_optional_func(*args, **kwargs)
File "/usr/lib/python_udf/bd7d5b38bff98b61dd9539087622e48c69f4db9566f8186a9f3bd5fbbe514357/lib/python3.10/site-packages/streamlit/elements/dialog_decorator.py", line 70, in dialog_content
_ = non_optional_func(*args, **kwargs)
File "/home/udf/223342598199214/journeys/partner.py", line 17, in partner_semantic_setup
configure_partner_semantic()
File "/home/udf/223342598199214/partner/partner_utils.py", line 92, in configure_partner_semantic
set_looker_semantic()
File "/home/udf/223342598199214/partner/looker.py", line 259, in set_looker_semantic
looker_columns = render_looker_explore_as_table(
File "/home/udf/223342598199214/partner/looker.py", line 580, in render_looker_explore_as_table
conn.cursor().execute(f"USE DATABASE {optional_db};")
File "/usr/lib/python_udf/bd7d5b38bff98b61dd9539087622e48c69f4db9566f8186a9f3bd5fbbe514357/lib/python3.10/site-packages/snowflake/connector/cursor.py", line 1019, in execute
Error.errorhandler_wrapper(
File "/usr/lib/python_udf/bd7d5b38bff98b61dd9539087622e48c69f4db9566f8186a9f3bd5fbbe514357/lib/python3.10/site-packages/snowflake/connector/errors.py", line 232, in errorhandler_wrapper
handed_over = Error.hand_to_other_handler(
File "/usr/lib/python_udf/bd7d5b38bff98b61dd9539087622e48c69f4db9566f8186a9f3bd5fbbe514357/lib/python3.10/site-packages/snowflake/connector/errors.py", line 287, in hand_to_other_handler
cursor.errorhandler(connection, cursor, error_class, error_value)
File "/usr/lib/python_udf/bd7d5b38bff98b61dd9539087622e48c69f4db9566f8186a9f3bd5fbbe514357/lib/python3.10/site-packages/snowflake/connector/errors.py", line 165, in default_errorhandler
raise error_class(
When running the generator for Looker explore, the execution fails when using optional database here.
If I understood correctly, this is due to using owner rights. Is this intended behavior?