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.
Connect with Databricks Users in Your Area
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.