Data operations and maintenance consists of five modules: task management, data connections, queue configuration, storage management, and synchronization configuration. This article introduces the specific operational procedures for each module in data operations and maintenance configuration.
The data operations and maintenance configuration module is provided in system management. Administrators can systematically manage various aspects, including task management, data connections, queue configuration, storage management, and synchronization configuration:
This product provides users with flexible configuration capabilities for task scheduling dependencies. Scheduling dependencies typically refer to the upstream and downstream dependencies between periodic scheduling nodes during data synchronization or data development processes. By orchestrating task execution for upstream and downstream nodes based on their dependencies, downstream nodes will only start running after upstream nodes have successfully completed, ensuring the timely production of valid business data. The dependency configuration of this product offers two main approaches: automatic detection of upstream data output and custom dependency configuration.
If a company already has a scheduling platform for data development or data processing tasks that can be configured according to this product's API specifications, it can be integrated and linked with this product to establish task status dependencies for that scheduling platform. If the company chooses to configure dependencies using a third-party API, users must first perform API configuration in the task management module under system management(that is, the content introduced in this section), and then complete dependency configuration for task scheduling in the visual modeling and dataset dependency configuration modules.
The specific operation process is as follows:
Configuration 1: URL The Key and Value in Params will be automatically appended to the custom URL. The description section contains a sample URL. Configuration 2: Params * Request parameter description: The Key and Value in Params will be automatically appended to the custom URL. The Key name can be customized, and the Value parameter format remains unchanged. The system can automatically pass in specific task parameters based on the parameter content. You can use them as needed. * System parameter Params: | | | \ |Parameters |Remarks | |---|---| | | | \ |${dataSourceType} |Data source type, such as Hive-jdbc, MaxCompute | | | | \ |${dbName} |The database name of the data source in the task | | | | \ |${tableName} |The table name of the data source in the task | | | | \ |${taskTime} |Business date, that is, the specific date when the task is executed. In most cases, the business date is consistent with the partition date. | | | | \ |${partition} |The partition value of the data source in the task | | | | \ |${batchNum} |The task batch number, which is defined by both the business date (taskTime) and execution frequency. For daily granularity, the batch number is always 1. For hourly granularity, 1 to 24 batch numbers are generated sequentially according to the execution order. | * Custom parameters **Note: When adding a custom parameter, please enter this parameter when configuring the dependency.** If the user's data scheduling platform cannot locate a specific instance based on the system fields provided by this product, you can choose to add a custom parameter field, such as defining a task ID. Please enter the specific task ID or name when configuring the dependency so that the dependency interface can locate the target parameter field.
Test button
Note: Click Test. You can only save the API dependency after a successful connectivity test. This test button only tests the interface call and does not check the content. You can enter any content for testing.
To enhance enterprise data security and achieve rigorous and flexible data management, the product supports differentiated configuration for data connection types. For example, project administrators are allowed to use all data connection types, while some data connection types are not available to other users.
Steps:
Meego data connections require unified configuration of plugin credentials. Only after successful verification does the current environment support the Meego data connection type. Before connecting to the Meego data source, please configure it in System Settings.
Steps:
Open Data Connection - System Configuration, click Edit, enter the Plugin ID and Plugin Password, and click Test Connection. After the test is successful, click Save to connect to the Meego data source.
How to obtain the plugin ID and secret
After enabling the Lark office platform in DataWind, the user needs to create and publish a plugin in Meego, then obtain the ID and secret on the plugin information page.
Third-party data connections must be enabled via a unified switch. After enabling, the current environment supports third-party data connection types such as WeChat Official Account, Ocean Engine Qianchuan, and Calendar. If the third-party data connection switch is not enabled in the system settings, users will not be able to detect system support for third-party data connections on any project's new data connection page. (Available starting from self-hosted deployment v2.74.0 and above)
Operation steps: Open Data Connection - System Configuration - Third-Party Data Connections, click "Enable" and save.
In System Management, click the System Configuration button, then select the Queue Configuration module in the left sidebar to manage queues. For a complete introduction, please refer to Queue Configuration.
When creating a new project, the system administrator can allocate specified storage resources to each project according to the settings. In the storage management interface, you can view resource overview information and configure storage policies, including the switch for enabling resource control, project resource limit configuration, and resource over-limit configuration. In addition, you can view and search usage details and more. The total amount of storage resources is generated or changed during deployment or upgrade. To make adjustments, contact system operations and maintenance.
Administrators can set the default upper limit for project resources. Administrators can set unified project resource limits for all projects in Storage Policy - Enable Resource Control, or set limits for a specific project in Usage Details. When project resources exceed the limit, creating new extraction tasks will be prohibited.
System administrators can set the upper limits for data lifecycle and rollback time in Synchronization Configuration to proactively constrain user behavior, reduce resource waste caused by human error, and avoid blocking of operating resources and unnecessary overhead.