Help & Documentation
Open Support Ticket

Configure Search to Include Reporting Asset Metadata from Collibra

With the introduction of Analytics Marketplace in v7.1.0, discovery and search capabilities across multiple data catalog platforms has been significantly expanded.

You can search for third-party tools' assets without leaving the Metric Insights UI and without recreating them as objects in Metric Insights. Global Search will return the assets with the list of the available metadata and links to proceed to either the asset in the data catalog tool or the actual object in the associated BI tool like Tableau, Power BI, Atlan, Collibra, etc.

PREREQUISITES:

  • Established connectivity with Tableau.

1. Create Dataset from All Reporting Assets

For more details on how to create Datasets, refer to Understanding Datasets.

For more details on how to create a Dataset form Tableau, refer to Create Dataset from Tableau.

  1. Create a Dataset from the All Reporting Assets object.
  2. Note the Dataset ID to be used in Step 2.

2. Create Dataset from All Reporting Assets Dataset

  1. Data Source: select the Data Source used as Data Storage when creating Dataset from the Tableau All Reporting Assets object;
  2. Query: the query is intended to transform standard Tableau fields, such as Created Date, and user-added fields into JSON objects. It must include the ID of Dataset created from the Tableau All Reporting Assets object in "FROM dataset_datasetID".
    • This will ensure that metadata is searchable and appears in search properly formatted.
    • NOTE: Tableau Tags are handled via the Dataset setup and do not require to be transformed into JSON objects.
3. Example Query 
SELECT title
, "Tableau" as content_type
, object_Type
, mi_parsed_id
, object_view_url
, JSON_OBJECT('Created Date',  created ) AS "Created Date"
, JSON_OBJECT('Created By',  created_by ) AS "Created By"
, JSON_OBJECT('Last Modified',  last_modified ) AS "Last Modified"
, JSON_OBJECT('Last Accessed',  last_accessed ) AS "Last Accessed"
, JSON_OBJECT('Total View Count',  total_view_count ) AS "Total View Count"
, tags
FROM  dataset_XXX

Acceptable JSON Formats:

{"Pii Data": ""}
{"Data Steward": "Clyde, Curt", "Business Owner": "Clint", "Technical Owner": "Kyle"}
[{"label":"Catalog","value":"Gifts"}]
[{"name":"Product Type","description":"High level grouping of our products."}]

5. Map Dataset Columns

Use the following mapping example with Allow click through to external tool enabled.

FieldDataset Column
Title Columntitle
Object View URLobject_view_url
Content Type Columncontent_type
Object Type Columnobject_Type
Tags Columntags
Reporting Asset Unique ID
mi_parsed_id

For more details on configuring search across Datasets and Access, refer to Configure Search Across Specific Dataset (v7.1.0+).

6. Add Dataset Columns for Search

  1. Under Dataset Columns for Search, [+Add Dataset Columns].
  2. Dataset Column: choose a custom field column from the Dataset.
    • NOTE: Make sure to add the Tags column without checking Column data is formatted in JSON. This will make objects searchable by Tags.
  3. Column data is formatted in JSON: enable.
  4. Icon: optional.
  5. [Save] and add as many as needed.
  6. [Save]
  7. [Back to Search Setup] and [Update All Search Indexes] at the upper right.

7. Verify Result