Table of Contents
About the Dataset
The columns of the Asset Inventory Dataset contain information about every asset on your domain. These include metadata fields such as name, description, and category, as well as statistics, such as the number of visits, row count, column count, and downloads. This asset is updated at least once per day to sync any changes, additional assets, or removed assets.
Below are the standard columns in the Asset Inventory system dataset. In addition to these comments are custom metadata fields you have defined for your platform.
|
Field Name |
Description |
|---|---|
|
UID |
The unique identifier for this asset. |
|
Name |
The name of the asset. |
|
Description |
The description of the asset. |
|
Owner |
The asset owner's name. |
|
Owner UID |
The asset owner's unique identifier. |
|
Publication Stage |
The status of the asset as either 'published' or 'unpublished'. |
|
Audience |
The audience of the asset as one of 'public', 'private' or 'internal'. |
|
Approval Status |
The approval status of the asset as one of 'approved', 'rejected', 'pending' or 'not_ready'. |
|
Provenance |
The authority of the asset as either 'official' or 'community’ (for open data domains). If the asset owner is a member of the public, then the asset is displayed as a community asset. |
|
Type |
The asset's datatype. |
|
Category |
The asset's category, if provided. |
|
Tags |
The asset's tags, if provided. |
|
URL |
The web URL to view the asset. |
|
API Endpoint |
The API endpoint to access the asset's data. |
|
Creation Date (UTC) |
The date/time the asset was initially uploaded to in UTC. |
|
Last Data Updated Date (UTC) |
The date/time the asset's tabular data was last updated in UTC, which will not reflect metadata updates. |
|
Domain |
The domain the asset belongs to as either this domain or a federated domain. |
|
Derived View |
Whether the asset derives from another asset. |
|
Visits |
The number of times the asset has been viewed. |
|
Downloads |
The number of times the asset has been downloaded. |
|
Row Label |
What each row of the asset represents, missing if the asset does not have tabular data. |
|
Row Count |
The number of rows in the asset, missing if the asset does not have tabular data. |
|
Column Count |
The number of columns in the asset, missing if the asset does not have tabular data. |
|
Contact Email |
The contact email given for the asset, if provided. |
|
License |
The license under which the asset was released, if provided. |
|
Attribution |
The name of the organization the asset is attributed to, if applicable and if provided. |
|
Attribution Link |
The link to the organization the asset is attributed to, if applicable and if provided. |
|
Published Version Name |
The name of the published version of the asset, missing if the asset only exists as a draft. |
|
Published Version UID |
The name of the published version of the asset, missing if the asset only exists as a draft. |
|
Parent UID |
For derived asset, the unique identifier of their parent dataset, missing for default assets with no parent. |
Using the Asset Inventory Dataset
The Asset Inventory system dataset can be a valuable tool for catalog management and dataset tracking. With this dataset, you can do anything you would with any other dataset on your platform. This dataset can be used with visualizations, measures, and can be filtered, sorted and aggregated using the same functions you are used to in the Grid View, and filtered views can be created and published internally or publicly if desired. The only difference between this system dataset and a normal dataset on your platform is that system datasets:
-
Are automatically generated by the platform
-
Cannot be modified
-
Are always private and hidden from your public Catalog
-
Are private assets that can only be seen by users allowed to view other assets (for example Admin roles)
Here are some examples of ways to use the Asset Inventory system dataset to answer important questions.
-
What has been most recently published?
-
Sort the Creation Date column in descending order, so that the most recently created asset is at the top.
-
If you’d like to know only assets that are actually published, you can add a filter on the Publication Stage columns for “published.”
-
-
Who is publishing the most assets?
-
First, you’ll want to create a filter on the dataset for entries where the column Publication Stage is “published."
-
Then, use the Sort & Roll-Up function to group by the columns Owner and Type, roll-up on column UID by the count function. Finally, sort the UID column in descending order to have the highest count at the top.
-
Finding the Asset Inventory Dataset
The Asset Inventory is a system dataset on your domain. The easiest way to find these datasets are to navigate to the internal asset manager:
Next, to see system datasets, filter the list of assets to only include asset type System Dataset. You can also navigate directly to the Asset Inventory dataset using the button at the bottom of the Asset Manager.
The result of this filter should be your system datasets where you can find your Asset Inventory!
Comments
Article is closed for comments.