Why database/table names are in lower case ?

[wyzer]

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.

[Kaniz_Fatma · Accepted solution]

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

[wyzer]

Hello,

Ok, too bad.

Thank you.

[Hubert-Dudek]

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.