Todd Chittenden on 12 Feb 2025 17:41:00
I have a pipeline that dumps data into a Lakehouse table (via a Copy Data task, with Overwrite option). After the pipeline runs, the Lakehouse view of the table gets updated fairly quickly. But the SQL Analytic endpoint view as accessed via SSMS still shows the OLD schema and data of the table. (Note that the old schema is 3 columns, and the new schema is 12 columns.) I have tried disconnecting the Object Explorer in SSMS and re-connecting but after 20 minutes it still shows a table of 3 columns. A simple "SELECDT * FROM ..." of that table yields a dataset of the correct 12 columns, but Object Explorer is stuck.
Is this a caching bug in SSMS?