Quickstart: Get started with Azure Synapse Analytics

Open your web browser and go to the Azure portal.

In the search bar at the top, type "Azure Synapse Analytics" and select it from the search results.

Click on "Create" or "+ Add" to begin creating a new Synapse workspace. Fill in the required fields:

• Subscription: Select your Azure subscription.
• Resource group: Create a new one or select an existing one.
• Workspace name: Enter a unique name for your workspace (e.g., my-synapse-workspace).
• Region: Choose the Azure region closest to you.
• Data Lake Storage Gen2: You'll need to select or create a hierarchical namespace enabled storage account. This will be used as the primary storage for your workspace.

Configure other settings as needed (Networking, Security, Tags) and click "Review + create", then "Create".

Once your workspace is deployed, navigate to it in the Azure portal. On the workspace overview page, click the "Open Synapse Studio" button.

Synapse Studio is your unified environment for managing all aspects of Azure Synapse Analytics. You'll see several sections:

• Develop: Create SQL scripts, Spark notebooks, and data integration pipelines.
• Data: Explore and manage your data, including linked services and datasets.
• Integrate: Build and manage data pipelines for ETL/ELT processes.
• Monitor: Track pipeline runs, Spark job executions, and SQL requests.
• Manage: Manage workspace settings, Spark pools, SQL pools, and security.

In Synapse Studio, navigate to the Develop hub. Click the "+" button and select "SQL script".

In the SQL editor, you can write T-SQL queries. For example, to get the current server version:

SELECT @@VERSION;

Click the "Run" button to execute the script. The results will appear below the editor.

In Synapse Studio, go to the Manage hub.

Under "Analytics pools," select "Apache Spark pools." Click "+ New" to create a new Spark pool. Configure the settings like node size, number of nodes, and Spark version. Click "Review + create" and then "Create".

Once the Spark pool is provisioned, go back to the Develop hub. Click the "+" button and select "Notebook." Attach your notebook to the newly created Spark pool.

You can write code in various languages like PySpark, Scala, or .NET for Spark. Here's a simple PySpark example:

print("Hello, Synapse Spark!")

data = [("Alice", 1), ("Bob", 2)]
columns = ["name", "id"]
df = spark.createDataFrame(data, columns)
df.show()
                

Click the "Run all" button to execute the notebook cells.