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

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.

Table 1 Data sources supported by password datasource authentication

Job Type

Table Type

Data Source

Spark SQL

-

GaussDB(DWS), RDS, DDS, and Redis

Flink OpenSource SQL

Source table

GaussDB(DWS), RDS, and Redis

Result table

GaussDB(DWS), RDS, CSS, and Redis

Dimension table

GaussDB(DWS), RDS, and Redis

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.