airflow-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Saad (Jira)" <>
Subject [jira] [Created] (AIRFLOW-6087) Snowflake Connector cannot run more than one sql from a sql file
Date Wed, 27 Nov 2019 15:20:00 GMT
Saad created AIRFLOW-6087:

             Summary: Snowflake Connector cannot run more than one sql from a sql file
                 Key: AIRFLOW-6087
             Project: Apache Airflow
          Issue Type: Improvement
          Components: contrib, operators
    Affects Versions: 1.10.6
            Reporter: Saad

I am getting an error when passing in a SQL file with multiple SQL statements to snowflake
snowflake.connector.errors.ProgrammingError: 000006 (0A000): 01908236-01a3-b2c4-0000-f36100052686:
Multiple SQL statements in a single API call are not supported; use one API call per statement
It only fails if you pass a file with multiple statements. A file with just one statement
or list of statements to the operator works fine.

After looking at the current snowflake operator implementation it seems like a list of SQL
statements work because it executes one statement at a time. Whereas multiple statements in
a SQL file fails because all of them are read as one continuous string.

h4. _*How can we fix this:*_

There is an API call in Snowflake python connector that supports multiple SQL statements.


This can be fixed by overriding the run function in Snowflake Hook to support multiple sql
statements in a file.

This message was sent by Atlassian Jira

View raw message