How to use external Databases in the server.properties to persist metadata

unitycatalog / unitycatalog

Open, Multi-modal Catalog for Data & AI

https://unitycatalog.io/

Apache License 2.0

1.96k stars 279 forks source link

How to use external Databases in the server.properties to persist metadata #16

Open wahahawasabi opened 1 month ago

wahahawasabi commented 1 month ago

within etc/conf/server.properties file, we can define if we want to set it to dev or test or false to persist the table metadata. Is it possible to use an external database like postgres or my own instance of h2db instead?

HuyNguyen7994 commented 1 month ago

https://github.com/unitycatalog/unitycatalog/blob/af5c34244b513a7a34001da3c9297e3892204f9b/server/src/main/java/io/unitycatalog/server/persist/HibernateUtil.java#L39C1-L43C14

it seems currently only hard-coded h2db is supported

tdas commented 4 weeks ago

Yes, right now its hardcoded to h2 but it would be awesome to define interfaces such that any database can be plugged in.