AWS Glue gives power to apply custom certificates for JDBC Connections

AWS Glue is an entirely organized extract, transform, and load service (ETL Service) which helps to make it easier and cost-effective to classify your data, clean it, enrich it, and transfer it securely between different data stores. AWS Glue contains a central metadata repository known as the AWS Glue Data Catalog. This Glue Data Catalog is an ETL engine which automatically produces Python or Scala code, and a flexible scheduler that takes care of dependency resolution, job monitoring, and retries. There is no infrastructure required to setup or manage as AWS Glue is serverless. Now custom certificates can be used in AWS Glue during JDBC connections to join to your data sources from Glue ETL jobs and crawlers. You may choose to apply custom certificates because you got a certificate from a third party supplier, or since the default certificates supported by AWS Glue do not fulfil your needs. Earlier, you were solely allowed to implement the default certificates offered by AWS Glue. Now this feature is accessible in every region where AWS Glue is available. Read the documentation to know further.

Now AWS Glue assists wheel files as dependencies for Glue Python Shell jobs

AWS Glue is an ETL service (extract, transform, and load) that is completely organized to make it easy to classify your data, polished it, enhance it, and transfer it accurately between different data stores. AWS Glue made up of a central metadata repository called as AWS Glue Data Catalog, an ETL engine that automatically creates Python or Scala code, and a flexible scheduler that handles dependency resolution, job monitoring, and retries. AWS Glue is serverless, so there’s no infrastructure to set up or manage. Earlier, you just allowed to add python dependencies with the help of egg files to AWS Glue Python Shell jobs. Now, with the help of wheel files, you can add python dependencies to AWS Glue Python Shell jobs, allowing you to get benefits of new potentials of the wheel packaging format. And now this feature is accessible in every AWS Region where AWS Glue is accessible. To get the complete list of AWS Region where AWS Glue is available, refer AWS Region page. To read more about this feature, read documentation.

Amazon Athena is Accessible in Asia Pacific (Hong Kong) Region

Amazon Athena is a simple interactive query service which examines data straight in Amazon S3 with the help of standard SQL. Athena is integrated with AWS Glue Data Catalog, enabling you to design a unified metadata repository over different services, crawl data sources to locate schemas and occupy your Catalog with latest and altered table and partition definitions, and maintain schema versioning. There is no need to set up or handle any infrastructure as Amazon Athena is serverless. And you only charge for the queries you execute. You get the faster results as Athena scales automatically—running queries in concurrently with big datasets and complex queries. You can point Athena at your data stored in Amazon S3 with few clicks in AWS Management Console, and start using standard SQL to execute ad-hoc queries and get results within seconds. Now Amazon Athena is accessible in Asia Pacific (Hong Kong) AWS Region. With this region availability, Amazon Athena is accessible in US East (Northern Virginia, & Ohio), US West (Oregon), AWS GovCloud, Europe (Ireland, Frankfurt, London, & Stockholm), and Asia Pacific (Singapore, Tokyo, Sydney, Seoul, Mumbai, & Hong Kong) AWS Regions.

AWS Glue offers FindMatches ML transform to remove duplicate data and search equivalent records in your dataset

AWS Glue is ETL service (extract, transform, and load) which is easy and cost-effective to classify your data, clean it, enrich it, and move it reliably between various data stores. AWS Glue is serverless, so there’s no infrastructure to set up or manage. AWS Glue includes a central metadata repository called as the AWS Glue Data Catalog, an ETL engine that automatically creates Python or Scala code, and a flexible scheduler which manages dependency resolution, job monitoring, and retries. Now AWS Glue can use to search equivalent records over a dataset with the help of new FindMatches ML Transform. FindMatches ML Transform is a custom machine learning transformation which aids you find equivalent records. By connecting the FindMatches transformation to your Glue ETL jobs, you can search connected products, places, suppliers, customers, and more. Besides, you can use this to remove duplicate data like to find customers who have signed up more than once, products that have been added inadvertently to your product catalog more than once, and so forth. You can instruct the FindMatches ML Transform your definition of a “duplicate” via examples, and it will utilize machine learning to search other possible duplicates in your dataset. This new feature AWS Glue ML Transforms is currently accessible in the US East (Northern Virginia), US East (Ohio), US West (Oregon), EU (Ireland), and Asia Pacific (Tokyo) AWS regions.

Now AWS Glue Feature Is Obtainable In South America (Sao Paulo) AWS Region

AWS Glue is an entirely organized ETL Service (Extract, Transform, Load) which is easy and cost-effective to classify your data, polish it, improve it, and shift it accurately within different data stores. AWS Glue made up of a central metadata repository called as the AWS Glue Data Catalog, an ETL engine which automatically creates Python or Scala code, and a flexible scheduler that manages dependency resolution, job monitoring, and retries. AWS Glue is serverless, so there’s no infrastructure to set up or manage. Now this AWS Glue feature is offered in the AWS South America (Sao Paulo) Region. AWS Glue crawls your data sources, recognizes data formats, and recommends schemas and transformations. AWS Glue can be used to execute serverless queries against your Amazon S3 data lake. AWS Glue automatically produces the code to run your data transformations and loading processes. AWS Glue execute your ETL jobs on Apache Spark environment. To get the entire list of region where AWS Glue is accessible, refer Region Table. And to know further about AWS Glue, read documentation

AWS Glue Is Obtainable In AWS EU (Stockholm) Region

AWS Glue is completely organized ETL Service i.e. Extract, Transform, Load. This service is simple for users to arrange and load their data for analytics. You can build and execute an ETL job with just some clicks in AWS Management Console. You can directly point AWS Glue to your data retained in AWS, and AWS Glue finds your data and keeps the related metadata in the AWS Glue Data Catalog. After data entered in catalog, its instantly searchable, queryable, and accessible for ETL. Now AWS EU (Stockholm) Region can access the AWS Glue feature. AWS Glue includes a central metadata repository i.e. AWS Glue Data Catalog. This is an ETL engine which automatically creates Python or Scala code, and a flexible schedule which manages dependency resolution, job monitoring, and retries. AWS Glue is serverless, so there’s no infrastructure to set up or manage. AWS Glue can utilize to design a data warehouse to manage, clean, validate, and format data. To read more information, refer AWS Glue. And to get complete list of regions where AWS Glue is accessible, refer the AWS Region Table.

Now AWS Glue Presents An VPC Interface Endpoint

AWS Glue is completely organized ETL (extract, transform, and load) service which is easy and cost-effective to group your data, sort it, lift it, and shift it accurately between various data stores. Amazon VPC is an AWS service which you can utilize to start AWS resources in a virtual network that you describe. You have charge on your network settings, like IP address range, subnets, route tables, and network gateways with a VPC. You can describe an interface VPC endpoint for AWS Glue to link your VPC to AWS Glue. Now, you can bridge straight to AWS Glue via an interface endpoint in your Virtual Private Cloud (VPC) rather than joining over the internet. Transmission between your VPC and AWS Glue is managed wholly and safely inside the AWS network when you utilize VPC interface endpoint. This new feature is accessible in every region where AWS Glue is accessible excluding AWS GovCloud (US-East) and AWS GovCloud (US). To know more about AWS Glue with VPC endpoints, refer documentation.

Now Amazon Athena Is Accessible In GovCloud (US-East)

Amazon Athena is an interactive query service which is easy to use and simple to study data in Amazon S3 with the help of standard SQL. Athena is serverless, in order that there is no infrastructure to handle, and you charge exclusively for the queries which you execute. Just indicate to your data in Amazon S3, specify the schema, and begin querying with the help of standard SQL. Many outcomes are offered in few seconds. There is no necessity for complex ETL (Extract, Transform, Load) jobs to make your data for analysis with Amazon Athena. This helps for everybody with SQL expertise to rapidly study large-scale datasets. Athena is merged with AWS Glue Data Catalog, permitting you to build a unified metadata repository over different services, crawl data sources to locate schemas and occupy your Catalog with new and modified table and partition definitions, and retain schema versioning. Besides, you can utilized AWS Glue’s completely organized ETL potentials to change data or convert it into columnar formats to optimize cost and better performance. Now Amazon Athena is accessible in the AWS GovCloud (US-East) region and US East (Northern Virginia, & Ohio), US West (Oregon), AWS GovCloud, Europe (Ireland, Frankfurt, & London), and Asia Pacific (Singapore, Tokyo, Sydney, Seoul, & Mumbai) regions.

AWS Glue Gives Assistance To Current Data Catalog Tables As Source

AWS Glue is an entirely organized ETL service (Extract, Transform, Load) which makes it simpler for users to set and load their data for analytics. You only identify AWS Glue to your data saved on AWS, and AWS Glue finds your data and keeps in linked metadata (e.g. table definition and schema) in the AWS Glue Data Catalog. A crawler can crawl several data stores within one execution. After execution, the crawler adds or updates one or more tables in your Data Catalog. A crawler can be used to populate the AWS Glue Data Catalog with tables. When cataloged, your data is instantly searchable, queryable, and available for ETL. Now you can define a list of tables from your AWS Glue Data Catalog as sources in the crawler configuration. Earlier, crawlers were only able to take data paths as sources, scan your data, and add new tables in the AWS Glue Data Catalog. Now crawlers can take current tables as sources, recognize modifications to their schema and update the table definitions, and register new partitions as new data gets accessible. This feature will be functional if you want to import current table definitions from an outer Apache Hive Metastore into the AWS Glue Data Catalog and use crawlers to maintain these up to date your data modifications. This feature is accessible in each AWS regions where AWS Glue is accessible. To know detailed about this feature, refer documentation.

AWS Glue Is Obtainable In AWS GovCloud (US-East) Region

AWS Glue is an entirely organized ETL service – Extract, Transform, and Load which performs it simpler for customers to arrange and load their data for analytics. You can build and execute an ETL job with a few clicks in the AWS Management Console. You directly point AWS Glue to your data saved on AWS. Besides, AWS Glue finds your data and saves the related metadata (e.g. table definition and schema) in the AWS Glue Data Catalog. Once recorded, your data is instantly searchable, queryable, and available for ETL. AWS Glue crawls your data sources, recognizes data formats, and proposes schemas and transformations. AWS Glue automatically creates the code to run your data transformations and loading processes. AWS Glue is serverless, so there is no infrastructure to provision or manage. AWS Glue executes your ETL jobs on a completely managed Apache Spark environment. Now, you can utilize AWS Glue in the AWS GovCloud (US-East) Region. To get the entire list where AWS Glue is accessible, click AWS Region Table