External Tables : Incorrect syntax near ‘CREDENTIAL’

I was trying to work through External Table in SQL Server 2016 and was configuring the prerequisites , this is when i got stuck with error while creating EXTERNAL DATA SOURCE

CREATE EXTERNAL DATA SOURCE sql2016ds 
WITH
(
  TYPE = HADOOP,
  LOCATION = 'wasbs://containername@account.blob.core.windows.net/',
  CREDENTIAL  = cred_azstorage);
GO

Error

Msg 102, Level 15, State 1, Line 31
Incorrect syntax near 'CREDENTIAL'.

I searched a lot in msdn , but as the error is so ambiguous that it never strike my mind that it could be due to missing PolyBase Query Service

For those who have not heard or worked with PolyBase, it is not a totally new feature as it has existed on the PDW…err APS appliance for sometime now. So what is it? In short, PolyBase allows you to use your vast array of T-SQL skill to  query, join and manipulate unstructured or semi-structure data stored either in HDFS (HADOOP) or Azure Blob Storage directly from the SQL Server relational environment.

So, what i have to do to get over the error

You need to add [PolyBase Query Service for External Data] feature to your 2016 SQL Server Instance.Once feature is successfully installed recycle the sql server services.

ET_1

Leave a Reply

Your email address will not be published. Required fields are marked *