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.

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

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.
9,528 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2022-05-30T12:57:34.997+00:00

    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.

    0 comments