The SingleStore connector is a Palantir-provided driver for SingleStore.
To create a new SingleStore source, follow the standard setup flow for Palantir-provided drivers, then use the sections below for SingleStore-specific configuration and networking. For the complete property reference, see the official SingleStore driver documentation ↗.
The properties below are mandatory or recommended.
| Property | Required? | Description | Default |
|---|---|---|---|
AuthScheme ↗ | Mandatory | The scheme used for authentication. | Password |
Server ↗ | Mandatory | The host name or IP of the server hosting the SingleStore database. | {serverAddress} |
UseSSL ↗ | Mandatory | This field sets whether SSL is enabled. | TRUE |
Database ↗ | Recommended | The name of the SingleStore database. | — |
InitiateOAuth ↗ | Recommended | Specifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working. | REFRESH |
OAuthClientId ↗ | Recommended | Specifies the client Id that was assigned when the custom OAuth application was created. (Also known as the consumer key.) This ID registers the custom application with the OAuth authorization server. | — |
OAuthClientSecret ↗ | Recommended | Specifies the client secret that was assigned when the custom OAuth application was created. (Also known as the consumer secret). This secret registers the custom application with the OAuth authorization server. | — |
Password ↗ | Recommended | Specifies the password of the authenticating user account. | — |
Port ↗ | Recommended | The port of the server hosting the SingleStore database. | 3306 |
User ↗ | Recommended | Specifies the user ID of the authenticating SingleStore user account. | — |
The table below lists the domains that the source needs to be able to access in order to successfully run.
For each domain, add a corresponding egress policy. If the source is hosted on-premises and not directly reachable from Foundry, use an agent proxy egress policy instead; the agent host itself must also be able to reach the listed domains. See using an agent as a proxy for details.
| Domain | Required |
|---|---|
| <Server>:<Port> | If UseSSH=FALSE, Server supports listing multiple addresses (i.e., Server='192.168.1.100,192.168.1.101'). Port supports listing multiple addresses (i.e., Port='3306, 3307'); default Port=3306 |
| <SSHServer>:<SSHPort> | If UseSSH=TRUE, default SSHPort=22 |