DocsICP FilingConsole
Documentation
Home Page Dataphin Intelligent Data construction and governance Dataphin-sharing mode (fully managed version) User Guide Management Center Specification set Development guidelines Coding specifications

Coding specifications

Updated at:
Copy as MD
Product
My Favorites

This topic describes the coding specifications for the intelligent engine and explains the available configuration items.

Procedure

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

  2. On the Code Specifications tab, configure the coding specifications.

    image..png

    Configuration item

    Description

    Disable 'select *' syntax in ad hoc queries for logical aggregate tables

    The default value is Yes. The system generates multiple materialized tables based on the source tables and statistical periods of a logical aggregate table. Using the select * syntax to query the logical aggregate table causes the underlying materialization SQL to join all materialized tables, which consumes a large amount of resources. Set this option to Yes to prevent this resource waste.

    Important

    Disabling the permission to use the select * syntax may cause production tasks that use select * or SELECT * to fail. Ensure that no production tasks use this syntax. You can search for select * and SELECT * using the global code search feature. For more information, see Data Studio overview.

    Disable full table scans

    The default is No. A full table scan consumes a large amount of resources. We recommend that you enable this feature to improve processing efficiency. If this feature is disabled, ensure that the job contains no full table scan queries.

    Disable native Flink DDL statements

    This option is available only when a real-time computing engine is attached in the system computing settings. The default value is No. If you set this option to Yes, you cannot write native Flink DDL statements in Flink SQL computing tasks.

    Note

    Native Flink DDL statements store passwords in plaintext. This poses security risks such as data breaches. Proceed with caution.

    Disable publishing tasks that use native Flink DDL to the production environment

    This option is available only when a real-time computing engine is attached in the system computing settings and native Flink DDL statements are allowed. The default value is No. If you set this option to Yes, Flink SQL computing tasks that contain native Flink DDL statements cannot be published to the production environment.

    Note

    If the project is in Basic mode, you cannot use native Flink DDL statements in the project.

  3. Click OK to save the configuration.

    To restore all configuration items to their default values, click Restore Defaults.

Previous：Development guidelinesNext：Header comments for computing tasks