like

foo.submit(1)
foo.map([2, 3])

?

cta_load_list : PrefectFuture = get_security_master_staging_cta_load_list.submit()

cta_load_results = run_stored_procedure.map(

sql_util=unmapped(staging_sql_util), procedure_name=cta_load_list

)

security_master_side_load_list: PrefectFuture = (

get_security_master_staging_dw_side_load_list.submit()

side_load_results = run_stored_procedure.map(

sql_util=unmapped(dw_sql_util), procedure_name=security_master_side_load_list

)

So the 3rd list of get_security_master_side_load_list doesn't start until the mapping has finished mapping out. Would it be better if I put a waitfor on the 3rd line?

Thanks for going through this with me by the way, these are the types of questions I am getting when trying to introduce this to the company, which usually uses C# for this sort of thing.

It’s equivalent to

for i in items:
   task.submit(i)

# same as task.map(items)

(with some more nice sugar and such)

If

items

is a future we need to resolve the future to data (wait for it to complete) first so we can make those submissions