Write to MySQL

This guide shows you how to create a MySQL Write Component.

Prerequisites

• MySQL Connection with write permissions
• An Ascend Flow with a Component that contains data

Create a new Write Component

Begin from your workspace Super Graph view. Follow these steps to create your Write Component:

Using the Component Form

1. Double-click the Flow where you want to create your component
2. Right-click on any Component
3. Hover over Create Downstream -> Write, and select your target Connection
4. Complete the form with these details:
   • Select your Flow
   • Enter a descriptive Component Name like write_mysql

Using the Files Panel

1. Open the Files panel in the top left corner
2. Navigate to and select your desired Flow
3. Right-click on the components directory and choose New file
4. Name your file with a descriptive name like write_mysql.yaml and press enter

Configure your MySQL Write Component

Follow these steps to set up your MySQL Write Component:

1. Configure your Connection
   • Enter your MySQL Connection name in the connection field
2. Specify a data source
   • Set input to the Component that contains your source data
3. Define the write target
   • Configure the mysql write connector options
   • Specify your target table name, schema, and other required properties
4. Select a write strategy

   Choose one of these strategies based on your use case:

   Strategy	Description	Best For
   partitioned	Updates only modified partitions	Time-series data, regional datasets, date-partitioned data
   full	Replaces entire target during each Flow Run	Reference tables, complete data refreshes
   snapshot	Flexible output - single file or chunked based on path	Data exports, analytical datasets, flexible output requirements

For complete details on output format options and when to use each approach, see the write output formats guide.

Examples

Full Write

write_full_mysql.yaml

component:
  write:
    connection: write_mysql
    input:
      name: my_component
      flow: my_flow
    strategy:
      full:
        mode: drop_and_recreate
    mysql:
      table:
        name: my_output_table

This configuration:

• References a MySQL connection named write_mysql
• Uses my_component from my_flow as the input data
• Applies a full write strategy with drop_and_recreate mode
• Writes to a MySQL table named my_output_table

Incremental Write

write_incremental_mysql.yaml

component:
  write:
    connection: write_mysql
    input:
      name: my_component
      flow: my_flow
    strategy:
      incremental_column: timestamp
      incremental:
        merge:
          deletion_column: timestamp
          unique_key: id
    mysql:
      table:
        name: my_output_table

This configuration:

• References a MySQL connection named write_mysql
• Uses my_component from my_flow as the input data
• Applies an incremental write strategy using the timestamp column
• Uses merge mode with id as the unique key and timestamp as the deletion column
• Writes to a MySQL table named my_output_table

🎉 Congratulations! You successfully created a MySQL Write Component in Ascend.