How to pass RunProperties while calling the glue workflow using boto3 and python in lambda function?

Question

My python code in lambda function:

import json

import boto3

from botocore.exceptions import ClientError


glueClient = boto3.client('glue')

default_run_properties = {'s3_path': 's3://bucketname/abc.zip'}

response = glue_client.start_workflow_run(Name="Testing",RunProperties=default_run_properties)

print(response)

I am getting error like this:

"errorMessage": "Parameter validation failed:\nUnknown parameter in input: \"RunProperties\", must be one of: Name",
  "errorType": "ParamValidationError",

I also tried like this :

session = boto3.session.Session()
glue_client = session.client('glue')

But got the same error.

can anyone tell how to pass the RunProperties while calling the glue workflow to run .The RunProperties are dynamic need to be passed from lambda event.

score 3 · Answer 1 · answered Mar 11 '22 at 16:42

I had the same issue and this is a bit tricky. I do not like my solution, so maybe someone else has a better idea? See here: https://github.com/boto/boto3/issues/2580 And also here: https://docs.aws.amazon.com/glue/latest/webapi/API_StartWorkflowRun.html

So, you cannot pass the parameters when starting the workflow, which is a shame in my opinion, because even the CLI suggests that: https://docs.aws.amazon.com/cli/latest/reference/glue/start-workflow-run.html

However, you can update the parameters before you start the workflow. These values are then set for everyone. If you expect any "concurrency" issues then this is not a good way to go. You need to decide, if you reset the values afterwards or just leave it to the next start of the workflow.

I start my workflows like this:

glue_client.update_workflow(
    Name=SHOPS_WORKFLOW_NAME,
    DefaultRunProperties={
        's3_key': file_key,
        'market_id': segments[0],
    },
)

workflow_run_id = glue_client.start_workflow_run(
    Name=SHOPS_WORKFLOW_NAME
)

This basically produces the following in the next run:

score 1 · Answer 2 · answered Jun 22 '22 at 08:19

I had the same problem and asked in AWS re:Post. The problem is the old boto3 version used in Lambda. They recommended two ways to work around this issue:

Update run properties for a Job immediately after start_workflow_run:

default_run_properties = {'s3_path': 's3://bucketname/abc.zip'}

response = glue_client.start_workflow_run(Name="Testing")

updateRun = glue_client.put_workflow_run_properties(
    Name = "Testing",
    RunId = response['RunId'],
    RunProperties = default_run_properties
)

Or you can create a lambda layer for your lambda function and include a new boto3 version there.

How to pass RunProperties while calling the glue workflow using boto3 and python in lambda function?

2 Answers2