Sink Options Placeholders

Introduction

The SeaTunnel provides a sink options placeholders feature that allows you to get upstream table metadata through placeholders.

This functionality is essential when you need to dynamically get upstream table metadata (such as multi-table writes).

This document will guide you through the usage of these placeholders and how to leverage them effectively.

Support Those Engines

SeaTunnel Zeta
Flink
Spark

Placeholder

The placeholders are mainly controlled by the following expressions:

• ${database_name}
  • Used to get the database in the upstream catalog table
  • Default values can also be specified via expressions：${database_name:default_my_db}
• ${schema_name}
  • Used to get the schema in the upstream catalog table
  • Default values can also be specified via expressions：${schema_name:default_my_schema}
• ${table_name}
  • Used to get the table in the upstream catalog table
  • Default values can also be specified via expressions：${table_name:default_my_table}
• ${schema_full_name}
  • Used to get the schema full path(database & schema) in the upstream catalog table
• ${table_full_name}
  • Used to get the table full path(database & schema & table) in the upstream catalog table
• ${primary_key}
  • Used to get the table primary-key fields in the upstream catalog table
• ${unique_key}
  • Used to get the table unique-key fields in the upstream catalog table
• ${field_names}
  • Used to get the table field keys in the upstream catalog table
• ${comment}
  • Used to get the table comment in the upstream catalog table

Configuration

Requires:

• Make sure the sink connector you are using has implemented TableSinkFactory API

Example 1

env {
  // ignore...
}
source {
  MySQL-CDC {
    // ignore...
  }
}

transform {
  // ignore...
}

sink {
  jdbc {
    url = "jdbc:mysql://localhost:3306"
    driver = "com.mysql.cj.jdbc.Driver"
    user = "root"
    password = "123456"

    database = "${database_name}_test"
    table = "${table_name}_test"
    primary_keys = ["${primary_key}"]
  }
}

Example 2

env {
  // ignore...
}
source {
  Oracle-CDC {
    // ignore...
  }
}

transform {
  // ignore...
}

sink {
  jdbc {
    url = "jdbc:mysql://localhost:3306"
    driver = "com.mysql.cj.jdbc.Driver"
    user = "root"
    password = "123456"

    database = "${schema_name}_test"
    table = "${table_name}_test"
    primary_keys = ["${primary_key}"]
  }
}

We will complete the placeholder replacement before the connector is started, ensuring that the sink options is ready before use. If the variable is not replaced, it may be that the upstream table metadata is missing this option, for example:

• mysql source not contain ${schema_name}
• oracle source not contain ${databse_name}
• ...