如何处理Azure中的大文件? [英] How to handle large files in Azure?
问题描述
大家好,
我使用AZ复制将5个大文件(每个文件大小约为800MB)从内部移动到Azure BLOB.
I moved 5 big files (each having about 800MB size) from on premise to Azure BLOB using AZ copy.
现在,我想将它们从Azure BLOB加载到Azure SQL DWH中.我可以通过外部表概念来做到这一点.
Now , i want to load them from Azure BLOB into Azure SQL DWH. I can do it through external tables concept.
但是,我想先打开它们,然后查看文件头,定界符等...
However, i want to open them first and see the file header , delimiter etc...
我无法查看/编辑如此大的文件.有什么方法可以查看或编辑它们,然后再加载到DWH中
I am not able to view/edit such big files.Is there any way to view them or edit them before loading into DWH
请回复.
预先感谢
-Surya
推荐答案
The following forum seems to be more relevant to Azure SQL Data Warehouse questions:
">
https://social.msdn.microsoft.com/forums/azure/en-US/home?forum=AzureSQLDataWarehouse
You may get a faster response there.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
这篇关于如何处理Azure中的大文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!