CockroachDB

Power internal tools, in-app experiences, and more

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

Common errors

To date, our customers haven't experienced any errors while using this destination. If you run into any issues, please don't hesitate to reach out. We're here to help.

Live debugger

Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.

Sync alerts

Hightouch can alert you of sync issues via Slack, PagerDuty, SMS, or email. For details, please visit our article on alerting.