convert postgresql to spark sql

Question

convert postgresql to spark sql

Grover, Jyoti 40

Has any one has used or is aware of a tool that can convert postgresql code to Spark SQL code to run in Databricks?

our case: we have to write query in dbeaver to create new logics but want to create new views/tables using Data bricks. We have convert everytime postgresql code to Spark SQL. I am looking for a tool that can help.

Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator

2025-01-13T17:40:47.7533333+00:00

@Grover, Jyoti Thank you for reaching out.

Can you describe the specific types of queries or logic you need to convert from PostgreSQL to Spark SQL?

Are there particular features or functions in PostgreSQL that you frequently use and need to convert?

Regards,

Oury
Oury Ba-MSFT 21,156 Reputation points Microsoft Employee Moderator

2025-01-14T23:21:02.52+00:00

@Grover, Jyoti

Please check the below article and let me know if this is close to your ask.

https://docs.databricks.com/en/connect/external-systems/postgresql.html

Regards,

Oury