[
https://issues.apache.org/jira/browse/AIRFLOW-6087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jarek Potiuk updated AIRFLOW-6087:
----------------------------------
Labels: gsoc gsoc2020 mentor (was: )
> Snowflake Connector cannot run more than one sql from a sql file
> ----------------------------------------------------------------
>
> Key: AIRFLOW-6087
> URL: https://issues.apache.org/jira/browse/AIRFLOW-6087
> Project: Apache Airflow
> Issue Type: Improvement
> Components: contrib, operators
> Affects Versions: 1.10.6
> Reporter: Saad
> Priority: Major
> Labels: gsoc, gsoc2020, mentor
>
> I am getting an error when passing in a SQL file with multiple SQL statements
> to snowflake operator
> {code:java}
> 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 instead.
> {code}
> 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.
> [https://docs.snowflake.net/manuals/user-guide/python-connector-api.html#execute_string]
> 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
(v8.3.4#803005)
