Get region from within SQL Server RDS instance.

• Can I query the region from within the SQL Server itself?

Anything like rdsadmin.dbo.rds_show_configuration that include instance specs?

I have an SP that is clearing all backup tables from production to a secondary DB.

I want to back it up to S3 and drop those tables.

I have the backup command ready:

declare @BackupCMD varchar(4000) = concat('exec msdb.dbo.rds_backup_database @source_db_name=''', 'BackupTables', ''', @s3_arn_to_backup_to=''arn:aws:s3:::', @bucket, '/', @file_name, '.bak''
	, @kms_master_key_arn=''', @arn, '''')

The issue is we have instances over several regions and bucket and key need to match the same region as the instance.

If I can I will be able to cross it with the ARN / buckets list that need to match.

Thank you!