csvファイルを利用し、データを格納させる方法
csvFileのpath確認
S3にテーブルを作って置いて
ex)
```.sql
create table sandbox.test
(
eigyo_dt date
uriage numeric(10,0)
)
;
```
*参考
arn:aws:iam https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_identifiers.html
copy https://docs.aws.amazon.com/ja_jp/redshift/latest/dg/r_COPY.html
format : arn:partition:service:region:account:resource
COPY table-name [ column-list ] FROM data_source authorization [ [ FORMAT ] [ AS ] data_format ] [ parameter [ argument ] [, ... ] ]
copy テーブル名 from 'path' iam_role 'arn:aws:iam::123456789012:role/S3Access' csv -- data_format is csv ignoreheader 1
ex) copy sandbox.test from 's3://test/work/abcdefg.csv' iam_role '' csv ignoreheader 1 ;