Creating a datasource

A datasource is a single table that you can pull into a datasource. A datasource could pull data from a single sheet in a spreadsheet, it could be a single table from your database or even a complex query that does joins, filters and aggregations.
To create a datasource, you can do it in one of two places:

1. Create a datasource from an auto-discovered table

From the integration you just created, you would be able to see all the tables auto-discovered by our system. To create a datasource from any of them, just click on + Create next to each of them. This will create your datasource and annotate its columns automatically.

2. Create a datasource manually

Head over to the data sources page and click on New Data Source. Now fill in a name, a description and the integration the datasource should pull from and click Create datasource.

On the page that appears, you can now either pick a table to use or write an SQL query for supported datasources. If you need to query the results but do not know how to write SQL, you can also the use AI to generate a query for you.

Once you have selected a table or you have written a query, click on the button labelled Save Changes on the top right corner. The AI now kicks in to try and understand your data source better. Once this step is done, you can fine tune the column descriptions to be more descriptive and make your data more understandable.

At any time, if your datasource schema has changed and the columns on Onvo AI do not accurately reflect your data, you can click on the button labelled Refetch Descriptions on the top right corner to trigger a refresh of the columns and sample data.