You could extract metadata from the information_schema view. Or you could use AWS Glue Data Catalog, which is a metadata management service. It creates a centralized metadata repository that can be accessed by AWS services.
For more information read here
Interested To learn more about AWS, Come & join: AWS Online training