Google Cloud SQL for MySQL support

Supported versions:

1st gen, 2nd gen

Supported schema elements and metadata

Dataedo reads following metadata from Google Cloud for MySQL databases.

• Tables
  • Columns
    • Data type with length
    • Nullable
    • Default value
    • Generated column formula
  • Primary keys
    • Columns
  • Unique indexes
    • Column
  • Foreign keys
    • Columns
  • Triggers
    • When triggered
    • Script
• Views
  • Columns (see tables)
  • Script
• Procedures
  • Script
  • Parameters
• Functions
  • Script
  • Parameters
  • Returned value

Comments

Dataedo reads Google Cloud for MySQL comments from following objects:

• Tables
  • Columns
  • Primary keys
  • Unique indexes
• Views
  • Columns
• Procedures
• Functions

Dataedo does not write comments back to Google Cloud for MySQL.

Limitations

Following schema/metadata elements currently are not supported:

• Check constraints (vote)
• Non unique indexes (vote)
• Dependencies - not presented by Google Cloud for MySQL

Connection:

• SSL connection is currently not supported

Learn more

Connect to Google Cloud SQL