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 II

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Kaniz_Fatma
Community Manager
Community Manager

Hi @Salah K.​ , A table name can contain only lowercase alphanumeric characters and underscores and must start with a lowercase letter or underscore.

Source - https://docs.databricks.com/data/tables.html

View solution in original post

3 REPLIES 3

Kaniz_Fatma
Community Manager
Community Manager

Hi @Salah K.​ , A table name can contain only lowercase alphanumeric characters and underscores and must start with a lowercase letter or underscore.

Source - https://docs.databricks.com/data/tables.html

Hello,

Ok, too bad.

Thank you.

Hubert-Dudek
Esteemed Contributor III

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.