Configure dataset, table, and column
Last updated
Last updated
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
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.
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
