OracleDB shared Cluster / DBFS on Unity Catalog Cluster

BananaHotSauce
New Contributor III

‎01-26-2023 02:15 AM

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?

Hubert-Dudek
Databricks MVP

‎01-26-2023 05:00 AM

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


My blog: https://databrickster.medium.com/
Preview file
224 KB

BananaHotSauce
New Contributor III
In response to Hubert-Dudek

‎01-26-2023 08:42 PM

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?

​

0 Kudos

Anonymous
Not applicable

‎01-28-2023 06:20 AM

@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

0 Kudos