Accelerate big data analytics with the Spark 3.0 connector for SQL Server—now generally available

%3CLINGO-SUB%20id%3D%22lingo-sub-2562230%22%20slang%3D%22en-US%22%3EAccelerate%20big%20data%20analytics%20with%20the%20Spark%203.0%20connector%20for%20SQL%20Server%E2%80%94now%20generally%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2562230%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3EWritten%20by%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Daniel%20Coelho's%20blog%20archive%22%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Fauthor%2Fdacoelho%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDaniel%20Coelho%3C%2FA%3E%2C%20Senior%20Program%20Manager%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EThis%20blog%20post%20has%20been%20co-authored%20by%20Bhanu%20Prakash%2C%20Principal%20Program%20Manager%2C%20Azure%20Databricks.%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20are%20now%20announcing%20the%20general%20availability%20of%20the%20Apache%20Spark%203.0%20compatible%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22SQL-Spark%20connector%20%7C%20GitHub%22%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fsql-spark-connector%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EApache%20Spark%20Connector%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efor%20SQL%20Server%20and%20Azure%20SQL%2C%20accessible%20through%20Maven.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Spark%203.0%20compatible%20connector%20went%20into%20preview%20early%20this%20year.%20Since%20then%2C%20we%20have%20seen%20tremendous%20customer%20adoption%20and%20received%20helpful%20customer%20feedback.%20Over%20the%20last%20few%20months%2C%20after%20incorporating%20enhancements%20and%20bug%20fixes%20to%20the%20connector%2C%20we%20are%20now%20excited%20about%20the%20general%20availability%20of%20this%20connector%20so%20that%20customers%20can%20expand%20their%20usage%20for%20even%20more%20workloads.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22%22%3EThe%20Apache%20Spark%20Connector%20for%20SQL%20Server%20is%20a%20high-performance%20connector%20that%20enables%20users%20to%20use%20transactional%20data%20in%20big%20data%20analytics%20and%20persist%20results%20for%20ad-hoc%20queries%20or%20reporting.%20It%20allows%20you%20to%20use%20SQL%20Server%20or%20Azure%20SQL%20as%20input%20data%20sources%20or%20output%20data%20sinks%20for%20Spark%20jobs.%20It%20provides%20bulk%20insert%20data%20into%20the%20database%20and%20can%20outperform%20row-by-row%20insertion%20with%2010%20to%2020%20times%20faster%20performance%2C%20as%20compared%20to%20just%20using%20Java%20Database%20Connectivity%20(JDBC).%20In%20addition%2C%20customers%20can%20use%20this%20connector%20to%20score%20machine%20learning%20models%20from%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22Run%20Python%20and%20R%20scripts%20with%20Machine%20Learning%20Services%20on%20SQL%20Server%20Big%20Data%20Clusters%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fbig-data-cluster%2Fmachine-learning-services%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Server%20Machine%20Learning%20Service%3C%2FA%3Es%2C%20or%20score%20results%20in%20SQL%20after%20doing%20machine%20learning%20in%20Spark.%3C%2FP%3E%0A%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22%22%3E%3CA%20title%3D%22Accelerate%20big%20data%20analytics%20with%20the%20Spark%203.0%20connector%20for%20SQL%20Server%E2%80%94now%20generally%20available%22%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Faccelerate-big-data-analytics-with-the-spark-30-connector-for-sql-server-now-generally-available%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSTRONG%3ERead%20the%20full%20article%3C%2FSTRONG%3E%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Written by Daniel Coelho, Senior Program Manager

 

This blog post has been co-authored by Bhanu Prakash, Principal Program Manager, Azure Databricks.

 

We are now announcing the general availability of the Apache Spark 3.0 compatible Apache Spark Connector for SQL Server and Azure SQL, accessible through Maven.

 

The Spark 3.0 compatible connector went into preview early this year. Since then, we have seen tremendous customer adoption and received helpful customer feedback. Over the last few months, after incorporating enhancements and bug fixes to the connector, we are now excited about the general availability of this connector so that customers can expand their usage for even more workloads.

 

The Apache Spark Connector for SQL Server is a high-performance connector that enables users to use transactional data in big data analytics and persist results for ad-hoc queries or reporting. It allows you to use SQL Server or Azure SQL as input data sources or output data sinks for Spark jobs. It provides bulk insert data into the database and can outperform row-by-row insertion with 10 to 20 times faster performance, as compared to just using Java Database Connectivity (JDBC). In addition, customers can use this connector to score machine learning models from SQL Server Machine Learning Services, or score results in SQL after doing machine learning in Spark.

 

Read the full article

0 Replies