Snowflake数据卸载到CSV文件

huangapple go评论78阅读模式
英文:

Snowflake Data Unload to csv files

问题

使用Snowflake的copy into命令从中卸载数据时,如果不使用任何压缩并直接导入大约500MB的CSV文件,数据存储成本会增加吗?

英文:

While using copy into command to unload data from Snowflake, will data storage cost increase if I don't use any compression and directly bring csv files which accounts to around 500 mb data?

答案1

得分: 1

如果输出文件未经压缩,它们可能会占用更多的空间,可能会增加成本。

根据云服务提供商和地区,Snowflake存储成本可能会有所不同,但大致在每TB/月40-50美元左右。因此,如果总大小约为500MB,这不会产生很大的差异。

Snowflake定价页面:https://www.snowflake.com/pricing/

AWS S3存储:https://aws.amazon.com/s3/pricing/

Azure:https://azure.microsoft.com/en-us/pricing/details/storage/

英文:

If the output files are not compressed, they will probably consume more space and it may increase the costs.

Depending on Cloud Provider and region, Snowflake storage costs may be different but it's around $40-50 per TB/month. So if the total size is about 500 MB, this will not make a big difference.

Snowflake pricing page: https://www.snowflake.com/pricing/

AWS S3 storage: https://aws.amazon.com/s3/pricing/

Azure: https://azure.microsoft.com/en-us/pricing/details/storage/

huangapple
  • 本文由 发表于 2020年1月3日 16:21:01
  • 转载请务必保留本文链接:https://go.coder-hub.com/59575232.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定