Database in Amazon Glue

0

Hi, I would like to know, when crawling the data from s3 in order to create a database; does the database must be a relational database ? It can have tables that no relation with other tables ?

posix
질문됨 2년 전241회 조회
1개 답변
0

The "database" in your question is the Glue Data Catalog database. By crawling data files in S3, you are discovering the schema (metadata) from the data files and creating table(s) in a database as relational representation of the data. So, the answer is "no". It will not be a truly relational database. It is a Glue Data Catalog database object. You do not even need to pre-create the database, you may let crawler create it for you if not exist.

profile pictureAWS
jputro
답변함 2년 전
  • If i undestand, it will not neither a truly relational database on Athena ?

  • What is a truly relational database? This is not an Oracle or MySQL, etc. Athena is an SQL engine that allows you to write SQL statements and retrieve data from files in S3 (and many other data sources), including the ability to join "tables", similar to what you can do with a "true" RDBMS.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠