All Products
Search

This Product

    Dataphin:Encoding specification

    Document Center

    Dataphin:Encoding specification

    Last Updated:Jun 23, 2026

    Configure encoding specifications for the intelligent engine to control query syntax and DDL usage in your Dataphin environment.

    Procedure

    1. On the Dataphin home page, single click the Management Center in the top menu bar.

    2. Navigate to the Code Specifications tab as shown below, and configure the settings.

      image..png

      Configuration item

      Description

      Prohibit The Use Of "select *" Syntax In Ad Hoc Queries On Logical Aggregate Tables

      Default: Yes. The system generates multiple materialized tables based on the source table and statistical period of a logical aggregate table. Using select * to query the logical aggregate table causes the underlying SQL to join all materialized tables, resulting in unnecessary resource consumption. Keep this set to Yes to prevent such wastage.

      Important

      Because disabling the permission to use the select * syntax may cause production tasks that already use the select * and SELECT * syntax to fail, ensure that no production tasks use the select * and SELECT * syntax. You can enter select * and SELECT * in the global code search entry for queries. For more information, see the referenced document.

      Prohibit Full Table Scan

      Default: No. Full table scans are resource-intensive. We recommend enabling this option to improve processing efficiency. If you disable this check, make sure no full table scan queries exist in your tasks.

      Prohibit The Use Of Native Flink DDL Statements

      Applies only when the system calculation settings are linked to the real-time computing engine. Default: No. If set to Yes, native Flink DDL statements are not permitted in Flink SQL computing tasks.

      Note

      Native Flink DDL statements expose passwords in plaintext, which may lead to data breaches. Proceed with caution.

      Prohibit Publishing Tasks Using Native Flink DDL To The Production Environment

      Applies only when the system calculation settings are linked to the real-time computing engine and native Flink DDL statements are permitted. Default: No. If set to Yes, tasks containing Native Flink DDL statements in Flink SQL computing tasks cannot be published to the production environment.

      Note

      In Basic mode projects, native Flink DDL statements are not allowed.

    3. Single click OK to finalize the encoding specification configurations.

      To revert all encoding specification configuration items to their default values, single click Restore Defaults.