Team,
Initially our team created the databases with the environment name appended. Ex: cust_dev, cust_qa, cust_prod.
I am looking to standardize the database name as consistent name across environments. I want to rename to "cust".
All of my tables are external tables in this database pointing to a storage in ADLS. which option will help?
1. Does databricks supports rename command ?
2. Create a new database CUST and recreate all the tables in new database . Steps to be followed
a. create database cust
b. drop table <table1> from cust_dev
c. create table cust.<table1>
What is recommended option?
#deltatable