get_value_list.rst

:pyget_value_list <astro.sql.get_value_list>

When to use the get_value_list operator

We can use get_value_list when you want to execute a SQL query on a database table and get the result. This might be useful when you want to create dynamic tasks on the response of this operator.

Warning

Using this operator without limit in the SQL query can push lots of data in XCOM and also can create lots of parallel tasks if using in dynamic task map expand method.

../../../../example_dags/example_dynamic_task_template.py

Related references

• :external+airflowDynamic task mapping - Apache Airflow <authoring-and-scheduling/dynamic-task-mapping>
• Dynamic tasks - Astronomer