@kapa.ai how to set transaction isolation level for mssql source not using CDC?

I'm sorry, but the provided knowledge sources do not contain information on how to set the transaction isolation level for an MSSQL source not using CDC in Airbyte. However, it's important to note that Airbyte uses snapshot isolation when performing an initial consistent snapshot of your database for CDC. This is to avoid acquiring table locks and allowing simultaneous writes by other database clients. Here is the command used to enable snapshot isolation on the database:

sql ALTER DATABASE {database name}     SET ALLOW_SNAPSHOT_ISOLATION ON;

(Source: [Airbyte Documentation](https://docs.airbyte.com/integrations/sources/mssql#2-enable-snapshot-isolation)) For more specific information on setting the transaction isolation level for an MSSQL source not using CDC, I would recommend checking the Airbyte documentation or reaching out to the Airbyte community for further assistance.

@kapa.ai can we set it through the JDBC parameter?

A message from kapa.ai

Based on the provided knowledge sources, it's not explicitly stated whether the transaction isolation level can be set through the JDBC parameters for an MSSQL source in Airbyte. However, Airbyte does allow for the customization of JDBC connections through the use of JDBC URL parameters. These parameters can be specified as key-value pairs separated by the symbol & in the JDBC URL Parameters (Advanced) field. For example:

key1=value1&key2=value2&key3=value3

. These parameters will be added at the end of the JDBC URL that Airbyte uses to connect to your database ([source](https://docs.airbyte.com/integrations/sources/postgres/postgres-troubleshooting#advanced-custom-jdbc-connection-strings)). Please note that certain keys (

currentSchema

,

user

,

password

,

ssl

, and

sslmode

) should not be used in the JDBC URL Params field as they will be overwritten by Airbyte. For MSSQL specifically, you might want to check the official JDBC driver documentation or consult with the Airbyte community to confirm whether the transaction isolation level can be set via JDBC parameters.