[QUESTION] Is bulk copy supported on Microsoft Fabric?

[hchenatsafe]

Question

Hello, when attempting to insert data to a Data Warehouse on Microsoft Fabric via Bulk Copy, the driver returns this exception:

com.microsoft.sqlserver.jdbc.SQLServerException: INSERT is not a supported statement type.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:316)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:137)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:31)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.sendBulkCopyCommand(SQLServerBulkCopy.java:1622)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.doInsertBulk(SQLServerBulkCopy.java:1577)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.access$300(SQLServerBulkCopy.java:67)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy$1InsertBulk.doExecute(SQLServerBulkCopy.java:673)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.sendBulkLoadBCP(SQLServerBulkCopy.java:707)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeToServer(SQLServerBulkCopy.java:1670)
at com.microsoft.sqlserver.jdbc.SQLServerBulkCopy.writeToServer(SQLServerBulkCopy.java:630)

Is Bulk Copy not supported on Microsoft Fabric? We don't encounter this issue on other Data Warehouses on Synapse, like Dedicated SQL Pools. We also don't encounter this issue when using regular INSERTs.

[barryw-mssql]

Hi hchenatsafe,

This issue is unexpected as we believe that bulk copy should work. Having said that we have not tested the driver with Fabric and at this time cannot certify it's use with Fabric. We suspect that there may be some element/configuration in Fabric that is causing this problem. We suggest that you reach out to the Fabric team as they have far more experience with these kinds of issues. We are interested in anything that you might learn.

Thx,
Barry

[Jeffery-Wasty]

Hi @hchenatsafe,

We're closing this issue as this is related to Fabric and not the JDBC driver.