1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
Hi there,
Another option for inferring schemas of files that reside in S3 is to use an AWS Glue Crawler.
Once the S3-based files have been crawled, table entries will appear in the AWS Glue Data Catalog, which can be made visible in Redshift through creation of an EXTERNAL SCHEMA using the 'DATA CATALOG' keyword.
Once the external schema is created, you can begin querying the crawled tables inside Redshift. To create a physical copy of the external tables in Redshift, you can run a CTAS statement.
Any subsequent tables crawled will appear within Redshift for querying (as long as they are mapped to the same Glue Database).
I hope this helps!
관련 콘텐츠
- AWS 공식업데이트됨 9달 전
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 3년 전
- AWS 공식업데이트됨 2년 전