topic Re: OracleDB shared Cluster / DBFS on Unity Catalog Cluster in Data Governance

OracleDB shared Cluster / DBFS on Unity Catalog Cluster

BananaHotSauce — Thu, 26 Jan 2023 10:15:23 GMT

Hello,

im trying to use oracledb on my cluster and having issues using it.

An init script on the cluster fixed this issue.

Now, im trying to create a shared cluster with unity catalog and have oracledb in it.

I encountered issues having this.

- Init scripts are not available on shared clusters.

My initial solution to this is to run the init script from the DBFS on my notebook.

Im not able to access the file from the dbfs.

Any idea how should i do it or what am i doing wrong?

Re: OracleDB shared Cluster / DBFS on Unity Catalog Cluster

Hubert-Dudek — Thu, 26 Jan 2023 13:00:49 GMT

The shared cluster (User isolation) on Unity Catalog doesn't have this functionality.

Re: OracleDB shared Cluster / DBFS on Unity Catalog Cluster

BananaHotSauce — Fri, 27 Jan 2023 04:42:46 GMT

Thanks for this. I figured i would just put the init config file on the global init. Just tested now and it seems global init scripts do not run on shared UC Cluster? Is this another limitation of databricks?

Are there other ways to make oracledb work on an UC enabled Shared Cluster?

Re: OracleDB shared Cluster / DBFS on Unity Catalog Cluster

Anonymous — Sat, 28 Jan 2023 14:20:07 GMT

@Chris Joshua Manuel The support for init script, library installation, Machine Learning, UDF on shared cluster is in preview. Please submit this form to onboard your workspace for improved shared clusters preview.

https://docs.google.com/forms/d/e/1FAIpQLSfk6aJtTr1aGcVRuO0nusrzGpeK6VrVywhmzII7gSf56CtJ2w/viewform