Blog Post

Azure Data Factory Blog
1 MIN READ

ADF now supports data integration with Snowflake

Linda_Wang's avatar
Linda_Wang
Icon for Microsoft rankMicrosoft
Jun 08, 2020
Azure Data Factory provides 90+ built-in connectors allowing you to easily integrate with various data stores regardless of variety of volume, whether they are on premises or in the cloud.   We a...
Updated Aug 31, 2020
Version 4.0
azure data factory
Azure Data Integration
itsramki's avatar
itsramki
Copper Contributor
Sep 20, 2020

Linda_Wang , i am trying to load data into snowflake database, when i specify table name explicitly it worked without any issues.

 

But when i do it using a pipeline, which includes look up tables on database and copy data of each table into snowflake (lookup + foreach activity), it is failing. In the error i see that, it is including single quotes(') and double quotes (") in the table names. Here is the error, i am changing the database names and tables names. 

 

I try to run a query on snowflake with single quotes around th tablename and it did throw the error. Is ADF trying to include single quotes around table names, when i do bulk copy using (lookup + foreach activity)?

 

{ "errorCode": "2200", "message": "ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [42S02] SQL compilation error:\nObject 'mysnowflakedatabase.mysnowflakeschema.\"mytableinsnowflake\"' does not exist or not authorized.,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [42S02] SQL compilation error:\nObject 'mysnowflakedatabase.mysnowflakeschema.\"mytableinsnowflake\"' does not exist or not authorized.,Source=Snowflake,'", "failureType": "UserError", "target": "Copy data1", "details": [] }