Stream into Google Cloud SQL for MySQL with your free account

The Google Cloud SQL for MySQL materialization connector in Estuary delivers data from Estuary collections into MySQL tables hosted on Google Cloud SQL. It supports continuous materialization from real-time or batch pipelines, using standard merge-based updates by default with optional delta updates for applicable workloads.

• Supports MySQL 5.7 and later
• Standard merge-based updates by default to keep destination rows synchronized
• Optional delta updates for workloads where changes should be applied incrementally
• Automatic table creation for configured materialization bindings
• Custom SQL after table creation for additional table configuration
• Direct Google Cloud SQL connectivity or SSH tunneling
• Configurable SSL modes, including certificate and hostname verification
• Configurable timezone handling using IANA timezone names or UTC offsets
• Automatic conversion of date-time fields to UTC when materialized
• Automatic quoting of MySQL reserved words when used as field names

The database user must have permission to create tables, and MySQL’s local_infile global variable must be enabled. For direct connections, enable a public IP on the Cloud SQL instance and authorize Estuary’s IP addresses; alternatively, an SSH tunnel can be used for private connectivity.