Is there a way to import a list of the relationships in a MySQL database, and then to load these into the Data Modelling tool? Seems both time consuming and a bit risky (as it increases risk of human error) by having to specify relationship between every table.
If the functionality doesn’t exist could someone look at Lucidchart, they provide an SQL script which can be run on different flavours of SQL, see here https://lucidchart.zendesk.com/hc/en-us/articles/207299756-Entity-Relationship-Diagrams-ERDs-.
Our BigQuery data warehouse hosts a copy of our application MySQL database and BigQuery doesn’t take the table relationships with it unfortunately, so these need to be specified in the Data Modelling area…