Dataphin:Create a Lindorm (Wide Table) data source

Permissions

Only custom global roles with the Create Data Source permission and system roles such as super administrator, data source administrator, domain architect, and project administrator can create data sources.

Procedure

1. On the Dataphin homepage, click Management Center > Data Source Management in the top menu bar.

2. On the Data Source page, click + New Data Source.

3. On the New Data Source page, in the NoSQL area, select Lindorm (Wide Table).

   If you have recently used Lindorm (Wide Table), you can also select it from the Recently Used section. Alternatively, you can enter Lindorm (Wide Table) in the search box to find it quickly.

4. On the New Lindorm (Wide Table) Data Source page, configure the connection parameters.

   1. Configure the basic information for the data source.

      Parameter	Description
      Datasource Name	The naming conventions are as follows: It can contain only Chinese characters, uppercase or lowercase letters, digits, underscores (_), and hyphens (-). The length can be up to 64 characters.
      Datasource Code	After you configure a data source code, you can reference tables from the data source in a Flink SQL node using the format data_source_code.table_name or data_source_code.schema.table_name. To automatically access the data source that corresponds to the current environment, use the variable format ${data_source_code}.table or ${data_source_code}.schema.table. For more information, see Developing with Dataphin Data Source Tables. Important The data source code cannot be modified after it is configured. You can preview data on the object details page in the asset directory and asset checklist only after the data source code is configured. In Flink SQL, only MySQL, Hologres, MaxCompute, Oracle, StarRocks, Hive, SelectDB, and GaussDB data warehouse service (DWS) data sources are currently supported.
      Data source description	A brief description of the data source. The description can be up to 128 characters long.
      Data source configuration	Select the type of data source to configure: If your business data source is separated into production and development environments, select Production + Development data source. If your business data source is not separated, select Production data source.
      Tag	You can use tags to categorize data sources. For more information about how to create tags, see Manage data source tags.

   2. Configure the connection parameters between the data source and Dataphin.

      If you selected Production + Development data source in the previous step, configuration sections for both the production and development data sources are displayed. If you selected Production data source, only the configuration section for the production data source is displayed.

      Note

      The production and development data sources are typically configured as different sources. This practice isolates the development environment from the production environment and reduces the impact of development activities on production. However, Dataphin lets you configure them as the same data source using the same parameter values.

      Parameter	Description
      Endpoint	The endpoint of Lindorm (Wide Table). To obtain the endpoint, see Connect to and use an instance in the Lindorm (Wide Table) documentation.
      Namespace	The namespace of Lindorm (Wide Table). The default value is default.
      Username, Password	The username and password used to access the Lindorm (Wide Table) instance.
      Connection parameters	The parameters for connecting to Lindorm (Wide Table). Configure the parameters in JSON format.

5. Click OK to save the settings and create the Lindorm (Wide Table) data source.