After you add data, you might need to refresh the data from its source if you learn that it has changed.
Rather than refresh a data source, you can completely replace it by loading a new data source with the same name as the existing one. However, replacing a data source can be destructive and is discouraged unless you understand the consequences:
Replacing a data source will break projects that use the existing data source if the old column names and data types are not all present in the new data source.
Any data wrangling, that is, modified and new columns added in the data stage, will be lost and projects using the data source will probably break.
Note:
You can reload data and metadata for analysis based Oracle application data sources, but if the Oracle application data source uses logical SQL, reloading data only reruns the statement, and any new columns or refreshed data won’t be pulled into the project. Any new columns come into projects as hidden so that existing projects that use the data source are not impacted. To be able to use the new columns in projects, you must unhide them in data sources after you do a refresh. This behavior is the same for file based data sources.To refresh data that you added: