Connecting to CockroachDB
This section contains details for CockroachDB connections.General information
Field | Description |
---|---|
Data source | CockroachDB |
Supported versions | 42.5.1 |
Connection string | postgresql:// |
Packaged? | Yes |
Certified? | Yes |
Supported features | |
Estimate job | Yes |
Analyze data | Yes |
Schedule | Yes |
Processing capabilities | |
Pushdown | No |
Spark agent | Yes |
Yarn agent | Yes |
Parallel JDBC | Yes |
Java Platform version compatibility | |
JDK 8 | Yes |
JDK 11 | Yes |
Minimum user permissions
In order to bring your CockroachDB data into Collibra Data Quality & Observability, you need the following permissions.
- Read access on your CockroachDB tables.
- ROLE_ADMIN assigned to your user in Collibra DQ.
Recommended and required connection properties
Required | Connection Property | Type | Value |
---|---|---|---|
Yes | Name | Text | The unique name of your connection. Ensure that there are no spaces in your connection name. |
Yes | Connection URL | String | The connection string path of your CockroachDB connection. When referring to the example below, replace the Example |
Yes | Driver Name | String | The driver class name of your connection.
|
Yes | Port | Integer | The port number to establish a connection to the datasource. The default port is |
No | Source Name | String | N/A |
No | Target Agent | Option | The Agent that submits your Spark job for processing. |
Yes | Auth Type | Option | The method to authenticate your connection. Note The configuration requirements are different depending on the Auth Type you select. See Authentication for more details on available authentication types. |
No | Properties | String | The configurable driver properties for your connection. Multiple properties must be comma delimited. For example, abc=123,test=true |
Authentication
Select an authentication type from the dropdown menu. The options available in the dropdown menu are the currently supported authentication types for this data source.
Required | Field | Description |
---|---|---|
Yes | Username | The username of your CockroachDB account. |
Yes | Principal | The Kerberos entity to authenticate and grant access to your connection. |
Yes | Password | The password of your CockroachDB account. |
Yes | Keytab | The file path of the keytab file that contains the encrypted key for a Kerberos principal. Example /tmp/keytab/impala_user.keytab |
Yes | Script | The file path that contains the script file that the password manager uses to interact with and authenticate a user account. Example /tmp/keytab/cockroachdb_pwd_mgr.sh |
No | Param $1 | Optional. An additional parameters to authenticate your CockroachDB connection. |
No | Param $2 | Optional. An additional parameter to authenticate your CockroachDB connection. |
No | Param $3 | Optional. An additional parameter to authenticate your CockroachDB connection. |
Yes | TGT Cache | The ticket-granting ticket cache that stores the TGT to authenticate your connection. |