How to create external table for data in azure blob storage

Question

I'm trying to create an external table for data in Azure blob, and I have used the flow script

create table [Sales].Currency
(
    [CurrencyCode] [nchar](3) NOT NULL,
    [Name] [nchar](200) NOT NULL,
    [ModifiedDate] [datetime] NOT NULL  
)
with
(
    Location = '/samplefile/',
    data_source=currenytable,
    file_format=uncompressedData,
    reject_type=value,
    reject_value=0
);

when I execute this code I get the following error Parse error at line: 10, column: 13: Incorrect syntax near ''/samplefile/''. how to resolve this one thank you Note: I have successfully created all prior things for creating the external table

Murray Foxcroft · Accepted Answer · 2019-06-26 15:17:47Z

1

It is not as simple as a missing "EXTERNAL" statement.

You have:

create table [Sales].Currency

and it should be:

create EXTERNAL table [Sales].Currency

answered Jun 26, 2019 at 15:17

Murray Foxcroft

13.9k7 gold badges66 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create external table for data in azure blob storage

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related