topic Re: Issue Querying Registered Tables on Glue Catalog via Data bricks in Get Started Discussions

Issue Querying Registered Tables on Glue Catalog via Data bricks

GandinDaniel1 — Thu, 26 Dec 2024 15:09:00 GMT

Im having an issue to query registered tables on glue catalog thru databricks with the following error: AnalysisException: [TABLE_OR_VIEW_NOT_FOUND] The table or view looker.ccc_data cannot be found.Verify the spelling and correctness of the schema and catalog. If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog. while if I open it thru pyspark it works fine and I can see it in databricks catalog as well.

Thanks in advance

Re: Issue Querying Registered Tables on Glue Catalog via Data bricks

Alberto_Umana — Thu, 26 Dec 2024 16:43:03 GMT

Hi @GandinDaniel1,

Can you share example query that failed with above error versus how is it working in pyspark? Are you specifying catalog.schema.table?

Re: Issue Querying Registered Tables on Glue Catalog via Data bricks

GandinDaniel1 — Fri, 27 Dec 2024 15:49:07 GMT

Just a simple query: Select * FROM 'looker.ccc_data'

Re: Issue Querying Registered Tables on Glue Catalog via Data bricks

Alberto_Umana — Fri, 27 Dec 2024 20:15:08 GMT

Can you specify the full catalog.schema.table? and also check the current schema

SELECT current_schema();

Re: Issue Querying Registered Tables on Glue Catalog via Data bricks

GandinDaniel1 — Sun, 29 Dec 2024 09:32:14 GMT

it returns looker which is the right schema