I am getting below error. I am calling snowflake stored procedure from lookup activity to add records from source table to target table. Plz help me to rectify this error.

asked 2022-05-23T11:05:15.043+00:00
Kunal Kharade 1 Reputation point

Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [42000] SQL compilation error:
syntax error line 2 at position 29 unexpected '<EOF>'.,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [42000] SQL compilation error:
syntax error line 2 at position 29 unexpected '<EOF>'.,Source=SnowflakeODBC_sb64.dll,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,258 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2022-05-30T12:57:34.997+00:00
    ShaikMaheer-MSFT 28,096 Reputation points Microsoft Employee

    Hi @Kunal Kharade ,

    Thank you for posting query in Microsoft Q&A Platform.

    Error seems to be with SQL which you are trying to run. You mentioned it as stored procedure. Please check is all good with SP? especially at lin2 and position 29.

    You can also consider using ADF copy activity to perform this data movement from source table to sink table.

    Snowflake connector supports as source and sink in Copy activity. Hence no issues to consider this approach also.
    https://learn.microsoft.com/en-us/azure/data-factory/connector-snowflake?tabs=data-factory

    Hope this helps. Please let us know if any further queries.

    ------------

    Please consider hitting Accept Answer button. Accepted answers help community as well.

    No comments