Create a Lindorm (Wide Table) data source (Deprecated)
Create a Lindorm (Wide Table) data source to enable Dataphin to read data from or write data to a Lindorm (Wide Table) instance.
The Lindorm (Wide Table) data source is deprecated, and you can no longer create this type of data source. You can use the Lindorm data source (wide table engine - HBase connection type) instead. For more information, see . Lindorm (Wide Table) data sources created before version 6.1 remain functional.
Background
Lindorm (Wide Table) is an Alibaba Cloud database service that provides multiple data models, including wide table, time series, file, and search. It supports millisecond-level online data processing and low-cost storage and analysis for massive datasets. For more information, see Alibaba Cloud Lindorm.
Permissions
Only custom global roles with the Create Data Source permission and system roles such as Super Administrator, Data Source Administrator, Plate Architect, and Project Administrator can create data sources.
Procedure
-
On the Dataphin homepage, click Management Center > Data Source Management in the top navigation bar.
-
On the Data Source page, click + New Data Source.
-
On the New Data Source page, in the NoSQL section, select Lindorm (Wide Table).
If you have recently used Lindorm (Wide Table), you can also select it in the Recently Used section, or enter keywords in the search box to find it.
-
On the New Lindorm (Wide Table) Data Source page, configure the connection parameters for the data source.
-
Configure the basic information for the data source.
Parameter
Description
Data Source Name
The name must meet the following rules:
-
Can contain only Chinese characters, uppercase and lowercase letters, digits, underscores (_), and hyphens (-).
-
Must be 64 characters or less in length.
Data Source Code
After the data source code is configured, you can reference tables in a Flink SQL task by using the format
data_source_code.table_nameordata_source_code.schema.table_name. To automatically access the data source for the current environment, use the variable format${data_source_code}.tableor${data_source_code}.schema.table. For more information, see How to develop Flink SQL tasks.ImportantThe 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. Maximum length: 128 characters.
Data Source Configuration
Select a data source configuration:
-
If separate instances are used for production and development, select Production + Development Data Source.
-
If a single instance is used for both production and development, select Production Data Source.
Tag
Tags for classifying data sources. For more information, see Manage data source tags.
-
-
Configure the connection parameters between the data source and Dataphin.
If you selected Production + Development Data Source, configuration sections for both production and development environments appear. If you selected Production Data Source, only the production section appears.
NoteAs a best practice, use separate instances for production and development to ensure environment isolation. However, you can use the same instance for both by providing identical connection parameters.
Parameter
Description
Endpoint
The connection address of the Lindorm (Wide Table) instance. For the connection address, see Alibaba Cloud Lindorm - Connect to and use an instance.
Namespace
The namespace for the Lindorm (Wide Table) instance. Default value:
default.Username and Password
The username and password for accessing the Lindorm (Wide Table) instance.
Connection Parameters
Connection parameters for Lindorm (Wide Table), in JSON format.
-
-
Click OK to save the configuration and create the Lindorm (Wide Table) data source.