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:
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:
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:
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:
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:
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:
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:
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:
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":
Using a specific keyword, you can search and discover the following assets:
•Assets with names that match the keyword and are semantically similar to the keyword.
•Assets in a hierarchy with names that match the keyword and are semantically similar to the keyword.
•Assets related to business objects with names that match the keyword and are semantically similar to the keyword.
•The Explanation section provides a comprehensible statement about how the response is derived.
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:
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 %:
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:
Prompt: Show all dashboards
The following image shows the response of CLAIRE GPT to the prompt, 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:
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:
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:
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:
CLAIRE GPT includes a list of related asset types along with the aggregate count in the response summary.