DataGrip is compatible with AnalyticDB for MySQL. This page covers the test environment used for verification and the database operations confirmed to work with DataGrip.
Test environment
| Component | Version |
|---|---|
| MySQL JDBC driver | mysql-connector-java-8.0.15 |
| DataGrip | Download DataGrip |
Verified operations
The following operations were tested and confirmed to work with AnalyticDB for MySQL in DataGrip.
Test connectivity
List databases
To display all schemas, select All schemas in the connection configuration.
Create a table
List all tables
Query the schema of a table
Write data to a table
Query data from a table
Create a view
Query data from a view
