Search documentation...

K

CockroachDB

Unique Identifiers

Hightouch requires a unique identifier in the destination Cockroach table in order 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>

    Need help?

    Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.

    • Connection issues with your data warehouse?
    • Confusing API responses from destination systems?
    • Unsupported destination objects or modes?
    • Help with complex SQL queries?

    or

    Feature Requests?

    If you see something that's missing from our app, let us know and we'll work with you to build it!

    We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.

On this page

Unique IdentifiersColumn TypesRequired Permissions

Was this page helpful?