Creating a Password Datasource Authentication

Scenario

Create a password datasource authentication on the DLI console to store passwords of the GaussDB(DWS), RDS, DCS, and DDS data sources to DLI. This will allow you to access to the data sources without having to configure a username and password in SQL jobs.

Data Sources Supported by Password Datasource Authentication

Table 1 lists the data sources supported by password datasource authentication.

Procedure

1. Create a datasource authentication.
   1. Log in to the DLI management console.
   2. Choose Datasource Connections. On the page displayed, click Datasource Authentication.
   3. Click Create.

      Configure authentication parameters according to Table 2.

      Table 2 Parameters

      Parameter	Description
      Type	Select Password.
      Authentication Certificate	Name of the datasource authentication to be created. The name can contain only digits, letters, and underscores (_), but cannot contain only digits or start with an underscore (_). The name can contain a maximum of 128 characters.
      Username	Username for accessing the data source.
      Password	Password for accessing the data source.

      Figure 1 Creating a datasource authentication – Password
      
2. Access the data source.

   When creating a data source, associate the data source with the created datasource authentication to access the data source.

   Table 3 lists the fields used to associate with the datasource authentication during table creation.

   Table 3 Fields that are used to associate with password datasource authentication during table creation

   Job Type	Parameter	Mandatory	Data Type	Description
   Spark SQL	passwdauth	No	String	Name of datasource authentication. It is applicable to GaussDB(DWS), RDS, DDS, and Redis data sources.
   Flink OpenSource SQL	pwd_auth_name	No	String	This field is used to associate datasource authentications when source, result, and dimension tables are created. Set pwd_auth_name to the name of the password datasource authentication. If this parameter is set, you do not need to configure a username and a password of the data source in SQL jobs.

   For details about how to create a table, see Data Lake Insight Syntax Reference.

   • Flink OpenSource SQL Syntax Reference: Creating a GaussDB(DWS) Source Table