This topic outlines the process of creating a real-time compute table as part of the fundamental workflow in real-time development. Initially, the MySQL order system's oms_order table holds order details. The real-time task is to continuously extract incremental data from this table to compute the Gross Merchandise Volume (GMV). The next step involves creating a corresponding real-time meta table that can access the incremental data from the order table.
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.