How can you obtain the outcome of a select query using dbt jinja?

edit

To obtain the outcome of a select query using dbt jinja, you can use the {{ run_query() }} function. This function allows you to run a raw SQL query and obtain the result as a DataFrame.

Here is an example:

{% set my_query %}
    SELECT *
    FROM orders
{% endset %}

{% set my_result = run_query(my_query) %}

{{ my_result }}

In this example, we first define a variable my_query that contains a raw SQL query. We then use the run_query() function with my_query as a parameter to execute the query and store the result in my_result. Finally, we output the result using {{ my_result }}.