我正在尝试从Azure Data Lake Storage读取数据并使用Azure Data Factory管道写入snowflake数据库。 但是我越来越错误了。同时,我还可以从snowflake阅读它。我确实在数据库方面具有写权限。我在Azure VM上安装了集成运行时,在VM上安装了ODBC驱动程序。能够成功建立连接。
Message': 'Failure happened on 'Sink' side. ErrorCode=SystemErrorOdbcWriteError,'Type=microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [07009] [snowflake][ODBC] (10670) Invalid descriptor index,descriptor record does not exist,or descriptor record was not properly initialized.,Source=microsoft.DataTransfer.Clientlibrary.Odbc.OdbcConnector,''Type=microsoft.DataTransfer.Clientlibrary.Odbc.Exceptions.OdbcException,Source=snowflake,'','EventType': 0,'Category': 5,'Data': {
'FailedOdbcDbOperation': 'ERROR [07009] [snowflake][ODBC] (10670) Invalid descriptor index,or descriptor record was not properly initialized.','FailureInitiator': 'Sink'
},'MsgId': null,