Skip to main content
Data connectors let you query your Attio data directly from the tools your team already uses for analysis, without ETL or exporting data. We currently support the PostgreSQL protocol, so you can generate read-only credentials and connect from any tool that can talk to a PostgreSQL database. See Available data to find the tables you can query and Querying with SQL for worked examples.

​
Creating a data connector

Only admins can access the Data connectors tab in workspace settings, and each workspace is limited to one data connector.
  1. Click your workspace name in the upper-left of your account and select Workspace settings.
  2. Select Data in the left-hand sidebar, then open the Data connectors tab.
  3. Click New data connector, choose the connection type, and give it a name.

​
Disabling and regenerating credentials

To disable a data connector without deleting its credentials, click the … menu on a data connector in the settings page and select Disable. Any queries made with those credentials will fail until you re-enable the data connector from the same menu. If your credentials have been exposed, click Regenerate credentials in the … menu to revoke the old credentials and generate a new set in a single step. Disabled data connectors still count towards your workspace’s limit.

​
Compatibility

Although we support the PostgreSQL protocol for connections and SQL syntax for queries, not every native PostgreSQL function is available, which can cause incompatibility with some systems.