- Schema:
EXTERNAL_ BI_ OBJECTS view¶
This Account Usage view displays a row for each object that Horizon Catalog metadata connectors collect from external BI tools, such as Tableau and Power BI. The view includes both leaf objects, such as dashboards and charts, and the containers that hold them, such as folders, projects, and datasets.
For objects collected from databases, data warehouses, and data pipeline tools, see the EXTERNAL_DWH_OBJECTS view.
Columns¶
| Column name | Data type | Description |
|---|---|---|
| REFERENCE_ID | TEXT | Snowflake-generated identifier of the object. This value is always present and uniquely identifies the object. |
| EXTERNAL_ID | TEXT | Identifier of the object in the BI tool, when known. Otherwise, NULL. |
| NAME | TEXT | Name of the object in the BI tool. |
| OBJECT_TYPE | TEXT | Type of the object. Rows for containers have one of the following values: |
| PARENT_REFERENCE_ID | TEXT | REFERENCE_ID of the object’s immediate parent in this view. NULL for top-level objects, such as a root folder. |
| CONNECTOR | TEXT | Display name of the metadata connector that collected the object. This is the connector’s name only, not a fully qualified name. |
| CONNECTOR_TYPE | TEXT | Vendor or type of the BI tool, such as TABLEAU. |
| COMMENT | TEXT | Description of the object. |
| CREATED | TIMESTAMP_LTZ | Date and time when the object was created, as reported by the BI tool. The value comes from the BI tool’s own clock for each object type. For object types that have no creation time in the BI tool, NULL. |
| LAST_ALTERED | TIMESTAMP_LTZ | Date and time when the object was last updated, as reported by the BI tool. The value comes from the BI tool’s own clock for each object type, such as the dashboard update time for dashboards. For object types that have no update time in the BI tool, NULL. |
| DELETED | TIMESTAMP_LTZ | Date and time when Snowflake observed that the object was removed from the BI tool. NULL if the object still exists. |
| PROPERTIES | VARIANT | Additional properties of the object, as an OBJECT. The following keys can be present:
Both values are passed through from the connector without changes. |
| FOLDER_PATH | TEXT | Path of the folder that contains the object in the BI tool. Only rows for dashboards and Tableau data sources have a value. For all other object types, including folders, NULL. |
| URL | TEXT | Link to the object in the BI tool, when the tool provides one. Often NULL for containers. |
Usage notes¶
- Latency for the view may be up to 24 hours.
- The view includes objects that were removed from the BI tool. The
DELETEDcolumn is non-NULL for those objects, and their rows remain in the view; no retention limit currently applies. To list only current objects, filter onDELETED IS NULL. - The hierarchy depends on the BI tool, for example project, then folder, then dashboard, then chart, or dataset, then report query,
then page. Use
PARENT_REFERENCE_IDandOBJECT_TYPEto walk it. - Users and roles that have been granted the OBJECT_VIEWER database role can access this view. For more information, see SNOWFLAKE database roles.
- Access to this view isn’t controlled by privileges on metadata connectors. A role that can query the view sees the objects
from every connector in the account, including connectors it has no
USAGEorREAD EXTERNAL METADATAprivilege on.
Examples¶
List the dashboards that changed in the last 7 days, with the name of the parent folder: