topic Re: Why database/table names are in lower case ? in Data Engineering

Why database/table names are in lower case ?

wyzer — Tue, 18 Jan 2022 12:58:40 GMT

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.

Re: Why database/table names are in lower case ?

wyzer — Tue, 18 Jan 2022 16:07:09 GMT

Hello,

Ok, too bad.

Thank you.

Re: Why database/table names are in lower case ?

Hubert-Dudek — Tue, 18 Jan 2022 20:45:34 GMT

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.