Database in Amazon Glue
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 ?
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.
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.
Create Strategy to alert from email deadlocks in databaseAccepted Answerasked a year ago
What's the meaning of an AWS Glue Database name in italic?asked 3 months ago
Lightsale instances cannot connect to Lightsail databaseasked 6 months ago
can not update beanstalk as it keeps looking for a deleted databaseasked 3 months ago
Can QuickSight connect to Azure SQL Database?EXPERTasked 7 months ago
Connect to RDS postgres database in GLUE scriptasked 3 months ago
Database in Amazon Glueasked 2 months ago
Best way to run a web scraper from my S3 website and save the returned information to a databaseasked 3 months ago
Are you able to hide tables in a database using Lake Formation Taggingasked 3 months ago
How to copy RDS database from Account A to Account Basked 3 months ago