Click on Add Data Source to add an authenticated connection to an external PostgreSQL database. The form consists of 5 inputs: Database Name, Username, Password, Provider, Hostname. We currently only support PostgreSQL. A port is mandatory to the Hostname field.

On the Data Sources Page you can edit connections, edit schema/add columns and remove the connection.

Schema

Once you have connected a data source to Provably, you can manually choose the columns you want to make available for analytics. Each row consists of four fields: Column Name, Column Type, Schema Name, and Table Name, which describe a single column.

A data schema is mandatory, as without it, an insight seeker will not be able to know which queries they can run.