SingleStore¶
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 ↗.
Configuration¶
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. | — |
Networking¶
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 |
|---|---|
| \ |
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 |
| \ |
If UseSSH=TRUE, default SSHPort=22 |
中文翻译¶
SingleStore¶
SingleStore 连接器是 Palantir 提供的用于 SingleStore 的驱动程序。
要创建新的 SingleStore 数据源,请遵循 Palantir 提供驱动程序的标准设置流程,然后使用以下各节进行 SingleStore 特定的配置和网络设置。有关完整的属性参考,请参阅官方 SingleStore 驱动程序文档 ↗。
配置¶
以下属性为必填或推荐项。
| 属性 | 是否必填 | 描述 | 默认值 |
|---|---|---|---|
AuthScheme ↗ |
必填 | 用于身份验证的方案。 | Password |
Server ↗ |
必填 | 托管 SingleStore 数据库的服务器主机名或 IP。 | {serverAddress} |
UseSSL ↗ |
必填 | 此字段设置是否启用 SSL。 | TRUE |
Database ↗ |
推荐 | SingleStore 数据库的名称。 | — |
InitiateOAuth ↗ |
推荐 | 指定获取或刷新 OAuth 访问令牌的过程,该令牌在已认证的授权用户工作时维持其访问权限。 | REFRESH |
OAuthClientId ↗ |
推荐 | 指定创建自定义 OAuth 应用程序时分配的客户端 ID(也称为消费者密钥)。此 ID 将自定义应用程序注册到 OAuth 授权服务器。 | — |
OAuthClientSecret ↗ |
推荐 | 指定创建自定义 OAuth 应用程序时分配的客户端密钥(也称为消费者密钥)。此密钥将自定义应用程序注册到 OAuth 授权服务器。 | — |
Password ↗ |
推荐 | 指定认证用户账户的密码。 | — |
Port ↗ |
推荐 | 托管 SingleStore 数据库的服务器的端口。 | 3306 |
User ↗ |
推荐 | 指定认证 SingleStore 用户账户的用户 ID。 | — |
网络配置¶
下表列出了数据源为成功运行而需要能够访问的域名。
对于每个域名,添加相应的出口策略。如果数据源托管在本地且无法从 Foundry 直接访问,请改用代理出口策略;代理主机本身也必须能够访问列出的域名。有关详细信息,请参阅使用代理作为代理。
| 域名 | 是否必填 |
|---|---|
| \ |
如果 UseSSH=FALSE,Server 支持列出多个地址(例如 Server='192.168.1.100,192.168.1.101')。Port 支持列出多个端口(例如 Port='3306, 3307');默认 Port=3306 |
| \ |
如果 UseSSH=TRUE,默认 SSHPort=22 |