Error when migrating documents with relationships

When migrating from one self-hosted instance (v1.6.0) to another I receive the below error when creating documents containing 1 or more relationship attribute(s).

"Error occurred while pushing 'databases:<doc id>' to destination with message: 'The current user is not authorized to perform the requested action.'"

There are no other errors in the migration, and documents in collections where there are no relationship attributes are created successfully.

For testing purposes both the API key used in the migration have all scopes granted, and the collections have full permissions granted to the "Any" role.

Question: What permission is required, or where can I look to see what permission is required? ...Assuming this is the root cause. Any other thoughts, suggestions or experiences would be greatly appreciated.

Setup: I have appwrite setup using docker compose migrating from a cloud hosted instance with public address to a local instance.