Can one Crawler generate multiple metatables?

Hi,

If you use AWS Lake Formation, it supports accessing Glue Data Catalog databases and tables across Regions, pls check this feature release

Also, if you are looking for an implementation example, you can check this blog Configure cross-Region table access with the AWS Glue Catalog and AWS Lake Formation

I think, this could work well for your use-case.

If you don't use Lake Formation, you can define multiple S3 paths as data sources, this can be cross region s3 buckets. Remember to check this parameter, so that it creates separate schema for each path

Hope this is helpful.

Thanks, Rama