Rename an Unlimited Storage Database

-- create db
CREATE DATABASE bottomless_db ON S3 "mydata/bottomless_db/"
CONFIG '{"region": "us-east-1"}'
CREDENTIALS '{"aws_access_key_id": "",
   "aws_secret_access_key": "",
   "aws_session_token": ""}';

-- detach db
DETACH DATABASE bottomless_db;

-- attach db using a new db name 
ATTACH DATABASE bottomless_db2 ON S3 "mydata/bottomless_db/"
CONFIG '{"region": "us-east-1"}'
CREDENTIALS '{"aws_access_key_id": "",
   "aws_secret_access_key": "",
   "aws_session_token": ""}';

USE bottomless_db2;