Creating a CSS Datasource Authentication

Updated on 2024-09-30 GMT+08:00

View PDF

Scenario

Create a CSS datasource authentication on the DLI console to store the authentication information of the CSS security cluster to DLI. This will allow you to access to the CSS security cluster without having to configure a username and password in SQL jobs.

Create a datasource authentication for a CSS security cluster on the DLI console.

Notes

A CSS security cluster has been created and has met the following conditions:

The cluster version is 6.5.4 or later.
The security mode has been enabled for the cluster.

Procedure

Download the authentication credential of the CSS security cluster.
1. Log in to the CSS management console and choose Clusters > Elasticsearch.
2. On the Clusters page displayed, click the cluster name.
3. On the Cluster Information page displayed, find the security mode and download the certificate of the CSS security cluster.
Upload the authentication credential to the OBS bucket.

Create a datasource authentication.

Log in to the DLI management console.
Choose Datasource Connections. On the page displayed, click Datasource Authentication.

Click Create.

Configure CSS authentication parameters according to Table 1.

**Table 1** Parameters
Parameter	Description
Authentication Certificate	Name of the datasource authentication information to be created. The name can contain only digits, letters, and underscores (_), but cannot contain only digits or start with an underscore (_). The length of the database name cannot exceed 128 characters. It is recommended that the name contain the CSS security cluster name to distinguish security authentication information of different clusters.
Type	Select CSS.
Username	Username for logging in to the security cluster.
Password	The password of the security cluster
Certificate Path	Enter the OBS path to which the security certificate is uploaded, that is, the OBS bucket address in 2.

Figure 1 Creating a datasource authentication-CSS

Create a table to access the CSS cluster.
When creating a table, associate the table with the created datasource authentication to access the CSS cluster.

For example, when using Spark SQL to create a table for accessing the CSS cluster, configure es.certificate.name to set the datasource authentication name and then connect to the CSS security cluster.

Use Spark SQL to create a table for accessing the CSS cluster by referring to Creating a DLI Table and Associating It with CSS.