[publiqa_1 + publiqa_2] [database] How to handle parameter 'dynamic_storage_key'

All database steps offer the optional parameter 'dynamic_storage_key'. If this key is defined, the query result will be stored in the dynamic storage under exactly this key as a list of dictionaries.

Afterwards this query result can be processed.

Let's assume you use the following statement:

SELECT * from contacts

and you have defined the following dynamic_storage_key:

dynamic_storage_key =  'my_query_result'

and the result of the query looks like this:

id    first_name     street            zip_code    city
1     Alice          Voltastrasse 5    13355       Berlin
2     Bob            Voltastraße 5     13355       Berlin

If you want to get the value of column 'street' of the first row of your query result, you can do this as follows:

street_name = dynamic_data['my_query_result'][0]['street']