Data sources

Data Management is the place your data source connections live. Here you can create and modify connections to your internal systems or third-party applications and explore their content. It gives you an overview of all the data used in your apps.

Connecting a new data source

For each type of resource, you can find a detailed description of how you connect it in the BigQuery section. The procedure is always the same. You click on "New source" and select the data source you wish to connect. After entering all required details or connecting to the service via OAuth2 you save the data source connection by clicking on "Connect".

Inspecting the structure

The navigation lists all the data sources that you connected. For all databases, you will find a tree structure with multiple levels that resembles how the databases is structured internally. For example, for a PostgreSQL it will resemble it's schema. For a Google Sheet, you will find all whitelisted files on the first level and each sheet/tab in the Google Sheet file on the second level.

For resources that specify a connection to an endpoint, to a data storage that is not hierarchically structured or where the structure is not known in advance or subject to change, we do not provide a multi-level image of its inner workings. Examples include Slack, OpenAI and the REST API.

Since each data source can be configured for Staging or Production and the content of the data source can be entirely different, we allow you to switch between the two environments in the navigation:

Refreshing the structure

Naturally, the content of your database can change. For example, a table might be added, deleted or moved. To keep the structure of your data source up to date, you can click on the refresh icon in the top of the navigation bar. The currently selected data source will then be refreshed. A loading indicator signals if the refreshing process is still ongoing and will vanish when it is done. Changes to the structure of the database, like additions and deletion of tables, will then also be reflected in the navigation bar.