Required argument s3_staging_dir or work_group not found.

[mooreniemi]

Required argument s3_staging_dir or work_group not found.

Even though these have been defined in the ~/.athenacli/athenaclirc. Screenshot for proof:

I'm working around this by sending in the arguments but is sub-optimal. Could this be because I am not defining aws access key and secret in the config? (I get those from the defined profile I use.)

[zzl0]

I don't have AWS account to test now. Could you try AWS_ATHENA_S3_STAGING_DIR and AWS_ATHENA_WORK_GROUP environment instead?

https://athenacli.readthedocs.io/en/latest/awsconfig.html

[mooreniemi]

Yes, those environment variables when exported work.