microsoft / sql-spark-connector

Apache Spark Connector for SQL Server and Azure SQL
Apache License 2.0
273 stars 116 forks source link

Don't run the AFTER insert trigger #243

Closed kikkoloponte closed 10 months ago

kikkoloponte commented 10 months ago

Since the insertions performed by the connector are in BULK INSERT and the triggers in Azure SQL by default are not executed during bulk insertions, it would be necessary to activate them explicitly in the command with the FIRE_TRIGGER option. but I don't know if it is possible to modify the code and where to intervene.