All Products
Search
Document Center

Dataphin:Configure dimension/logical fact tables

Last Updated:Jan 21, 2025

This topic outlines the properties and scheduling configurations necessary for logical table tasks, including the scheduling cycle, dependencies, and parameters.

Logical table task configuration entry

  1. Navigate to the Development section via the top menu bar on the Dataphin home page.

  2. Use the operation guide depicted below to reach the logical table task configuration page.

    image..png

Configure logical table tasks

The logical table task configuration page allows you to set up basic information and scheduling-related properties for logical table tasks.

Configuration Item

Description

Basic Information

This includes the table type, business object, subject area, data latency, Chinese name, description, development owner, and operation and maintenance owner. You can modify the following parameters:

  • Chinese Table Name: The name given to the logical table upon creation.

  • Description: The description entered during the creation of the logical table.

  • Development Owner: By default, this is the current user, but any member of the current project can be selected.

    Note

    Note: The development owner cannot be configured in the production environment; the development environment's configuration will be used instead.

  • Operation and Maintenance Owner: The default is the node's creator, but you can also select from members of the current project.

Scheduling Configuration

Configure the logical table's scheduling, which includes data latency, scheduling properties, upstream dependencies, parameter settings, runtime configuration, and resource allocation.

Materialization Configuration

Materialization configuration determines the lifecycle, partition fields, and custom parameters for dimension and logical fact tables. It also allows for manual adjustments to the number of materialized tables and the distribution of fields within them, enhancing data query performance and resource efficiency in automatically generated models.

Downstream Objects

Downstream objects include atomic metrics and business filters derived from referencing the logical table's fields. You can manage these objects by viewing, creating, cloning, or unpublishing them.

Related Objects

Related objects pertain to other logical tables that are dimensionally associated with the current table, tables from which the current table reads, and calculation/integration tasks that use the current table as an input.