Databricks Community

thecodecache · 05-08-2024

Input SQL Script (assume any dialect) : SELECT b.se10, b.se3, b.se_aggrtr_indctr, b.key_swipe_ind FROM (SELECT se10, se3, se_aggrtr_indctr, ROW_NUMBER() OVER (PARTITION BY SE10 ...

thecodecache · 05-21-2024

Hi @Kaniz_Fatma, Thanks for your response. I'm looking for a utility or an automated way of translating any generic SQL into PySpark DataFrame code.So, the translate function should look like below:def translate(input_sql): # translate/convert it ...

Databricks Community

User Stats

User Activity

Transpile a SQL Script into PySpark DataFrame API equivalent code

Re: Transpile a SQL Script into PySpark DataFrame API equivalent code