Not picking up schema changes to a view #1399
Closed
awisework
started this conversation in
Data Modeling
Replies: 2 comments 1 reply
|
Hi @awisework Could you try to enable "Use Analysis Services for change detection" in the preference menu and see if that makes a difference to getting the table schema to update? |
1 reply
|
that seemed to do the trick, thanks! (sorry for the delayed response, was out last week) |
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment

Uh oh!
There was an error while loading. Please reload this page.
I have a view in snowflake (and potentially more to be created). When I go to update the schema it doesn't pick up when new columns have been added to the view. Is this a limitation of using a view? Or am I doing something wrong. this is the m code within the expression:
let
Source = Snowflake.Databases(#"Datasource Server",#"Datasource Warehouse",[Role=#"Datasource Role"]),
DATABASE = Source{[Name=#"Datasource DB",Kind="Database"]}[Data],
EDW_Schema = DATABASE{[Name="EDW",Kind="Schema"]}[Data],
Table = EDW_Schema{[Name="VIEW_NAME",Kind="View"]}[Data],
All reactions