Description
I am getting an error when following the same as mentioned in the README.md and I am not able to give permission to any tables in the Manage Access
SnowparkSQLException: (1304): 01b9ebd1-0000-d5a5-0008-72d200063302: 505026 (23001): Reference definition 'LITEDB11' cannot be found in the current version of the application 'DATA_MAPPING_APP_ABHIJITHVS' Traceback: File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/streamlit/runtime/scriptrunner/script_runner.py", line 565, in _run_script exec(code, module.__dict__) File "/tmp/appRoot/enricher_dash.py", line 10, in <module> option_source = session.sql("SELECT * FROM REFERENCE('litedb11') WHERE 1=0").to_pandas().columns.values.tolist() File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/telemetry.py", line 172, in wrap result = func(*args, **kwargs) File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/dataframe.py", line 812, in to_pandas result = self._session._conn.execute( File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/server_connection.py", line 581, in execute result_set, result_meta = self.get_result_set( File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/analyzer/snowflake_plan.py", line 201, in wrap raise ne.with_traceback(tb) from None File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/analyzer/snowflake_plan.py", line 132, in wrap return func(*args, **kwargs) File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/server_connection.py", line 690, in get_result_set result = self.run_query( File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/server_connection.py", line 129, in wrap raise ex File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/server_connection.py", line 123, in wrap return func(*args, **kwargs) File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/server_connection.py", line 488, in run_query raise ex File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/server_connection.py", line 473, in run_query results_cursor = self.execute_and_notify_query_listener( File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/snowpark/_internal/server_connection.py", line 423, in execute_and_notify_query_listener results_cursor = self._cursor.execute(query, **kwargs) File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/connector/cursor.py", line 1019, in execute Error.errorhandler_wrapper( File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/connector/errors.py", line 232, in errorhandler_wrapper handed_over = Error.hand_to_other_handler( File "/usr/lib/python_udf/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/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/168d279f8bd1ef4d21e14915540f121ff8122b660a09a90cf07d4ddeca29ae93/lib/python3.8/site-packages/snowflake/connector/errors.py", line 165, in default_errorhandler raise error_class(
Not able to see example on how this can be addressed, even every AI fails to answer my question.
Any urgent help or resolution on this would be much appreciated.
And do the consumer has to create using some sql statements to get this executed ?