Data Discovery > Discover assets from the catalog > Sample prompts
  

Sample prompts

Let's take a look at a few sample prompts to help you get started on your Data Governance and Catalog data discovery journey in CLAIRE GPT. The sample prompts show how you can use CLAIRE GPT to find assets by catalog source type, created date, owner, name, relationships, perform semantic search, and so on.

Prompt: Find catalog sources of type Snowflake, Databricks, and Oracle

The following image shows the response of CLAIRE GPT to the prompt, displaying all catalog sources that belong to the Snowflake, Databricks, and Oracle catalog source types:
Response from CLAIRE GPT displaying the catalog sources of type Snowflake, Databricks, and Oracle.

Prompt: Show all catalog sources that were created in the last 6 months

The following image shows the response of CLAIRE GPT to the prompt, displaying all catalog sources that were created in the last six months:
Response from CLAIRE GPT displaying all catalog sources that were created in the last six months.

Prompt: Get a distribution of sources by catalog source type

The following image shows the response of CLAIRE GPT to the prompt, displaying a distribution of sources by catalog source type:
Response from CLAIRE GPT displaying a pie chart with a distribution of sources by catalog source type.
By default, a pie chart appears in the response. You can switch between tables, bar charts, pie charts, and line charts.

Prompt: Get the total number of data sets grouped by various catalog source types

The following image shows the response of CLAIRE GPT to the prompt, displaying the total number of data sets grouped by various catalog source types:
Response from CLAIRE GPT displaying a bar chart with the total number of data sets grouped by various catalog source types.
By default, a bar chart appears in the response. You can switch between tables, bar charts, pie charts, and line charts.

Prompt: Show me tables from the Snowflake schema MS CDM

The following image shows the response of CLAIRE GPT to the prompt, displaying all tables from the MS CDM Snowflake schema:
Response from CLAIRE GPT displaying tables from the Snowflake schema, MS CDM.
The response also displays a thunderbolt icon for each asset. When you hover over the icon, you can view explanations for each table in the response. The explanation provides information such as why particular tables appear in the response, as well as unique insights for different asset types.

Prompt: List the Snowflake tables created by Discovery_QE team

The following image shows the response of CLAIRE GPT to the prompt, displaying all Snowflake tables created by user DISCOVERY_QE TEAM:
Response from CLAIRE GPT displaying all Snowflake tables created by the user DISCOVERY_QE TEAM.

Prompt: List business terms marked as critical data elements

The following image shows the response of CLAIRE GPT to the prompt, displaying business terms marked as critical data elements:
Response from CLAIRE GPT displaying business terms marked as critical data elements.

Prompt: Find columns associated with business terms that are related to policies that include "personal" in their names

The following image shows the response of CLAIRE GPT to the prompt, displaying all columns associated with business terms that are related to policies, which include "personal" in their names:
Response from CLAIRE GPT displaying the columns associated with business terms that are related to policies, which include "personal" in their names.

Prompt: Find customer tables

The following image shows the response of CLAIRE GPT to the prompt, displaying semantically similar tables that contain information related to the keyword "customer":
Response from CLAIRE GPT displaying semantically similar tables that contain information related to the keyword "customer".
Using a specific keyword, you can search and discover the following assets:

Prompt: Find tables with rating > 3

The following image shows the response of CLAIRE GPT to the prompt, displaying all tables with ratings greater than 3:
Response from CLAIRE GPT displaying the tables with ratings greater than 3.

Prompt: Show data elements that have an accuracy > 70 %

The following image shows the response of CLAIRE GPT to the prompt, displaying all data elements that have an accuracy > 70 %:
Response from CLAIRE GPT displaying all data elements that have an accuracy > 70 %.

Prompt: Show all projects

The following image shows the response of CLAIRE GPT to the prompt, displaying all Informatica Intelligent Cloud Services and Data Governance and Catalog projects:
Response from CLAIRE GPT displaying all projects from Informatica Intelligent Cloud Services and Data Governance and Catalog.

Prompt: Show all dashboards

The following image shows the response of CLAIRE GPT to the prompt, displaying all dashboards available in the catalog:
Response from CLAIRE GPT displaying all dashboards available in the catalog.

Prompt: Show the list of dashboards with customer retention metric

The following image shows the response of CLAIRE GPT to the prompt, displaying all dashboards that are linked to customer retention metrics:
Response from CLAIRE GPT displaying all dashboards that are linked to customer retention metrics.

Prompt: How many business terms are created in the last 100 days?

The following image shows the response of CLAIRE GPT to the prompt, displaying the number of business terms created in the last 100 days and the list of business terms in a tabular format:
Response from CLAIRE GPT displaying the number of business terms created in the last 100 days and the list of business terms in a tabular format.
CLAIRE GPT includes a list of assets in the response to prompts about aggregate counts of assets.

Prompt: Show count of data sets based on their profiling status

The following image shows the response of CLAIRE GPT to the prompt, displaying the count of data sets based on their profiling status:
Response from CLAIRE GPT displaying the count of data sets based on their profiling status.

Prompt: Show relationship overview of @DIM_CUSTOMER

The following image shows the response of CLAIRE GPT to the prompt, displaying the relationship overview of DIM_CUSTOMER:
Response from CLAIRE GPT displaying the relationship overview of DIM_CUSTOMER.
CLAIRE GPT includes a list of related asset types along with the aggregate count in the response summary.