Azure Synapse development (code writing) - IDE or notebooks?

Hello @Michael Urinovsky ,

Thanks for the question and using MS Q&A platform.

As per my experience Azure Synapse Notebooks experience is better compared to the IDE. And this perspective can be varied from one user to other.

Azure Synapse Notebook:

A Synapse notebook is a web interface for you to create files that contain live code, visualizations, and narrative text. Notebooks are a good place to validate ideas and use quick experiments to get insights from your data. Notebooks are also widely used in data preparation, data visualization, machine learning, and other Big Data scenarios.

With a Synapse notebook, you can:

• Get started with zero setup effort.
• Keep data secure with built-in enterprise security features.
• Analyze data across raw formats (CSV, txt, JSON, etc.), processed file formats (parquet, Delta Lake, ORC, etc.), and SQL tabular data files against Spark and SQL.
• Be productive with enhanced authoring capabilities and built-in data visualization.

IDE - IntelliJ or VSCode:

You can use the Azure Toolkit for IntelliJ plug-in to develop Apache Spark applications, which are written in Scala, and then submit them to a serverless Apache Spark pool directly from the IntelliJ integrated development environment (IDE). You can use the plug-in in a few ways:

• Develop and submit a Scala Spark application on a Spark pool.
• Access your Spark pools resources.
• Develop and run a Scala Spark application locally.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators