Refresh used sources
Refresh New Used Sources
In AnalyticsCreator, source metadata is typically imported during the initial project setup. However, as development progresses, new source tables might be introduced in upstream systems — and used within transformations or packages without being fully refreshed. Refresh New Used Sources ensures that these newly referenced source objects are properly scanned and registered in the metadata repository.
Why This Matters
When working in a collaborative or evolving environment, it’s common for developers to manually insert table names or columns in transformations before explicitly importing or refreshing the source object. This can result in incomplete metadata — leading to deployment warnings or broken lineage. The Refresh New Used Sources function automates the detection and metadata alignment for these "missing but used" tables.
Function Description
| # | Action | What It Does | Access Path |
|---|---|---|---|
| 1 | Refresh New Used Sources | Scans all transformations, packages, and manually entered source references. If any referenced tables or views are used but not yet refreshed into the source list, this function imports their metadata (columns, data types, keys) from the connector system. | Toolbar → Tools Menu → Refresh New Used Sources |
When to Use
- After adding table references directly into transformations without using "Import Source".
- When working with generated code or copied packages from other projects.
- Before deploying, to ensure that all used source objects have complete metadata definitions.
Best Practices
- Run Refresh New Used Sources regularly during development to avoid missing metadata.
- Combine this step with Refresh All Sources when upstream schema changes are expected.
- Review the Sources List after the refresh to validate that newly used tables appear correctly.
Related Functions
| Function | Description |
|---|---|
| Refresh All Sources | Performs a complete refresh of all source objects for all connectors. |
| List Sources | View and manage all registered source tables with filtering and sorting options. |
Summary
Refresh New Used Sources bridges the gap between manually used and formally registered metadata. It is a lightweight safety net that ensures no source object goes untracked, maintaining model integrity and avoiding deployment surprises.
