使用copy命令将数据从S3复制到redshift时跳过列 [英] Skip columns while copying data into redshift from S3 using copy command

问题描述

我在S3中有一个具有100个属性/功能的CSV表，我不想在导入数据之前在RedShift中使用所有这些属性创建表.无论如何，在将数据从S3复制到Redshift时仅选择我需要的列?

I have a CSV table in S3 with 100's of attributes/features, I don't want to create table in RedShift with all these attributes before importing data. Is there anyway to select only the columns I need while copying data from S3 into Redshift?

推荐答案

aws论坛中列出了几个针对此问题的选项，请查看

There are couple of options listed in aws forum for this problem, take a look at https://forums.aws.amazon.com/message.jspa?messageID=432590 if they may work for you.

这篇关于使用copy命令将数据从S3复制到redshift时跳过列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！