How to Manage Your Data Sources
Table of contents
Data Sources
After adding data sources, you can easily locate them in the Data Sources section.
By selecting a data source, you'll be redirected to the Data Sources screen. This is where can perform several tasks such as:
-
Removing the selected data source.
-
Incorporating team members (individuals without technical expertise won't need to perform any setup themselves).
Read more about what team members are.
How to Toggle Between Data Sources
If you've added more than one data source, or if you've been included as a team member, you can manually pick a specific data source. This data source will then be used to generate and conduct queries. To do this, select the "Data Source" button on the AI Generator, then use the drop-down menu to identify the required active data source.
Choosing the "No database" option in the drop-down menu allows for query generation without adding any database schema. To specify the database engine in use, click on the "Settings" button.
How to Exclude Tables for AI
In addition to switching your active data sources, the "Include/Exclude Tables" option allows for the selecting or deselection of tables to send to OpenAI for SQL query generation. This is particularly handy when dealing with particularly extensive database schemas that OpenAI might struggle with.