Redshift Stored Procedure Migration to Databricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi,
I want to migrate Redshift SQL Stored Procedures to databricks.
As databricks doesn't support the concept of SQL Stored Procedures.
How can I do so?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
You can create a Python function or move logic a notebook, it depend what is the purpose of the procedure.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
i have a bunch of procedures to convert. so it is not possible to generalise the purpose of each procedure.
I need a wrapper program to convert redshift sql procedures into python functions in databricks notebooks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
I am assuming you want a sproc so you have some code which is reusable across many notebooks. If so, Databricks supports several types of functions: https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-functions
However if your Redshift sprocs are all of the processing logic, you should convert those to notebooks instead.
I don't know of any program which will directly convert Redshift SQL to Python (or Databricks SQL). An LLM might help, perhaps even the Databricks Assistant in the cloud IDE.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago - last edited 3 weeks ago
You can try with ChatGPT, ask the chat to convert it, you will be really suppressed. There is more advance option for that, but it's more complex.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 weeks ago
Hey @Avinash_Narala in case you didn't see this announcement, looks like it might solver your problem: Welcoming BladeBridge to Databricks: Accelerating Data Warehouse Migrations to Lakehouse | Databrick...
I had no idea BladeBridge existed, so I'm pleased to see it's part of the Databricks offerings soon. Some problems solve themselves.
![](/skins/images/B38AF44D4BD6CE643D2A527BE673CCF6/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/B38AF44D4BD6CE643D2A527BE673CCF6/responsive_peak/images/icon_anonymous_message.png)