You can start with the Delta Lake Cheatsheet, but in the ear of LLMs, you just go to chatgpt and ask it to translate the SQL server code to Spark SQL, you can also use Databricks assistant to help you translate the code.
What AMR said. It's the difference between T SQL and Spark/ANSI SQL. There's a wide variety of small, syntax differences, but if you drop your code in an LLM and ask it to convert, you should get what you need.
Join Us as a Local Community Builder!
Passionate about hosting events and connecting people? Help us grow a vibrant local communityโsign up today to get started!