How to fix the dataset sync error due to a change in column name in source data table?

Question & Answer
1

Dataset import started failing due to change in the column name and addition of column in source data table.
Unknown column ‘serviceprovider.UserRole’ in ‘field list’
|sourceErrorCode:|1054|
|sourceErrorMessage:|Unknown column ‘serviceprovider.UserRole’ in ‘field list’|
|sourceErrorState:|42S22|

If I remove the table from the dataset and add it again and import full, will it break the existing visuals in the dashboards? Would it require rebuild of the all the visuals even though the specific column is not used in the visuals?

2

I would suggest creating a new DataSet with a custom SQL query
Then replace the failing DataSet with the new one with the replace option offered in the Analysis. That way the reports should still work as before.

I would recommend working with views and custom queries from now on.

3 Likes