Column metadata is now supported on SoQL derived views. (SoQL derived views can only be created on the Enterprise Data Platform., but they can be federated to Open Data Platforms.) These views now inherit column metadata from their parent datasets. This metadata includes; column display names, column descriptions, and also column formatting (e.g. a number column formatted to appear as currency).
Things to note:
-
New SoQL derived views will automatically inherit the same column metadata as the default assets they were derived from.
-
Columns in existing SoQL derived views, will not be automatically updated with new metadata.
-
Similarly, columns on existing SoQL derived views will not be affected by upstream publication cycles.
-
Existing SoQL derived views will inherit their parents' column metadata only when the derived views themselves are updated or republished. (This is to avoid making changes to customers' assets without their knowledge.)
-
Column metadata can now be edited directly on SoQL derived views similar to filtered views. To edit column metadata, click on the Edit button.
then click on Edit Column Metadata
users can then navigate to a column, edit its metadata and save the changes here
Comments
Article is closed for comments.