Facing Issue in Creating External Table in Azure SQL Server

Question

Hi Team,

My Requirement is need to read file from Blob Storage and I need to create that file as External table. But I'm using AZURE SQL Server version of 2012. Here I'm unable to install POLYBASE for creating external table.
I just want to know which version of SQL Server is supported for creating or Installing POLYBASE is required. I have followed the instructions for creating external table like:

CREATE DATABASE SCOPED CREDENTIAL AppCredential WITH IDENTITY = 'username', SECRET = 'access_key';

CREATE EXTERNAL DATA SOURCE external_data_source

WITH

(

TYPE=RDBMS,

LOCATION='*******.database.windows.net', -- insert SQL Database server FQDN

DATABASE_NAME ='*****', -- insert SQL Database name

CREDENTIAL= AppCredential

);

CREATE EXTERNAL FILE FORMAT csv_file_format

WITH

(FORMAT_TYPE = DELIMITEDTEXT ,

FORMAT_OPTIONS (FIELD_TERMINATOR =',')

);

After this error, i'm trying to check whether polybase is installed or not using below query. then i found it is not available. so now i need to know know which SQL version is supported for polybase.

Give me response as soon as possible.

Thanks

Answer 1

Hi Azure Practices,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand you want to know about Creation of External Table in Azure SQL Server and facing issue.

The PolyBase feature provides connectivity to the following external data sources:

• SQL Server 2022 (16.x) does not support Hadoop.
• SQL Server 2016 (13.x) introduced PolyBase with support for connections to Hadoop and Azure Blob Storage.
• SQL Server 2019 (15.x) introduced additional connectors, including SQL Server, Oracle, Teradata, and MongoDB.
• SQL Server 2022 (16.x) introduced the S3-compatible storage connector.
• SQL Server 2019 (15.x) Cumulative update 19 introduced support for Oracle TNS.
• SQL Server 2022 (16.x) Cumulative update 2 introduced support for Oracle TNS.

To use PolyBase in an instance of SQL Server:

1. Install PolyBase on Windows or Install PolyBase on Linux.
2. Starting with SQL Server 2019 (15.x), enable PolyBase in sp_configure, if necessary.
3. Create an external data source.
4. Create an external table.

Reference document link: Introducing data virtualization with PolyBase

PolyBase provides these same functionalities for the following SQL products from Microsoft:

• SQL Server 2016 (13.x) and later versions (Windows)
• SQL Server 2019 (15.x) and later versions (Windows and Linux)
• SQL Server Analytics Platform System (PDW)
• Azure Synapse Analytics (for dedicated SQL pools)
  • Data virtualization in Azure Synapse Analytics is available in two modes, PolyBase and native. For more information, see Use external tables with Synapse SQL.

If the answer did not help, please add more context/follow-up question for it, and we will help you out. Else, if the answer helped, please click Accept answer so that it can help others in the community looking for help on similar topics.

Thank you.