是否可以连接到Azure存储并获取CSV文件并将其放入Azure SQL数据仓库中? [英] Is it possible to connect to Azure Storage and get CSV file and put it into Azure SQL data warehouse?
问题描述
将任何CSV上载到Azure SQL数据仓库实际上是很麻烦的,因为它不支持直接上载CSV或具有多个值的INSERT INTO命令.我在想的一种方法是使用Azure数据工厂连接到Azure文件 存储,并获取CSV文件并设置管道,以便它将填充Azure SQL数据仓库中的表.
It is actually quite a hassle to upload any CSV to Azure SQL data warehouse, since it does not support CSV upload directly or INSERT INTO command with multiple values. One way I was thinking was to use Azure Data Factory to connect to the Azure File Storage, and get CSV file and set up a pipelines so it will populate a table on Azure SQL data warehouse.
我查阅了各种文件.但是,实际上并没有在任何地方进行详细讨论.这可能吗?
I went into various documents. However, this was not actually discussed in detail anywhere. Is this possible?
推荐答案
嗨Keynest,
Hi Keynest,
您可以使用ADF 文件连接器.您可以选择适当的解决方案:
You can do that by using the ADF file connector. And you can choose the proper solutions:
- 如果数据量不大(例如< 1GB),则可以从File-> SQL DW创建直接复制活动.
- 如果数据量是bib,我们建议利用Polybase有效地将数据加载到SQL DW中.有关如何通过Polybase使用暂存副本的信息,请参阅以下文档:https://docs.microsoft.com/zh-cn/azure/data-factory/connector-azure-sql-data-warehouse#use-polybase将数据加载到Azure SQL数据仓库中
这篇关于是否可以连接到Azure存储并获取CSV文件并将其放入Azure SQL数据仓库中?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!