MySQL Read Connector (Legacy)

Prerequisites:

  • Access credentials
  • Data location on MySQL

Select MySQL

Click the READ icon for MySQL on the Connectors panel

Custom Code and PIP Install

Use the default code for the MySQL Read Connector or modify as necessary. Specify any PIP packages to be installed.

Test Locally

The ability to test the code locally can be extremely helpful and expedite the connector development process.

561

Parsers & Schema

Data formats currently available are: Avro, Grok, JSON, Parquet and XSV. However, you can create your own parser functions or define a UDP (User Defined Parser) to process a file format.

For custom read connectors (e.g. MySQL) you will need to create the schema with column names and data types as well as specifying default values etc.