graphql based on sql api deployment hangs on your new data model is being deployed admin ui message

### Before opening, please confirm:

- [X] I have [searched for duplicate or closed issues](https://github.com/aws-amplify/amplify-adminui/issues?q=is%3Aissue+).
- [X] I have read the guide for [submitting bug reports](https://github.com/aws-amplify/amplify-adminui/blob/main/CONTRIBUTING.md#bug-reports).
- [X] I have done my best to include a minimal, self-contained set of instructions for consistently reproducing the issue.

### App Id

dg24riwqqhzih

### Region

eu-north-1

### Environment name

dev

### Amplify CLI Version

6.0.1

### If applicable, what version of Node.js are you using?

v14.16.1

### What operating system are you using?

Mac Big Sur

### Browser type?

Chrome

### Describe the bug

Attempted to deploy a new graphql api against an Aurora (mysql) datasource.
The data source is in eu-west-2 (london)
The App sync app is in eu-north1 (stockholm).

I've created the database and successfully using these instructions:

https://docs.amplify.aws/cli/graphql-transformer/relational/

But Graphql queries are returning nulls and the Data Tab in the Admin UI is displaying "Your new data model is being deployed"

### Expected behavior

I should be able to make graphql mutations and queries to the Aurora SQL database

### Reproduction steps

Basically following these instructions to create amazon Aurora database

https://docs.amplify.aws/cli/graphql-transformer/relational/

After running this command
```
api add-graphql-datasource
```
I did amplify push

The schema and resolvers are generated successfully.

But when I try out the graphql queries and mutations in App Sync they respond with nulls.

When I look at the 'data' panel in the admin I see the message 'Your new data model is being deployed'
It stayed like this from Friday 24th September.

I tried redeploying again, but same result.
I can see in the deployment log "Amplify backend deployment initiated." with "UPDATE_IN_PROGRESS" but this is just hanging.

Looking at cloud formation it is showing a number of tasks still in progress, none of which are completing.

The specific task list is

amplify-tranchedemo-dev-122301-apiamplifymonetapi-1IV2ZH-amplifymonetapitrancherdsjson-1W2RLLUF7YVQ0

Hope you can help, please let me know if you need anymore information
thankyou

### Additional information



Start with the deployment log and the listed CloudFormation task after running api add-graphql-datasource and amplify push. Compare the Aurora datasource region in eu-west-2 with the AppSync app in eu-north-1 and trace why the deployment remains UPDATE_IN_PROGRESS. Done means the data model finishes deploying and GraphQL queries and mutations return the Aurora data.

Written by the indexing model from the issue text.