Power internal tools, in-app experiences, and more
Hightouch requires a unique identifier in the destination Cockroach table in order to add, remove, and update rows. The column must be either a
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.
Hightouch works out of the box with all standard column types, including:
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!
Your Cockroach credentials must be able to:
DELETErows from the destination table.
- Perform the following queries:
SHOW TABLES FROM <schema>
SHOW CONSTRAINTS FROM <schema>.<table>
SHOW COLUMNS FROM <schema>.<table>