Configure dataset, table, and column
Dataset Details
Once a data connector is successfully connected to a dataset in BigQuery, users can configure specific details. The interface provides information about the dataset, including its name and description retrieved from BigQuery.
Users have the option to add or enhance the description for the dataset. This description serves as crucial contextual information for the AI system. By providing a comprehensive description, users empower the AI to better understand the dataset's content, purpose, and context. system will retrieve the dataset, table and column descriptions from BQ automatically.If there is no description, we can add it manually

to edit description clik edit button
Table Configuration
selecting tables and columns will determine the result data, select the tables and columns needed
Users can select multiple tables within the connected dataset. For each table, the following information is displayed:

Table Name: The name of the table.
Show Detail : to edit to view and edit description

Table Description: A description of the table obtained from BigQuery.

Checkbox to Enable: Users can select or enable multiple tables by using checkboxes, providing flexibility in data configuration.

Column Configuration
selecting tables and columns will determine the result data, select the tables and columns needed
click show detail for specific table to and click columns to view column

Users can select multiple column within the connected dataset. For each column, the following information is displayed:

Column Name: The name of the table.
Show Description : to edit to view and edit description

Checkbox to Enable: Users can select or enable multiple column by using checkboxes, providing flexibility in data configuration.

You have completed the configuration for your new data connector, providing the system with valuable information about the dataset, tables, and columns. The established connection with the selected dataset in BigQuery enables seamless data interaction
Last updated