If you were following the AWS Re:invent keynote yesterday there were several data specific announcements including Aurora DSQL
and S3 Tables
. Wanting to check them out, I downloaded the latest AWS CLI 2.22.9, only to find there was no dsql or s3tables options which forced me into using the AWS Console yesterday.
Overnight however AWS has updated the AWS CLI and with 2.22.10 and now you can get started with basic automation.
DSQL commands
From the DSQL Docs .
- create-cluster
- create-multi-region-clusters
- delete-cluster
- delete-multi-region-clusters
- generate-db-connect-admin-auth-token
- generate-db-connect-auth-token
- get-cluster
- list-clusters
- list-tags-for-resource
- tag-resource
- untag-resource
- update-cluster
- wait
S3Tables commands
From the S3 Tables Docs .
- create-namespace
- create-table
- create-table-bucket
- delete-namespace
- delete-table
- delete-table-bucket
- delete-table-bucket-policy
- delete-table-policy
- get-namespace
- get-table
- get-table-bucket
- get-table-bucket-maintenance-configuration
- get-table-bucket-policy
- get-table-maintenance-configuration
- get-table-maintenance-job-status
- get-table-metadata-location
- get-table-policy
- list-namespaces
- list-table-buckets
- list-tables
- put-table-bucket-maintenance-configuration
- put-table-bucket-policy
- put-table-maintenance-configuration
- put-table-policy
- rename-table
- update-table-metadata-location
2.22.10
=======
* api-change:``bedrock``: Tagging support for Async Invoke resources. Added support for Distillation in CreateModelCustomizationJob API. Support for videoDataDeliveryEnabled flag in invocation logging.
* api-change:``s3tables``: Amazon S3 Tables deliver the first cloud object store with built-in open table format support, and the easiest way to store tabular data at scale.
* api-change:``dynamodb``: This change adds support for global tables with multi-Region strong consistency (in preview). The UpdateTable API now supports a new attribute MultiRegionConsistency to set consistency when creating global tables. The DescribeTable output now optionally includes the MultiRegionConsistency attribute.
* api-change:``cloudwatch``: Support for configuring AiOps investigation as alarm action
* api-change:``redshift-serverless``: Adds support for the ListManagedWorkgroups API to get an overview of existing managed workgroups.
* api-change:``dsql``: Add new API operations for Amazon Aurora DSQL. Amazon Aurora DSQL is a serverless, distributed SQL database with virtually unlimited scale, highest availability, and zero infrastructure management.
* api-change:``qapps``: Add support for 11 new plugins as action cards to help automate repetitive tasks and improve productivity.
* api-change:``bedrock-runtime``: Added support for Async Invoke Operations Start, List and Get. Support for invocation logs with `requestMetadata` field in Converse, ConverseStream, Invoke and InvokeStream. Video content blocks in Converse/ConverseStream accept raw bytes or S3 URI.
* api-change:``glue``: This release includes(1)Zero-ETL integration to ingest data from 3P SaaS and DynamoDB to Redshift/Redlake (2)new properties on Connections to enable reuse; new connection APIs for retrieve/preview metadata (3)support of CRUD operations for Multi-catalog (4)support of automatic statistics collections
* api-change:``bedrock-agent``: Releasing SDK for Multi-Agent Collaboration.
* api-change:``quicksight``: This release includes API needed to support for Unstructured Data in Q in QuickSight Q&A (IDC).
* api-change:``s3``: Amazon S3 Metadata stores object metadata in read-only, fully managed Apache Iceberg metadata tables that you can query. You can create metadata table configurations for S3 general purpose buckets.
* api-change:``athena``: Add FEDERATED type to CreateDataCatalog. This creates Athena Data Catalog, AWS Lambda connector, and AWS Glue connection. Create/DeleteDataCatalog returns DataCatalog. Add Status, ConnectionType, and Error to DataCatalog and DataCatalogSummary. Add DeleteCatalogOnly to delete Athena Catalog only.
* api-change:``redshift``: Adds support for Amazon Redshift RegisterNamespace and DeregisterNamespace APIs to share data to AWS Glue Data Catalog.
* api-change:``datazone``: Adds support for Connections, ProjectProfiles, and JobRuns APIs. Supports the new Lineage feature at GA. Adjusts optionality of a parameter for DataSource and SubscriptionTarget APIs which may adjust types in some clients.
* api-change:``bedrock-agent-runtime``: Releasing SDK for multi agent collaboration
* api-change:``lakeformation``: This release added two new LakeFormation Permissions (CREATE_CATALOG, SUPER_USER) and added Id field for CatalogResource. It also added new conditon and expression field.
* api-change:``qbusiness``: Amazon Q Business now supports customization options for your web experience, 11 new Plugins, and QuickSight support. Amazon Q index allows software providers to enrich their native generative AI experiences with their customer's enterprise knowledge and user context spanning multiple applications.
–
