in the dbt jinja, when we use run_query, we can get columns from query using results.columns[1]. but where can i find documentation for this result property. i want to see if i can use other attribute rather than column. the reason i ask because i want to get first value of the columns. in other word, what i want is not the list, i just want to have a integer from the result rather than the whole columns. anyone can share the documentation or teach me how to get single value from query run result? thanks so much for the help.
{% set results = run_query(payment_methods_query) %}
{% if execute %}
{# Return the first column #}
{% set results_list = results.columns[0].values() %}
Thanks,
Alex