How can I pass workgroup info to Athena startQueryExecution method in Boto32019 Community Moderator ElectionHow can I safely create a nested directory in Python?How can I remove a trailing newline in Python?How can I make a time delay in Python?How do I pass a variable by reference?How can I tag an AWS Lambda function using boto3What is the difference between S3.Client.upload_file() and S3.Client.upload_fileobj()?boto3: Unknown parameter in input: “CrawlerSecurityConfiguration” in create_crawlerAsync calls to cloudformation API with boto?How to use describe_stacks in cloudformation when you have UUID's in your stack names, e.g. test-rds-CRC25DFADXZR?Retrieve the list of EMR clusters which have the autoscaling setup using boto3
How to test the sharpness of a knife?
Interior of Set Notation
Emojional cryptic crossword
Have any astronauts/cosmonauts died in space?
Does fire aspect on a sword, destroy mob drops?
Why doesn't the fusion process of the sun speed up?
Recursively updating the MLE as new observations stream in
Friend wants my recommendation but I don't want to
Help with identifying unique aircraft over NE Pennsylvania
How do researchers send unsolicited emails asking for feedback on their works?
Do I need to convey a moral for each of my blog post?
Do people actually use the word "kaputt" in conversation?
What (if any) is the reason to buy in small local stores?
Nested Dynamic SOQL Query
When did hardware antialiasing start being available?
Can a university suspend a student even when he has left university?
Why is there so much iron?
Why are there no stars visible in cislunar space?
Asserting that Atheism and Theism are both faith based positions
Are hand made posters acceptable in Academia?
Is xar preinstalled on macOS?
What is 露わになる affecting in the following sentence, '才能の持ち主' (持ち主 to be specific) or '才能'?
Norwegian Refugee travel document
Does the Shadow Magic sorcerer's Eyes of the Dark feature work on all Darkness spells or just his/her own?
How can I pass workgroup info to Athena startQueryExecution method in Boto3
2019 Community Moderator ElectionHow can I safely create a nested directory in Python?How can I remove a trailing newline in Python?How can I make a time delay in Python?How do I pass a variable by reference?How can I tag an AWS Lambda function using boto3What is the difference between S3.Client.upload_file() and S3.Client.upload_fileobj()?boto3: Unknown parameter in input: “CrawlerSecurityConfiguration” in create_crawlerAsync calls to cloudformation API with boto?How to use describe_stacks in cloudformation when you have UUID's in your stack names, e.g. test-rds-CRC25DFADXZR?Retrieve the list of EMR clusters which have the autoscaling setup using boto3
I am seeing the below error when I try to pass WorkGroup info in the format listed below using my boto3 code in AWS Lambda -
"errorMessage": "Parameter validation failed:nUnknown parameter in
input: "WorkGroup", must be one of: QueryString, ClientRequestToken,
QueryExecutionContext, ResultConfiguration",
query_id = client.start_query_execution(
QueryString=query_string,
QueryExecutionContext=
'Database': 'sample_db'
,
ResultConfiguration=
'OutputLocation': 's3://sample_db/output/'
,
WorkGroup='workgroup1'
)['QueryExecutionId']
As per boto3 documentation , this is something that can be passed - https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/athena.html#Athena.Client.start_query_execution
python amazon-web-services aws-lambda boto3 amazon-athena
asked Mar 7 at 18:53
Punter VickyPunter Vicky
3,9532178145
|
show 4 more comments
I am seeing the below error when I try to pass WorkGroup info in the format listed below using my boto3 code in AWS Lambda -
"errorMessage": "Parameter validation failed:nUnknown parameter in
input: "WorkGroup", must be one of: QueryString, ClientRequestToken,
QueryExecutionContext, ResultConfiguration",
query_id = client.start_query_execution(
QueryString=query_string,
QueryExecutionContext=
'Database': 'sample_db'
,
ResultConfiguration=
'OutputLocation': 's3://sample_db/output/'
,
WorkGroup='workgroup1'
)['QueryExecutionId']
As per boto3 documentation , this is something that can be passed - https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/athena.html#Athena.Client.start_query_execution
python amazon-web-services aws-lambda boto3 amazon-athena
asked Mar 7 at 18:53
Punter VickyPunter Vicky
3,9532178145
What boto3 version are you using? Try updating to the latest one. Note that the one bundled in the Lambda execution environment might not be up-to-date.
– Milan Cermak
Mar 7 at 19:09
How can I upgrade the version within AWS Lambda?
– Punter Vicky
Mar 7 at 19:10
You have to bundle boto3 yourself. Add it to the deployment package. Importing it will have precedence.
– Milan Cermak
Mar 7 at 19:12
Thanks @MilanCermak. However is there a different way of adding workgroup location for Athena using old version of boto3?
– Punter Vicky
Mar 7 at 19:14
1
I don't think so. Looks like theWorkGroupparameter support got added in boto3 v1.9.97 (see e.g. the docs here for v1.9.96 boto3.amazonaws.com/v1/documentation/api/1.9.96/reference/… where the param is not present).
– Milan Cermak
Mar 7 at 19:19
|
show 4 more comments
I am seeing the below error when I try to pass WorkGroup info in the format listed below using my boto3 code in AWS Lambda -
"errorMessage": "Parameter validation failed:nUnknown parameter in
input: "WorkGroup", must be one of: QueryString, ClientRequestToken,
QueryExecutionContext, ResultConfiguration",
query_id = client.start_query_execution(
QueryString=query_string,
QueryExecutionContext=
'Database': 'sample_db'
,
ResultConfiguration=
'OutputLocation': 's3://sample_db/output/'
,
WorkGroup='workgroup1'
)['QueryExecutionId']
As per boto3 documentation , this is something that can be passed - https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/athena.html#Athena.Client.start_query_execution
python amazon-web-services aws-lambda boto3 amazon-athena
asked Mar 7 at 18:53
Punter VickyPunter Vicky
3,9532178145
I am seeing the below error when I try to pass WorkGroup info in the format listed below using my boto3 code in AWS Lambda -
"errorMessage": "Parameter validation failed:nUnknown parameter in
input: "WorkGroup", must be one of: QueryString, ClientRequestToken,
QueryExecutionContext, ResultConfiguration",
query_id = client.start_query_execution(
QueryString=query_string,
QueryExecutionContext=
'Database': 'sample_db'
,
ResultConfiguration=
'OutputLocation': 's3://sample_db/output/'
,
WorkGroup='workgroup1'
)['QueryExecutionId']
As per boto3 documentation , this is something that can be passed - https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/athena.html#Athena.Client.start_query_execution
python amazon-web-services aws-lambda boto3 amazon-athena
python amazon-web-services aws-lambda boto3 amazon-athena
asked Mar 7 at 18:53
Punter VickyPunter Vicky
3,9532178145
asked Mar 7 at 18:53
Punter VickyPunter Vicky
3,9532178145
asked Mar 7 at 18:53
Punter VickyPunter Vicky
3,9532178145
asked Mar 7 at 18:53
Punter VickyPunter Vicky
3,9532178145
asked Mar 7 at 18:53
Punter VickyPunter Vicky
3,9532178145
3,9532178145
What boto3 version are you using? Try updating to the latest one. Note that the one bundled in the Lambda execution environment might not be up-to-date.
– Milan Cermak
Mar 7 at 19:09
How can I upgrade the version within AWS Lambda?
– Punter Vicky
Mar 7 at 19:10
You have to bundle boto3 yourself. Add it to the deployment package. Importing it will have precedence.
– Milan Cermak
Mar 7 at 19:12
Thanks @MilanCermak. However is there a different way of adding workgroup location for Athena using old version of boto3?
– Punter Vicky
Mar 7 at 19:14
1
I don't think so. Looks like theWorkGroupparameter support got added in boto3 v1.9.97 (see e.g. the docs here for v1.9.96 boto3.amazonaws.com/v1/documentation/api/1.9.96/reference/… where the param is not present).
– Milan Cermak
Mar 7 at 19:19
|
show 4 more comments
What boto3 version are you using? Try updating to the latest one. Note that the one bundled in the Lambda execution environment might not be up-to-date.
– Milan Cermak
Mar 7 at 19:09
How can I upgrade the version within AWS Lambda?
– Punter Vicky
Mar 7 at 19:10
You have to bundle boto3 yourself. Add it to the deployment package. Importing it will have precedence.
– Milan Cermak
Mar 7 at 19:12
Thanks @MilanCermak. However is there a different way of adding workgroup location for Athena using old version of boto3?
– Punter Vicky
Mar 7 at 19:14
1
I don't think so. Looks like theWorkGroupparameter support got added in boto3 v1.9.97 (see e.g. the docs here for v1.9.96 boto3.amazonaws.com/v1/documentation/api/1.9.96/reference/… where the param is not present).
– Milan Cermak
Mar 7 at 19:19
What boto3 version are you using? Try updating to the latest one. Note that the one bundled in the Lambda execution environment might not be up-to-date.
– Milan Cermak
Mar 7 at 19:09
What boto3 version are you using? Try updating to the latest one. Note that the one bundled in the Lambda execution environment might not be up-to-date.
– Milan Cermak
Mar 7 at 19:09
How can I upgrade the version within AWS Lambda?
– Punter Vicky
Mar 7 at 19:10
How can I upgrade the version within AWS Lambda?
– Punter Vicky
Mar 7 at 19:10
You have to bundle boto3 yourself. Add it to the deployment package. Importing it will have precedence.
– Milan Cermak
Mar 7 at 19:12
You have to bundle boto3 yourself. Add it to the deployment package. Importing it will have precedence.
– Milan Cermak
Mar 7 at 19:12
Thanks @MilanCermak. However is there a different way of adding workgroup location for Athena using old version of boto3?
– Punter Vicky
Mar 7 at 19:14
Thanks @MilanCermak. However is there a different way of adding workgroup location for Athena using old version of boto3?
– Punter Vicky
Mar 7 at 19:14
1
1
I don't think so. Looks like the
WorkGroup parameter support got added in boto3 v1.9.97 (see e.g. the docs here for v1.9.96 boto3.amazonaws.com/v1/documentation/api/1.9.96/reference/… where the param is not present).– Milan Cermak
Mar 7 at 19:19
I don't think so. Looks like the
WorkGroup parameter support got added in boto3 v1.9.97 (see e.g. the docs here for v1.9.96 boto3.amazonaws.com/v1/documentation/api/1.9.96/reference/… where the param is not present).– Milan Cermak
Mar 7 at 19:19
|
show 4 more comments
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55050915%2fhow-can-i-pass-workgroup-info-to-athena-startqueryexecution-method-in-boto3%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55050915%2fhow-can-i-pass-workgroup-info-to-athena-startqueryexecution-method-in-boto3%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What boto3 version are you using? Try updating to the latest one. Note that the one bundled in the Lambda execution environment might not be up-to-date.
– Milan Cermak
Mar 7 at 19:09
How can I upgrade the version within AWS Lambda?
– Punter Vicky
Mar 7 at 19:10
You have to bundle boto3 yourself. Add it to the deployment package. Importing it will have precedence.
– Milan Cermak
Mar 7 at 19:12
Thanks @MilanCermak. However is there a different way of adding workgroup location for Athena using old version of boto3?
– Punter Vicky
Mar 7 at 19:14
1
I don't think so. Looks like the
WorkGroupparameter support got added in boto3 v1.9.97 (see e.g. the docs here for v1.9.96 boto3.amazonaws.com/v1/documentation/api/1.9.96/reference/… where the param is not present).– Milan Cermak
Mar 7 at 19:19