Updated on 2025-05-20 GMT+08:00

Connecting to a DLI Data Source

DataArts Insight allows you to connect to a DLI data source. This section describes how to connect DataArts Insight to a DLI data source.

Procedure

  1. Log in to the DataArts Insight console.
  2. Click in the upper left corner of the management console to select a region and select an enterprise project from Enterprise Project in the upper right corner of the Workspace page.
  3. On the top menu of the console, click Project. On the displayed My Projects page, click the name of the desired project.
  4. In the navigation pane on the left, choose Data Management > Data Sources. On the displayed page, click Create Data Source. In the displayed slide-out panel, set Source Database Type to Data Lake Insight.
  5. Set other parameters based on Table 1.
    Figure 1 Connecting to a DLI data source
    Table 1 Parameters

    Parameter

    Mandatory

    Description

    Source Database Type

    Yes

    Type of the accessed data source. In this example, Data Lake Insight is selected.

    Name

    Yes

    Name of the data source displayed in the list.

    Description

    No

    Description of the data source, which is user-defined.

    Project ID

    Yes

    The project ID of the current account is used by default. You can also enter a project ID of another account. To obtain the project ID, click Get and refer to the document.

    AK

    Yes

    • Access key ID. It is the unique ID associated with the SK. An AK is used together with an SK to cryptographically sign requests.
    • To obtain the AK, click Get and refer to the document.

    SK

    Yes

    • Secret access key used together with the access key ID to sign requests cryptographically. It identifies a request sender and prevents the request from being modified.
    • To obtain the SK, click Get and refer to the document.

    SQL Queue

    Yes

    Queues serve as fundamental computing resources essential for using services. Every job executed by users depends on these computing resources. Specifically, SQL queues are designated for executing SQL jobs. If a job is added to or deleted from an SQL queue, click the refresh button next to SQL Queue to refresh the SQL queue.

    Data Directory

    Yes

    Data directory of the SQL queue.

    NOTE:

    If Data Directory is dli, DLI is not interconnected with LakeFormation and the file upload button is unavailable. If Data Directory is not dli, DLI is interconnected with LakeFormation and the file upload button is available.

    Database

    Yes

    Name of the database to be logged in to.

  6. Click Test Connection to test the data source connectivity.
  7. Once the test is successful, click OK.