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

No Description Dataset
  • 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:

Multiple Tables Selected
  • Table Name: The name of the table.

  • Show Detail : to edit to view and edit description

List of table that selected
  • Table Description: A description of the table obtained from BigQuery.

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

Enable Checkbox

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

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

Multiple Column
  • Column Name: The name of the table.

  • Show Description : to edit to view and edit description

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

Checkbox

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