AWS Glue Features

Allows administrators to assign role-based user access for specific data sets

Hides and masks sensitive data automatically based on user permissions

Provides historical insights into original data sources and transformations made to data sets

Offers simple search capabilities to discover specific data sets

Allows users and administrators to easily clean data to maintain quality and integrity

Converts data formats of source data into the format required for the reporting system without mistakes

Tools to (re)structure data in a manner that allows extracting insights quickly and accurately

Allows users to comment on data sets to help future users better interact and interpret the data

Permits profiling of data sets for increased organization, both by users and machine learning

Creates a business glossary for faster understanding by the average business user

Indexes metadata descriptions for easier searching and enhanced insights

Provides a wide range of possible data connections, including cloud applications, on-premise databases, and big data distributions, among others

Allows businesses to easily connect to any data source

Offers API connections for cloud-based applications and data sources

Permits profiling of data sets for increased organization, both by users and machine learning

Indexes metadata descriptions for easier searching and enhanced insights

Tools to (re)structure data in a manner that enables quick and accurate insight extraction

Allows self-service joining of tables

Provides the ability to combine data sources into one data set

Allows users and administrators to easily clean data to maintain quality and integrity

Offers collaborative functionality for sharing queries and data sets

Ensures user access management, data lineage, and data encryption

Provides a wide range of possible integrations, including analytics, data integration, master data management, and data science tools

Allows businesses to easily integrate with analytics, data integration, master data management, and data science tools

Operationalizes data workflows to easily scale repeatable preparation needs

Supports for managing different types of databases and integration methods.

Gives admistrators control over data-related privilages and accessability

Allows users to secure access to data. Provides additional support for security practices like IP whitelisting, attack mitigation, and data encryption.

Creates integrations and allows management of connected contains.

Allows administrators to organize components of the database to maintain instance efficiency.

Allows admisistrators to manage and organize storage, networks, and datacenters.

Application Programming Interface Specification for how the application communicates with other software. APIs typically enable integration of data, logic, objects, etc. with other software applications.

Processes data and represents interpretations in a variety of graphic formats.

Functions when integrated with multiple forms of external applications.

Tools to (re)structure data in a manner that allows extracting insights quickly and accurately.

View ETL process data via reports and visualizations like charts and graphs.

Record ETL historical data for auditing and potential data correction needs.

Track data and system backups, replication, and failover events.

Integrate with other management, resilience, or backup solutions

Be compatible with a variety of cloud and/or virtual infrastructure.

Monitor replication environment via GUI

Extract data from the designated source(s) like relational databases, JSON files, and XML files.

Cleanse and re-format extracted data to the needed target format.

Load reformatted data into target database, data warehouse, or other storage location.

Arrange ETL processes to occur automatically on needed time schedule (e.g., daily, weekly, monthly).

Capable of scaling processing power up or down based on ETL volume.

Provide as-before failover capabilities for cloud environments.

Services are offered under a pay-as-you-go or utilization-based purchase model.

Offer disaster recovery capabilities as a third-party provider.

Allows users to generate text based on a text prompt.

Condenses long documents or text into a brief summary.

Allows users to generate text based on a text prompt.

Capability to perform complex tasks without constant human input

Ability to break down and plan multi-step processes

Works across multiple software systems or databases

Improves performance based on feedback and experience

Makes informed choices based on available data and objectives

Capability to perform complex tasks without constant human input

Ability to break down and plan multi-step processes

Works across multiple software systems or databases