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 }}
.
Asked: 2022-07-29 11:00:00 +0000
Seen: 9 times
Last updated: Jul 06 '21