Updated September 13th, 2024 by allia.khosla
Azure Synapse Analytics (formerly SQL Data Warehouse) federated queries throwing "Invalid object name 'dbo.date'" error
Problem When using the Databricks Lakehouse Federation feature to fetch data stored in Azure Synapse Analytics (formerly SQL Data Warehouse) – specifically when running a select query against tables under the schema – you receive an error message stating Invalid object name 'dbo.date ' even though the table metadata is visible via the Catalog UI....
0 min reading timeLoad More