Skip to content

aws-sts-support#654

Merged
general-kroll-4-life merged 1 commit into
mainfrom
feature/aws-sts-support
May 25, 2026
Merged

aws-sts-support#654
general-kroll-4-life merged 1 commit into
mainfrom
feature/aws-sts-support

Conversation

@general-kroll-4-life

@general-kroll-4-life general-kroll-4-life commented May 25, 2026 •
edited
Loading

Copy link
Copy Markdown
Contributor

Description

  • Native support for aws sts role assumption.

Type of change

  • Bug fix (non-breaking change to fix a bug).
  • Feature (non-breaking change to add functionality).
  • Breaking change.
  • Other (eg: documentation change). Please explain.

Issues referenced.

N/A.

Evidence

  • Testing automations are inside any-sdk.
  • Please see figure T-1 for live testing.
% ./build/stackql --auth '{"aws":{"type":"aws_assume_role","keyIDenvvar":"AWS_ACCESS_KEY_ID","credentialsenvvar":"AWS_SECRET_ACCESS_KEY", "aws_role_arn": "'${STACKQL_AUDIT_ROLE_ARN}'"}}' shell
stackql Command Shell 1.1.1
Copyright (c) 2021, stackql studios. All rights reserved.
Welcome to the interactive shell for running stackql commands.
---

stackql  >>select * from aws.s3.buckets_list_only where region = 'ap-southeast-2';
|----------------|----------------------------------------------------------|
|     region     |                       bucket_name                        |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | analytics-root-bucket                                    |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | athena-query-output-glue-test                            |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | aws-logs-824532806693-us-east-1                          |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | cf-templates-1bj82p8e02kjm-us-east-1                     |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | config-bucket-824532806693                               |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | data-interoperability-with-unity-catalog-dev-metastore   |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | data-interoperability-with-unity-catalog-dev-root-bucket |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | data-modelling-strategies-dev-metastore                  |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | data-modelling-strategies-dev-root-bucket                |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | data-sharing-provider-prd-metastore                      |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | data-sharing-provider-prd-root-bucket                    |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | data-sharing-recipient-prd-metastore                     |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | data-sharing-recipient-prd-root-bucket                   |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | databricks-lakeflow-jobs-demo-prd-metastore              |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | databricks-lakeflow-jobs-demo-prd-root-bucket            |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | databricks-migration-bucket                              |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | db-teach-02                                              |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | db-teach-spark-01                                        |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | emr-demo-1753654757                                      |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | emr-studio-demo-824532806693-ap-southeast-2-an           |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | engineering-root-bucket                                  |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | hadoop-migration-demo-824532806693-ap-southeast-2        |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | hadoop-migration-lab-dev-metastore                       |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | hadoop-migration-lab-dev-root-bucket                     |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-bucket-02                                             |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-bucket-05                                             |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-bucket007                                             |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-bucket008                                             |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-great-new-stackql-bucket-2                            |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-great-novel-stackql-bucket                            |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-great-novel-stackql-bucket-two                        |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-kr-other-bucket                                       |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-kr-other2-bucket                                      |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-kr-other3-bucket                                      |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-kr-other44-bucket                                     |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-kr-other55-bucket                                     |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | my-manual-ui-bucket                                      |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | patch-doc-test-sit-bucket1                               |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | pde-sqlserver-samples                                    |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | serverless-workspace-test-dev-metastore                  |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | serverless-workspace-test-dev-root-bucket                |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | spike-batch-landing-01                                   |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | spike-landing-01                                         |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | spike-processed-01                                       |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | sqlserver-migration-dev-metastore                        |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | sqlserver-migration-dev-root-bucket                      |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-deploy-test-bucket-ja                            |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-deploy-test-bucket-kr                            |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-lambda-fns                                       |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-pre-release-01                                   |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-pre-release-02                                   |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-registry-artifacts                               |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-serverless-dev-metastore                         |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-serverless-dev-root-bucket                       |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-serverless-prd-metastore                         |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-serverless-prd-root-bucket                       |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-serverless-stg-metastore                         |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-serverless-stg-root-bucket                       |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-tb-ci-02                                         |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-tb-ci-03                                         |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-trial-bucket-01                                  |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | stackql-trial-bucket-02                                  |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | streaming-ingestion-with-zerobus-dev-metastore           |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | streaming-ingestion-with-zerobus-dev-root-bucket         |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | test-subdomain-takeover-bucket                           |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uklakeeu-west-2-datalake-prod                            |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uklakeeu-west-2-datalake-staging                         |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uklakeeu-west-2-dr-backup                                |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uklakeeu-west-2-dr-backup-replica                        |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uklakeeu-west-2-logs                                     |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uklakeeu-west-2-workspace                                |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uslakeus-west-2-datalake-prod                            |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uslakeus-west-2-datalake-staging                         |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uslakeus-west-2-dr-backup                                |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uslakeus-west-2-dr-backup-replica                        |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uslakeus-west-2-logs                                     |
|----------------|----------------------------------------------------------|
| ap-southeast-2 | uslakeus-west-2-workspace                                |
|----------------|----------------------------------------------------------|

Figure T-1: sts based stackql session supports foreign tenancy query.

Checklist:

  • A full round of testing has been completed, and there are no test failures as a result of these changes.
  • The changes are covered with functional and/or integration robot testing.
  • The changes work on all supported platforms.
  • Unit tests pass locally, as per the developer guide.
  • Robot tests pass locally, as per the developer guide.
  • Linter passes locally, as per the developer guide.

Variations

Tech Debt

No technical debt is added in this change.

@general-kroll-4-life
aws-sts-support
5977a4e 
Summary:

- Native support for `aws` `sts` role assumption.
@general-kroll-4-life general-kroll-4-life merged commit 0ff5315 into main May 25, 2026
19 checks passed
@general-kroll-4-life general-kroll-4-life deleted the feature/aws-sts-support branch May 25, 2026 13:22
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

1 participant

@general-kroll-4-life