Issue Querying Registered Tables on Glue Catalog via Data bricks

[GandinDaniel1]

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

[Alberto_Umana]

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?

[GandinDaniel1]

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

[Alberto_Umana]

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

SELECT current_schema();

[GandinDaniel1]

it returns looker which is the right schema