How to convert list to int using jinja language

Archive
1

below is the scenario, planned to create a variable using run_query method. but somehow, what i got is the list format. can anyone help me to convert list to int? tried to use results.columns.rows or results.columns. none of them works. anyone can help on this? really appreciated it.

{% macro SP_TEST() %}

{% set get_date_parameter %}

SELECT TO_VARCHAR(TO_DATE(‘01/03/2021’),‘MM/DD/YYYY’),TO_VARCHAR(TO_DATE(‘03/03/2075’),‘MM/DD/YYYY’),

      datediff(month,'01/03/2021','03/03/2075'),   

      TO_VARCHAR(TO_DATE(CONCAT(DATE_PART(YEAR,'03/03/2075':: DATE),'-', DATE_PART(MONTH,'03/03/2075':: DATE ),'-01' )),'YYYY-MM-DD'),    

      TO_VARCHAR(LAST_DAY(TO_DATE('03/03/2075')),'YYYY-MM-DD')

{% endset %}

{% set results = run_query(get_date_parameter) %}

{% if execute %}

{% set get_total_loop = results.columns[0].values() %}

{% else %}

{% set get_total_loop = 1 %}

{% endif %}

{% set counter = 1 %}

create or replace table semantic.test(id int)

{% for counter in range(1, get_total_loop) %}

{% if counter < max_counter %}

insert into semantic.test

select 1

{% endif %}

{%set counter = counter+1 %}

{% endfor %}

{% endmacro %}

Thanks,
ALEX