Aurora MySQL as Target

Fivetran Local Data Processing supports integrating changes into Aurora MySQL database. This section describes the configuration requirements for integrating changes (using and ) into Aurora MySQL location. For the list of supported Aurora MySQL versions, into which Local Data Processing can integrate changes, see in .

By default, Local Data Processing writes data into Aurora MySQL using and .

You can also use and for writing data into Aurora MySQL. However, it is required to create staging files on a temporary location to perform and . For more information about staging, see section .

Grants for Integrate and Refresh into Aurora MySQL

To integrate changes into an Aurora MySQL database, the database User requires the following grants:

• Permission to read and change replicated tables.

  grant select, insert, update, delete on tbl to username;
  content_copy

• Permission to create and drop Local Data Processing state tables.