Deploying Synapse SQL Serverless objects across environments using SSDT
The long-awaited feature for all Synapse CICD fans is here! SqlPackage now supports serverless SQL pools in Extract and Publish operations. In this article, I will demonstrate how you can run this utility in a DevOps pipeline to replicate your SQL serverless objects across different environments.Azure Synapse Runtime for Apache Spark 3.3 is now in Public Preview
We are excited to announce the preview availability of Apache Spark™ 3.3 on Synapse Analytics. The essential changes include features which come from upgrading Apache Spark to version 3.3.1 and upgrading Delta Lake to version 2.1.0.New informative Livy errors codes for Apache Spark in Azure Synapse Analytics!
Introducing a new and more precise list of Livy error codes for Apache Spark to replace the previous generic ones. When a job fails on Azure Synapse Analytics, the error handling feature parses and checks the logs on the backend to identify the root cause and displays it on the monitoring pane along with the steps to take to resolve the issue.Automating the Publishing of Workspace Artifacts in Synapse CICD
New features have been recently introduced in Synapse Workspace Deployment task V2 to facilitate CICD automation in Synapse. These features will give users the ability to do one touch deployments. Before introducing these features, users had to manually hit the “Publish” button from the Synapse Studio, to persist their changes in Synapse Service (Live Mode) and generate the ARM templates for deployment in the publish branch. This was a showstopper for a fully automated CICD lifecycle. With the introduction of these new features, users will no longer require the manual intervention from the UI, thus allowing a fully automated CICD in Synapse. Adding to this, these features to validate as well as generate the ARM templates for deployment using any user branch.
Join us for our first Azure Synapse Influencers Ask the Experts session
I’m pleased to share that registration is now open for our first-ever Azure Synapse Influencers event on June 29, 2022 (10AM to 11AM Pacific Time). This Ask the Experts session will feature Principal Program Managers Mark Kromer and Sunil Sabat, who will answer your questions on all things Data Integration in Azure Synapse, covering Azure Data Factory, Azure Synapse Pipelines, Azure Synapse Link, and SSIS. Event attendees are encouraged to ask questions during the event or submit questions in advance at signup.Announcing the Public Preview of Azure Synapse Link for SQL
Data-driven, quality insights are increasingly critical for companies to stay competitive, and the speed to achieve those insights can make all the difference. The costly and time-consuming nature of traditional ETL and ELT pipelines are no longer enough. At Microsoft Build 2022, we’re announcing the public preview availability of Azure Synapse Link for SQL, for both SQL Server 2022 and Azure SQL Database.
