How to create table name uppercase in unity catalog

Question

We are trying to create a unity catalog tables on top of azure ADLS location for delta format. if we create table, the normally structure of tables look like always lower case, so that its impacting while connect SAS reports tools. we would have to make it all the tables while create unity catalog needs to be UPPERCASE. kindly suggest.

create table testcatalogname.test.tabl_ename
using delta
location "/test/delta/tablename/"

Answer 1

I have tried the syntax below:

CREATE TABLE spark_catalog.default.DEPARTMENT
(
  deptcode  INT,
  deptname  STRING,
  location  STRING
);

In the example above, I created a TABLE with the table name in UPPERCASE.

Results:

Learn more about Create tables in Unity Catalog.