cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Why database/table names are in lower case ?

wyzer
Contributor III

Hello,

When I run this code :

CREATE DATABASE BackOffice

I see the database like this :

backoffice

Why everything is in lower case ?

Is it possible to configure Databricks in order to keep the real name ?

Thanks.

3 REPLIES 3

Hello,

Ok, too bad.

Thank you.

Hubert-Dudek
Databricks MVP

It is managed by hive metastore as you can put it in different databases is saver this way as some database are Case Sensitive and some not (you can easily test it with standard WHERE syntax).

Probably you could change it with some hive settings but it will generate more problems than benefits.


My blog: https://databrickster.medium.com/

DB1To3
Valued Contributor

Is there any plan to allow UC objects to be named with character case of our own choosing?  It would be unfortunate if this implementation decision became permanent.  The naming rules of tables shouldn't be altogether different than the naming rules of columns.  

In many cases the column name is used as the table name  Eg. Column named "MyCoolCustomerId", should refer to a table named "MyCoolCustomer" (rather than some altogether different table name like "my_cool_customer").