1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
To load the sample JSON file into Redshift with the key
column as multiple rows, you'll need to flatten the nested col2
array. Redshift doesn't directly support flattening nested arrays into rows, so you'll need to preprocess the file. Use a script to flatten the array into separate JSON objects, upload the preprocessed file to S3, and then use a JSONPaths
file and the COPY command in Redshift to load the data into a staging table. From there, you can further process the data as needed before inserting it into your target table.
관련 콘텐츠
- AWS 공식업데이트됨 2년 전