Asset Page

Overview

Asset pages provide you with more details on the metadata, the usage, the health state of your assets as well as the upstream and downstream dependencies, which allows you to:

  • Learn more about your assets and what they are generally used for
  • Troubleshoot data issues
  • Ensure your data assets are correctly covered by your monitoring
Asset Page

Snowflake Table Asset Page

Header

The top of asset pages contains details about the asset's:

  • Technology
  • Type
  • Name
  • Fully qualified name: currently available for Tables & Views assets and declared assets
  • Health status

It also allows you to perform various actions on your assets such as: pinning or unpinning the asset to your dashboard, creating a monitor on the asset, viewing the asset on its original technology platform, copy the asset URI or ID.

Pin/Unpin

Clicking the Pin button allows you to pin your data asset to your Dashboard page in order to be able to quickly access it when landing on Sifflet's homepage.

Pin Button

Pin Button

Pinned Data Asset

Pinned Data Asset

To unpin a data asset from your dashboard, click the Unpin button.

New monitor

Click the New Monitor button to start creating a monitor on your data asset.

View in

Click the View in <TECHNOLOGY_NAME> button to open the asset on its original technology platform in a new tab. This is currently available for BI integrations as well as Snowflake, BigQuery, and Databricks.

Overflow Menu

Click the Copy data asset URI or Copy data asset ID buttons to copy the asset URI or ID to your clipboard. This is useful when you want to interact with data assets programmatically (e.g. via API endpoints, monitors as code, etc.).

Overview Tab

The Overview tab provides you with general information about your asset metadata and overall health status.

Details Section

The Details section contains details about your asset:

  • Data source name
  • Last & next metadata refresh dates
  • Data usage (only Tables & Views, Dashboards)
  • Time windows & offset (only Tables & Views)
  • Tags
  • Business terms
  • Owners
  • Description, which can be automatically extracted from your data source and/or manually edited by your team on Sifflet

Time Window & Offset Edit

You can edit the time window and offset parameters of your data asset.

Time Window & Offset Edit

Time Window & Offset Edit

Edit

Clicking the Edit button allows you to modify your data asset tags, business terms, description, and owners.

Asset Page Edit Modal

Tags, Business Terms, Description, Owners Edit

SQL

Clicking the SQL button on your Tables & Views and Pipelines assets allows you to see the SQL query associated with your data assets. This often allows you to get even more details on how your data assets pertain to one another.

  • For Tables & Views assets, the SQL corresponds to the table or view creation query.
  • For Pipelines (dbt models), the shown SQL corresponds to the dbt model source code. If you're interested in the compiled version of the dbt model source code, you should be able to find it looking at the SQL of the model's downstream assets.
SQL

SQL Query

Preview data

Clicking Preview data allows you to preview the first rows of your Tables & Views data assets. To preview data:

  • Select the number of rows you're interested in visualizing
  • Tick the Show all X columns checkbox or use the dropdown menu to only tick the boxes associated with the columns you are interested in previewing.
  • A table showing the first rows of your Tables & Views shows up.
Previewing Data

Previewing Data

Once you are done, click Close or the cross at the top of the modal.

Data Quality Section

The Data Quality section shows an overview of the Tables & Viewsassets' health.

Asset quality status is based on whether or not the asset is covered by monitors as well as on the severity of the incidents impacting the data asset:

  • Urgent incidents: asset has at least one configured monitor & asset has at least one ongoing incident with a Critical severity.
  • High risk incidents: asset has at least one configured monitor & asset has at least one ongoing incident with a Low, Moderate, or High severity.
  • No incidents: asset has at least one configured monitor & does not have any ongoing incident.
  • Not monitored: asset does not have any configured monitor.
Possible Quality Statuses

Possible Quality Statuses

If the asset is monitored, you can see the list of monitors configured on it as well as the state of incidents that happened on this asset. Clicking See details redirects you to the Data quality tab allowing you to dive deeper in the health state of your asset.

High Risk Incident Data Asset

High Risk Incident Data Asset

If the asset is not monitored, the status of the asset shows up as Not monitored.

Unmonitored Data Asset

Unmonitored Data Asset

Columns Section

The Columns section provides you with the number of columns as well as the list of column names and types of your Tables & Views assets. Clicking See details redirects you to the Columns tab which contains more details about the content of your tables, its different versions, etc.

Data Asset Columns

Data Asset Columns

Columns Tab

The Columns tab provides you with the total number of columns on your asset as well as detailed information about each individual column of your Tables & Views assets:

  • Column name
  • Column type
  • Column tags (regular tags or classification tags) and business terms
  • Monitored or not, indicates whether you have configured monitors on this field or not
  • Column description, automatically extracted from your data source and/or manually edited by your team on Sifflet
Asset Page Columns Tab

Data Asset Columns

Edit

Clicking the pencil icon at the end of any field row allows you to modify your fields' tags and descriptions.

Asset Page Columns Tab Field Edit

Single Field Editing

You can also tick multiple fields to bulk edit their tags and descriptions.

Asset Page Columns Tab Field Bulk Edit

Field Bulk Editing

Search columns

You can use the search bar to quickly sift through your columns and find the one you are interested in. The search is performed on column names.

Columns Search Bar

Columns Search Bar

Preview data

Clicking Preview data allows you to preview the first rows of your Tables & Views data assets.

Select the number of rows and tick the boxes associated with the columns you are interested in previewing. A table showing the first rows of your Tables & Views shows up.

Bla

Previewing Data

Once you are done, click Close or the cross at the top of the modal.

Versions

The version dropdown menu allows you to navigate through the different versions of your Tables & Views assets schemas.

Schema Version Dropdown

Schema Version Dropdown

AI Suggestions

Sifflet automatically generates classification tags and description AI suggestions for your Tables & Views columns.

Data quality Tab

The Data quality tab of Tables & Views assets provides you with details about the health of your data asset.

The Incidents subtab displays any ongoing incidents that might be linked to your data asset.
Toggling on Show closed incidents allows you to look at both ongoing and closed incidents, making it easy for you to spot any patterns in the anomalies occurring on a given asset.

Data Asset Incidents

Data Asset Incidents

The Monitors subtab displays all monitors configured on your data asset, allowing you to assess your asset health state of your asset as well as its monitoring coverage.

Data Asset Monitors

Data Asset Monitors

Lineage Tab

The Lineage tab displays all the interactions between your assets down to the field level. You can look either upstream or downstream to perform, for instance, root cause analyses or check the potential impacts of a table on others. For more information, look at this specific section.

Typical lineage of a data asset