Can I Store Data From Multiple Connectors in a Single AWS Glue Database?link
Questionlink
Can I store data from multiple connectors in a single AWS Glue database?
Environmentlink
Destination: S3 Data Lake
Answerlink
We don't recommend storing data from multiple connectors in a single AWS Glue database.
Suppose you use the same AWS account ID to create multiple groups with different role Amazon Resource Names (ARNs) and S3 buckets in the same region. In this scenario, all groups share the same AWS Glue database.
If each group attempts to create a connector in Fivetran with the same name and table configuration, only the first group to do so will succeed. Each subsequent group will fail because it will attempt to sync to the same bucket as the first group using different role ARNs. Therefore, you should avoid creating multiple connectors with the same name and table configuration, as it may result in conflicts or sync failures.
To avoid critical issues, create multiple connectors that use the same schema name but sync different tables.