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? |
Beta Was this translation helpful? Give feedback.
1 reply
-
that seemed to do the trick, thanks! (sorry for the delayed response, was out last week) |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
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],
Beta Was this translation helpful? Give feedback.
All reactions