aws data wrangler

We have hosted the application aws data wrangler in order to run this application in our online workstations with Wine or directly.

Quick description about aws data wrangler:

An AWS Professional Service open-source python initiative that extends the power of Pandas library to AWS connecting DataFrames and AWS data-related services. Easy integration with Athena, Glue, Redshift, Timestream, OpenSearch, Neptune, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON, and EXCEL). Built on top of other open-source projects like Pandas, Apache Arrow and Boto3, it offers abstracted functions to execute usual ETL tasks like load/unload data from Data Lakes, Data Warehouses, and Databases. Convert the column name to be compatible with Amazon Athena and the AWS Glue Catalog. Run a query against AWS CloudWatchLogs Insights and convert the results to Pandas DataFrame. Get QuickSight dashboard ID given a name and fails if there is more than 1 ID associated with this name. List IAM policy assignments in the current Amazon QuickSight account.

Features:

• Copy a list of S3 objects to another S3 directory
• Delete Amazon S3 objects from a received S3 prefix or list of S3 objects paths
• Describe Amazon S3 objects from a received S3 prefix or list of S3 objects paths
• Download file from a received S3 path to local file
• Merge a source dataset into a target dataset
• Perform Upsert (Update else Insert) onto an existing Glue table

Programming Language: Python.
Categories: