Skip to main content
Version: 0.0.39

MySQL

Integrating MySQL with Lakehousecat enables seamless data management and analytics with your MySQL databases. This guide outlines the steps needed to set up a MySQL connection within the Lakehousecat workspace.

Prerequisites​

Ensure you have the following before starting the integration process:

  • Access to Lakehousecat as an admin or builder
  • Valid MySQL database connection credentials

Step-by-Step Guide​

  1. Start in the Workspace

    • Begin by navigating to your Lakehousecat workspace, where your data connections are managed.

  2. Go to the Data Section

    • Click on the 'Data' menu to explore data-related options available in Lakehousecat.

  3. Select "Datasource Types"

    • Choose the "Datasource Types" option to view the range of data sources you can connect to.

  4. Choose "MySQL Datasource Type"

    • Select the "MySQL Datasource Type" to start the configuration process for connecting your MySQL database.

Step 3: Configure the MySQL Connection​

  • Connection Name: Enter a concise and descriptive name for your MySQL connection. This will help in the identification of the connection throughout the Lakehousecat platform.
  • MySQL Connection-Uri: Provide the MySQL connection URI in the proper format. Ensure the accuracy of this URI for successful connectivity.
  • Description (Optional): Optionally, add a description to offer additional context about the purpose or scope of this connection.

Step 4: Validate and Create the Connection​

  1. After entering all required data, click on the Create button.
  2. Lakehousecat will proceed to validate the connection details. Correct and complete information is crucial to prevent validation errors.
  3. Upon successful validation, your MySQL connection will be established and ready to use.

Best Practices​

  • Naming Conventions: Adhere to consistent naming conventions for connection names to promote easier recognition and management.
  • Description Usage: Leverage the description field to provide meaningful insights into the connection's intended application, especially when multiple connections are configured.

Troubleshooting​

If you face any challenges setting up the connection:

  • Validation Errors: Confirm the MySQL Connection-Uri is correct and properly formatted.
  • Access Issues: Verify your permissions in both Lakehousecat and the MySQL database environment.