I have some dashboards in AWS QuickSight consisting of three datasets, connected through Athena to three tables. ‘projects’, ‘project_files’ and ‘project_resources’.
My dashboards use my datasets using two combined datasets:
‘project_files’ LEFT JOIN ‘projects’ (with project’s id)
‘project_resources’ LEFT JOIN ‘projects’ (with project’s id)
I now updated the schema of ‘projects’ and added a new column ‘snapshot’. I refreshed the single ‘projects’ dataset schema and it updated accordingly, showing the new ‘snapshot’ column. But in my combined datasets, even after I refresh the data, the ‘snapshot’ column doesn’t appear regarding the ‘project’ table.
Worth to mention that ‘project_files’ and ‘project_resources’ also have a column named ‘snapshot’, but I don’t think this is being overwritten. I believe it’s just not updating the combined dataset accordingly.
I think I understand the problem but to clarify, when you apply your changes in the data prep layer, you see the new column in your table but that is not getting passed to your analysis?
If so, are hitting apply and then pressing “Save and Publish” in the top right?
The problem here is that I don’t see the new column in my table in the data prep layer, on the joined datasets, composed of more than one table. Therefore, I can not see it in the analysis either.
As you can see in the next first screenshot, ‘projects’ table’s dataset updated correctly and the new ‘snapshot’ column has appeared.
On the second screenshot, you can see the dataset ‘project_files’ JOINed with ‘projects’, and in the fields list ‘snapshot’ column for table ‘projects’ does not appear (there’s another column named ‘snapshot’ there, but it’s regarding ‘project_files’, not ‘projects’).
