DataBricks Adapter
Has anyone looked at creating a DataBricks adapter?
The project I am working on has been advised that it should be moved from the current MySQL RDS to DataBricks. I love using Prisma to control the models (currently around ~140) and queries that we do.
I was hoping someone might have already attempted to write an adapter, if not I was going to attempt it myself using https://www.npmjs.com/package/@prisma/adapter-libsql as a basis, or if there is some better documentation to follow.
My guess is I would need to wrap https://www.npmjs.com/package/@databricks/sql, as an adapter.
Many thanks!
6 Replies
You decided to hold for human wisdom. We'll chime in soon! Meanwhile,
#ask-ai is there if you need a quick second opinion.Hi,
We have a Neon adapter (as Databricks acquired Neon) but it seems that you are referring to some other adapter. Currently, we don't have a dedicated Databricks adapter.
So the plan is to have a container which has our node ELT script in, using Prisma, to write into the database of Databricks. Via the exposed environment vars.
I will look at creating an adapter. Thank you for getting back to me
Sounds good! Thanks for taking the efforts in creating an adapter. It will be helpful to others as well 👍
Hi @Adrian, did you make any headway on this adapter? We'll be looking to do the same as new project is using Databricks rather than our usual postgres servers.
Hi @BK didn't get very far I'm afraid. the project was put on hold
Might be getting back to it soon. Will update if I do