More background on the issue:
awsdatacatalog
- db1
- db2
-- hive table
-- hudi table
-- iceberg table
and
CREATE EXTERNAL CATALOG `ft_datalake_no_cache`
PROPERTIES ("aws.glue.use_aws_sdk_default_behavior" = "true",
"hive.metastore.type" = "glue",
"enable_remote_file_cache" = "false",
"aws.s3.region" = "us-west-2",
"aws.glue.region" = "us-west-2",
"type" = "hive",
"aws.s3.use_aws_sdk_default_behavior" = "true",
"enable_metastore_cache" = "false"
)