Ashwin_DSA
Databricks Employee
Databricks Employee

Hi @Anandhi-Sekaran,

I would need more context to help you. Please share the exact SQL you’re using, with any catalog, schema, or table names anonymised if necessary, so I can identify what might be affecting you.

As a starter, just make sure you’re using all three parts (Catalog, Schema & Table) every time rather than just using the table name alone. 

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

Regards,
Ashwin | Delivery Solution Architect @ Databricks
Helping you build and scale the Data Intelligence Platform.
***Opinions are my own***