The New Asset Inventory 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 Socrata 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 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.

How can I make use of 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.”

    • Alternatively, you could also view these 2 cards on a Data Lens page and filter Creation Date by a set of dates.

  • 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.

How do I find my Asset Inventory system 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:

image-20200307-001257.png

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.

ded0c4ba-c559-4dfa-99a0-151bd4e32fbf.gif

The result of this filter should be your system datasets where you can find your Asset Inventory!

b38219e8-06b4-4b56-aef9-fed6dfdcbb8e.png

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.