Integration · Azure SQL and PostgreSQL
Your own database, only read.
Datahub connects to Azure SQL Database and PostgreSQL for insights, metrics and flows. Every statement is checked before it leaves: only reads get through.
SELECT region, SUM(amount)ReadDELETE FROM ordersNot a readRefusedDatabase
What you build with it
Insights, metrics and flows on your own tables.
What AI sees
Two switches. The stricter one applies.
An AI assistant only sees the database's structure by default. Rows come along only when the connection is set to metadata and data and the organisation allows it too. If either is set to metadata only, it stays that way.
ConnectionMetadata and dataOrganisationMetadata onlyThe stricter applies: AI sees metadata only
The organisation says no, so it stays at metadata.
Where you use it
One connection, three places.
How to connect your database
From database to first insight in four steps.
Frequently asked questions
What administrators ask before they connect.
Next step
Put your database to work, without risk.
An intro call maps which databases you run and what it takes to connect them.