AWS Glue Databases

AWS Glue Databases - A set of associated Data Catalog table definitions organized into logical group.

AWS Glue Database is just a name convention to logically organize tables into a group. It’s not physically moving tables or data to anywhere. Tables and data are still reside in it orgirinal locations

Create AWS Glue database

  1. Go to Glue console.
  2. Go to Database, then click Add database.
  3. Provide a name, description (option), and location refer database (option):

    • Name: customer_database Glue

      If you plan to access the database from Amazon Athena, then provide a name with only alphanumeric and underscore ‘_’ characters. For more information, see Athena names.

    • Description: this is a customer database

    • Location: S3 database folder path Glue

      In fact, you may not need to create physical database folders in S3, and you can just leave blank the location option in Glue Database. That’s okay. However, it will be easier to manage when you create a well-structured physical folder hierarchy in S3 and then reflecting that structure with corresponding databases and tables in AWS Glue