...
Ensure that you have the following roles in IAM for the service account,
service-<project-number>@gcp-sa-datafusion.iam.gserviceaccount.com:Cloud SQL Admin
Cloud Data Fusion Admin
Cloud Data Fusion API Service Agent
Create a CloudSQL (MySQL) instance, test database, and user.
In the Google Cloud Console, navigate to APIs and Services.
Click Enable APIS and Services.
Search for Cloud SQL Admin API.
Choose the Cloud SQL Admin API. Click Enable.
If you are connecting to a Private Cloud SQL instance, please follow additional steps at Connect to private cloudsql-mysql instance from private Cloud Data Fusion instance to set up a proxy VM to establish the connection.
Instructions
Obtain the JDBC Driver JAR file by downloading the pre-built jar-with-driver-and-dependencies from the releases page.
Alternatively, you can build it using:
Code Block mvn -P jar-with-driver-and-dependencies clean package -DskipTests
to build the JAR instead of the command in README from the above git repo.
Go to Cloud Data Fusion Wrangler.
...
| Tip |
|---|
Once you’ve completed all the steps you will be able to click on the newly defined database connection and see the list of tables for that database. |
Building the MySQL Socket Factory Driver
...
. |
Accessing CloudSQL in pipelines
...