Title: aws-sts-support by general-kroll-4-life · Pull Request #654 · stackql/stackql · GitHub
Open Graph Title: aws-sts-support by general-kroll-4-life · Pull Request #654 · stackql/stackql
X Title: aws-sts-support by general-kroll-4-life · Pull Request #654 · stackql/stackql
Description: 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.
Open Graph Description: 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...
X Description: 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...
Opengraph URL: https://github.com/stackql/stackql/pull/654
X: @github
Domain: github.com
| route-pattern | /:user_id/:repository/pull/:id/files(.:format) |
| route-controller | pull_requests |
| route-action | files |
| fetch-nonce | v2:d51e6f93-21fd-e871-ad1e-a31d1e981e41 |
| current-catalog-service-hash | ae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b |
| request-id | C3CE:17AC25:536652:78F52D:6A4D12A5 |
| html-safe-nonce | a01518219b186144835e6dc426244f5000a3dcf459e59bc209c973ba3484a573 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDM0NFOjE3QUMyNTo1MzY2NTI6NzhGNTJEOjZBNEQxMkE1IiwidmlzaXRvcl9pZCI6IjUwNjE4MzI2MDg5NzI2MDgxNjUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 142fcabadf99de203fc1015dec19cdcad702ff6e3e158c3e6da9e6d7aead138c |
| hovercard-subject-tag | pull_request:3741367486 |
| github-keyboard-shortcuts | repository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/stackql/stackql/pull/654/files |
| twitter:image | https://avatars.githubusercontent.com/u/82620104?s=400&v=4 |
| twitter:card | summary_large_image |
| og:image | https://avatars.githubusercontent.com/u/82620104?s=400&v=4 |
| og:image:alt | 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... |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | f02420044fa3730a0607f4a52546bdd73f5ae60187ef57d284ecb6d7f3f1d880 |
| turbo-cache-control | no-preview |
| diff-view | unified |
| go-import | github.com/stackql/stackql git https://github.com/stackql/stackql.git |
| octolytics-dimension-user_id | 95105302 |
| octolytics-dimension-user_login | stackql |
| octolytics-dimension-repository_id | 443987542 |
| octolytics-dimension-repository_nwo | stackql/stackql |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 443987542 |
| octolytics-dimension-repository_network_root_nwo | stackql/stackql |
| turbo-body-classes | logged-out env-production page-responsive full-width |
| disable-turbo | true |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | f0b6a62c1f0be1086cb0b5b077b82cebe520eb42 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width