通过ADLS在Azure SQL数据库上创建外部表 [英] Create External Table on Azure SQL DATABASE from ADLS

问题描述

大家好，

我已经在ADLS(Azure Data Lake Store)文件存储服务中加载了一些csv文件.

我正在尝试通过ADLS上托管的CSV数据在Azure SQL数据库上创建一个外部表(NO AZURE SQL WAREHOUSE)，但是我找不到任何可以帮助我完成此类事情的语法.

请帮助我提供一些链接或步骤，以指导我进行此实现.

我尝试使用以下语法，但看起来它仅适用于Azure SQL Warehouse:

解决方案

Azure SQL DB当前不支持PolyBase(存储数据的外部表). />

Hi All,

I have loaded some csv files on ADLS (Azure Data Lake Store) File Storage Service.

I am trying to create an external table on Azure SQL DATABASE (NOT AZURE SQL WAREHOUSE) over this CSV data hosted on ADLS, but i am not able to find any syntax that can help me do such a thing.

Can you please help me with the link or steps that can guide me to do this implementation.

I tried using the following syntax, but looks like it only works on Azure SQL Warehouse:

-- PolyBase only: Azure Data Lake Store -- (on Azure SQL Data Warehouse) CREATE EXTERNAL DATA SOURCE AzureDataLakeStore WITH ( TYPE = HADOOP, LOCATION = 'adl://<AzureDataLake account_name>.azuredatalake.net', CREDENTIAL = AzureStorageCredential );

解决方案

Azure SQL DB does not currently support PolyBase (external table over storage data). 

这篇关于通过ADLS在Azure SQL数据库上创建外部表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！