Skip to main content

​
Unique identifiers

Hightouch requires a unique identifier in the destination Cockroach table to add, remove, and update rows. The column must be either a UNIQUE or PRIMARY KEY column. At least one Hightouch field must map to a unique column. If you’re unsure whether your mapping includes a compatible column, just try it. Hightouch will error if you need to change your mappings.

​
Column types

Hightouch works out of the box with all standard column types, including:
  • BIGINT
  • INT
  • TEXT
  • VARCHAR
  • TIMESTAMPTZ
  • BOOLEAN
  • DECIMAL
If you see type errors, it may be because your SQL query is producing the wrong format. Message us on Intercom if you need help.

​
Required permissions

Your Cockroach credentials must be able to:
  • SELECT, INSERT, UPDATE and DELETE rows from the destination table.
  • Perform the following queries:
    • SHOW SCHEMAS
    • SHOW TABLES FROM <schema>
    • SHOW CONSTRAINTS FROM <schema>.<table>
    • SHOW COLUMNS FROM <schema>.<table>

​
Tips and troubleshooting

To see the exact API requests and responses from each sync run, use the live debugger. To get notified by Slack, PagerDuty, SMS, or email when a sync fails, set up sync alerts. If you run into an issue this page doesn’t cover, .
Last modified on November 28, 2022