Forum Discussion
Semantic Model connected to Lakehouse SQL Analytics endpoint not refreshing
Yeah, after a second test, this appears to be working...
So, all I've done is add a Script activity which runs a simple SELECT TOP 1 * FROM ... against one of the views in my Lakehouse SQL Endpoint, then a Wait activity that waits for 60 seconds, before the Semantic Model Refresh activity. I'm not sure if the Wait is actually necessary, but I figure it can't do any harm...
Just a quick update on this... I think I've got it working just by hitting the endpoint with a simple SQL query, waiting for a bit, and then refreshing the semantic model.
I couldn't get the metadata refresh API call working, but I think all we need to do it wake it up...
I need to do a bit more testing to be certain though.
Yeah, after a second test, this appears to be working...
So, all I've done is add a Script activity which runs a simple SELECT TOP 1 * FROM ... against one of the views in my Lakehouse SQL Endpoint, then a Wait activity that waits for 60 seconds, before the Semantic Model Refresh activity. I'm not sure if the Wait is actually necessary, but I figure it can't do any harm...
Further testing reveals that the Wait activity is necessary - I had two copies of the model in different workspaces, so I set my pipeline up to refresh on immediately after the script query, and the other after waiting 60 seconds, and only the second one showed fresh data this morning.