| version: "3.8" | |
| services: | |
| AwsCLI: | |
| image: public.ecr.aws/aws-cli/aws-cli | |
| container_name: aws-cli | |
| platform: linux/x86_64 | |
| volumes: | |
| - ~/.aws/:~/.aws/ # Mount local credentials into container to use AWS CLI/SDK | |
| environment: |
| #! /bin/bash -i | |
| set -e | |
| # Constants | |
| PROFILE_NICKNAME_FILE=".awsprofile.env" | |
| AWS_CONFIG_FILE="$AWS_CONFIG_FILE" | |
| # Variables | |
| original_request="$1" | |
| requested_profile="" |
This could be improved, but does the trick for now. This is for a report configured as "daily" with resource IDs:
CREATE EXTERNAL TABLE IF NOT EXISTS `org_data`.`curv2` (
`discount_bundled_discount` string,
`discount_total_discount` string,
`identity_line_item_id` string,
`identity_time_interval` string,