Hey gang, I've added a couple of cols to a data so...
# gd-beginnerst
Thomas
11/26/2024, 2:13 PMHey gang, I've added a couple of cols to a data source and they're 100% deffo there when I check in redshift, but I can't get them to appear in the LDM, any tips for how to debug this?
Thomas
11/26/2024, 2:18 PMif I add a SQL data source and query the exact same table, the cols are there
Thomas
11/26/2024, 2:23 PMI tried manually adding the column via add field, typing the name of the source column. This initially didn't work, but now has, and subsequently the other column popped up on the add field dropdown.
is there a more reliable way to introduce table changes?
m
Michal Hauzírek
11/26/2024, 2:31 PMHi Thomas, I believe this “Refresh” function on the data source within the Logical Data Model is what you are looking for.
It should re-scan the physical structure of your database so new columns and tables/views will become available to work with the LDM. (They will not be auto-added to the datasets, but you can add them manually).
t
Thomas
11/26/2024, 2:53 PMyeah I tried that a few times too
Thomas
11/26/2024, 2:53 PMno dice