Getting Started with CLAIRE GPT

Back Next

Data exploration examples

Let's take a look at a few examples to help you get started on your data exploration journey in

CLAIRE GPT

. The examples show how you can explore source data, see SQL codes used to fetch sample data, and download sample data.

CLAIRE GPT

displays a sample data preview of the ORDERS table as shown in the following image:

To see the SQL code used to fetch the sample data, click

Show Code

The following image shows the SQL code used to fetch the sample data of the ORDERS table:

Additionally, you can copy the code for further analysis.

To save the sample data in a CSV file for future reference, click

Download

If you refresh the browser or log out of

CLAIRE GPT

, the sample data will no longer be visible in the conversation, and you will be unable to download it.

The following image shows the greyed out sample data after a browser refresh:

CLAIRE GPT

displays the shipping date for the order ID 5 from the ORDERS table as shown in the following image:

CLAIRE GPT

displays the total number of orders placed between 2021-01-01 and 2022-03-09 as shown in the following image:

CLAIRE GPT

displays the staff members who managed stores located in London or Santa Cruz as shown in the following image:

To see the SQL code used to fetch the sample data, click

Show Code

The following image shows the SQL code with JOIN clause used to fetch the staff members who managed stores located in London or Santa Cruz:

CLAIRE GPT

includes regular expressions in the SQL code to improve the accuracy and speed of data exploration responses.