In the real-time development workflow, the MySQL oms_order table stores order details. To compute Gross Merchandise Volume (GMV) from incremental order data, you create real-time meta tables that read from the source tables.
Step 1: Create the oms_orders order source meta table
-
Navigate to the Dataphin home page and single click Development in the top menu bar.
-
Use the operation guide shown below to access the New Table dialog box.
-
On the New Table page, set the relevant parameters as follows:
Parameter
Description
Table Type
Choose Meta Table.
Meta Table Name
Enter oms_orders.
Datasource
Select the previously created flink_dataphin data source.
Source Table
Choose the oms_orders source table.
Read Mode
Select CDC Source Table for incremental streaming read.
Select Directory
The default is Table Management.
Description
Provide a brief description of the meta table, such as Order Source Table.
-
To submit the meta table, single click OK.
Step 2: Create the ads_gross result meta table
-
Use the operation guide shown below to access the New Table dialog box.
-
On the New Table page, set the relevant parameters as follows:
Parameter
Description
Table Type
Choose Meta Table.
Meta Table Name
Enter ads_gross.
Datasource
Select the previously created flink_dataphin data source.
Source Table
Choose the ads_gross source table.
Read Mode
Select JDBC Read/Write Table to enable JDBC support for table queries, writes, stream writes, and batch read/write operations.
Select Directory
The default is Table Management.
Description
Provide a brief description of the meta table, such as Category Sales Total Result Table.
-
To submit the meta table, single click OK.