Unable to render SQL files which have`template_vars` that are lists

[tatiana]

Describe the bug

Issue reported by @mag3141592 , while trying to have a template_vars mapping a list.

Version

• Astro: 0.5.1
• Database: Snowflake

To Reproduce

1. Write the DAG containing:

   query_dwh_schema_info = aql.render(
       path='/usr/local/airflow/include/sql/schemas',
       schemas_list=["'SALESFORCE'", "'STRIPE'"])

And the following SQL file, within the declared path:

---
template_vars:
   schemas: schemas_list
---
 
SELECT
   t.table_schema,
   t.table_name,
   CONCAT(t.table_catalog, '.', t.table_schema, '.', t.table_name) table_path
FROM dwh_legacy.information_schema.tables t
WHERE
       t.table_schema IN (schemas)
   AND t.table_type = 'BASE TABLE';

2. Run the DAG

3. See error

snowflake.connector.errors.ProgrammingError: 000904 (42000): SQL compilation error: error line 10 at position 27
invalid identifier 'SCHEMAS'
(..
Task exited with return code 1

Expected behavior Render should support multiple types fo template_vars, including string/list/int/etc.

[tatiana]

@dimberman I believe this issue might have been solved with the refactoring done on 0.6.0 - but I haven't tested yet. We could assign this ticket for the next sprint..!

[sunank200]

This not relevant any more. WDYT @tatiana ?