Got an error when check_update executes on backend.
I've looked at Docker Hub and yesterday had an update on this connector.
Airbyte version: v0.41.0 (please don't judge me... haha, update to 1.x.x incoming...)
Internal Server Error: Duplicate key 37a928c1-2d5c-431a-a97d-ae236bd1ea0c (attempted merging values io.airbyte.config.StandardDestinationDefinition@2d65f7f0[destinationDefinitionId=37a928c1-2d5c-431a-a97d-ae236bd1ea0c,name=MS SQL Server V2,dockerRepository=airbyte/destination-mssql-v2,dockerImageTag=0.1.15,documentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-v2,icon=icon.svg,spec=io.airbyte.protocol.models.ConnectorSpecification@6f4a3078[documentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-v2,changelogUrl=<null>,connectionSpecification={"$schema":"http://json-schema.org/draft-07/schema#","title":"MSSQL V2 Destination Specification","type":"object","additionalProperties":true,"properties":{"host":{"type":"string","description":"The host name of the MSSQL database.","title":"Host","order":0},"port":{"type":"integer","description":"The port of the MSSQL database.","title":"Port","minimum":0,"maximum":65536,"examples":["1433"],"order":1},"database":{"type":"string","description":"The name of the MSSQL database.","title":"DB Name","order":2},"schema":{"type":"string","description":"The default schema tables are written to if the source does not specify a namespace. The usual value for this field is \"public\".","title":"Default Schema","examples":["public"],"default":"public","order":3},"user":{"type":"string","description":"The username which is used to access the database.","title":"User","order":4},"password":{"type":"string","description":"The password associated with this username.","title":"Password","airbyte_secret":true,"order":5},"jdbc_url_params":{"type":"string","description":"Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).","title":"JDBC URL Params","order":6},"ssl_method":{"oneOf":[{"title":"Unencrypted","type":"object","additionalProperties":true,"description":"The data transfer will not be encrypted.","properties":{"name":{"type":"string","enum":["unencrypted"],"default":"unencrypted"}},"required":["name"]},{"title":"Encrypted (trust server certificate)","type":"object","additionalProperties":true,"description":"Use the certificate provided by the server without verification. (For testing purposes only!)","properties":{"name":{"type":"string","enum":["encrypted_trust_server_certificate"],"default":"encrypted_trust_server_certificate"}},"required":["name"]},{"title":"Encrypted (verify certificate)","type":"object","additionalProperties":true,"description":"Verify and use the certificate provided by the server.","properties":{"name":{"type":"string","enum":["encrypted_verify_certificate"],"default":"encrypted_verify_certificate"},"trustStoreName":{"type":"string","description":"Specifies the name of the trust store.","title":"Trust Store Name","order":1},"trustStorePassword":{"type":"string","description":"Specifies the password of the trust store.","title":"Trust Store Password","airbyte_secret":true,"order":2},"hostNameInCertificate":{"type":"string","description":"Specifies the host name of the server. The value of this property must match the subject property of the certificate.","title":"Host Name In Certificate","order":3}},"required":["name"]}],"description":"The encryption method which is used to communicate with the database.","title":"SSL Method","order":7,"type":"object"},"load_type":{"oneOf":[{"title":"Insert Load","type":"object","additionalProperties":true,"description":"Configuration details for using the INSERT loading mechanism.","properties":{"load_type":{"type":"string","enum":["INSERT"],"default":"INSERT"}},"required":["load_type"]},{"title":"Bulk Load","type":"object","additionalProperties":true,"description":"Configuration details for using the BULK loading mechanism.","properties":{"load_type":{"type":"string","enum":["BULK"],"default":"BULK"},"azure_blob_storage_account_name":{"type":"string","description":"The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts","title":"Azure Blob Storage Account Name","examples":["mystorageaccount"]},"azure_blob_storage_container_name":{"type":"string","description":"The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers","title":"Azure Blob Storage Container Name","examples":["mycontainer"]},"shared_access_signature":{"type":"string","description":"A shared access signature (SAS) provides secure delegated access to resources in your storage account. See: https://learn.microsoft.com/azure/storage/common/storage-sas-overview","title":"Shared Access Signature","examples":["a012345678910ABCDEFGH/AbCdEfGhEXAMPLEKEY"],"airbyte_secret":true,"always_show":true},"bulk_load_data_source":{"type":"string","description":"Specifies the external data source name configured in MSSQL, which references the Azure Blob container. See: https://learn.microsoft.com/sql/t-sql/statements/bulk-insert-transact-sql","title":"BULK Load Data Source","examples":["MyAzureBlobStorage"],"order":4,"always_show":true},"bulk_load_validate_values_pre_load":{"type":"boolean","description":"When enabled, Airbyte will validate all values before loading them into the destination table. This provides stronger data integrity guarantees but may significantly impact performance.","title":"Pre-Load Value Validation","examples":["false"],"default":false,"order":5,"always_show":false}},"required":["load_type","azure_blob_storage_account_name","azure_blob_storage_container_name","shared_access_signature","bulk_load_data_source"]}],"description":"Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.","title":"Load Type","always_show":true,"order":8,"type":"object"}},"required":["host","port","database","schema","user","ssl_method","load_type"]},supportsIncremental=true,supportsNormalization=false,supportsDBT=false,supportedDestinationSyncModes=[overwrite, append, append_dedup],authSpecification=<null>,advancedAuth=<null>,protocolVersion=<null>,additionalProperties={}],tombstone=false,_public=true,custom=false,releaseStage=alpha,releaseDate=<null>,resourceRequirements=<null>,protocolVersion=0.2.0,normalizationConfig=<null>,supportsDbt=<null>,allowedHosts=<null>,additionalProperties={connectorBuildOptions={baseImage=docker.io/airbyte/java-connector-base:2.0.0@sha256:5a1a21c75c5e1282606de9fa539ba136520abe2fbd013058e988bb0297a9f454}, connectorTestSuitesOptions=[{suite=unitTests, testSecrets=null, testConnections=null}, {suite=integrationTests, testSecrets=[{name=SECRET_DESTINATION_MSSQL_V2_BULK_LOAD_CONFIG, fileName=bulk_upload_config.json, secretStore={alias=airbyte-connector-testing-secret-store, type=GSM}}], testConnections=null}], language=java, supportLevel=community, tags=[language:java], supportsRefreshes=true, ab_internal={sl=100, ql=100}, license=ELv2, generated={git={commit_sha=600587baa92fc46ef090e2a019ca105ca4649fd5, commit_timestamp=2025-03-10T08:35:24-07:00, commit_author=Johnny Schmidt, commit_author_email=john.schmidt@airbyte.io}, source_file_info={metadata_etag=CJrH2bXw/4sDEAE=, metadata_file_path=metadata/airbyte/destination-mssql-v2/latest/metadata.yaml, metadata_bucket_name=prod-airbyte-cloud-connector-metadata-service, metadata_last_modified=2025-03-10T15:57:16.158000+00:00, registry_entry_generated_at=2025-03-10T16:00:36.748103}, metrics={all={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=all, connector_version=all, sync_success_rate=medium, usage=high}, cloud={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=cloud, connector_version=0.1.14, sync_success_rate=medium, usage=high}, oss={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=oss, connector_version=0.1.14, sync_success_rate=medium, usage=high}}, sbomUrl=https://connectors.airbyte.com/files/sbom/airbyte/destination-mssql-v2/0.1.15.spdx.json}, sourceType=database, githubIssueLabel=destination-mssql-v2, iconUrl=https://connectors.airbyte.com/files/metadata/airbyte/destination-mssql-v2/latest/icon.svg, packageInfo={}, supportsFileTransfer=false}] and io.airbyte.config.StandardDestinationDefinition@63e33c90[destinationDefinitionId=37a928c1-2d5c-431a-a97d-ae236bd1ea0c,name=MS SQL Server,dockerRepository=airbyte/destination-mssql,dockerImageTag=2.0.0,documentationUrl=https://docs.airbyte.com/integrations/destinations/mssql,icon=icon.svg,spec=io.airbyte.protocol.models.ConnectorSpecification@6bffbecc[documentationUrl=https://docs.airbyte.com/integrations/destinations/mssql,changelogUrl=<null>,connectionSpecification={"$schema":"http://json-schema.org/draft-07/schema#","title":"MSSQL Destination Specification","type":"object","additionalProperties":true,"properties":{"host":{"type":"string","description":"The host name of the MSSQL database.","title":"Host","order":0},"port":{"type":"integer","description":"The port of the MSSQL database.","title":"Port","minimum":0,"maximum":65536,"examples":["1433"],"order":1},"database":{"type":"string","description":"The name of the MSSQL database.","title":"DB Name","order":2},"schema":{"type":"string","description":"The default schema tables are written to if the source does not specify a namespace. The usual value for this field is \"public\".","title":"Default Schema","examples":["public"],"default":"public","order":3},"user":{"type":"string","description":"The username which is used to access the database.","title":"User","order":4},"password":{"type":"string","description":"The password associated with this username.","title":"Password","airbyte_secret":true,"order":5},"jdbc_url_params":{"type":"string","description":"Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).","title":"JDBC URL Params","order":6},"ssl_method":{"oneOf":[{"title":"Unencrypted","type":"object","additionalProperties":true,"description":"The data transfer will not be encrypted.","properties":{"name":{"type":"string","enum":["unencrypted"],"default":"unencrypted"}},"required":["name"]},{"title":"Encrypted (trust server certificate)","type":"object","additionalProperties":true,"description":"Use the certificate provided by the server without verification. (For testing purposes only!)","properties":{"name":{"type":"string","enum":["encrypted_trust_server_certificate"],"default":"encrypted_trust_server_certificate"}},"required":["name"]},{"title":"Encrypted (verify certificate)","type":"object","additionalProperties":true,"description":"Verify and use the certificate provided by the server.","properties":{"name":{"type":"string","enum":["encrypted_verify_certificate"],"default":"encrypted_verify_certificate"},"trustStoreName":{"type":"string","description":"Specifies the name of the trust store.","title":"Trust Store Name","order":1},"trustStorePassword":{"type":"string","description":"Specifies the password of the trust store.","title":"Trust Store Password","airbyte_secret":true,"order":2},"hostNameInCertificate":{"type":"string","description":"Specifies the host name of the server. The value of this property must match the subject property of the certificate.","title":"Host Name In Certificate","order":3}},"required":["name"]}],"description":"The encryption method which is used to communicate with the database.","title":"SSL Method","order":7,"type":"object"},"load_type":{"oneOf":[{"title":"Insert Load","type":"object","additionalProperties":true,"description":"Configuration details for using the INSERT loading mechanism.","properties":{"load_type":{"type":"string","enum":["INSERT"],"default":"INSERT"}},"required":["load_type"]},{"title":"Bulk Load","type":"object","additionalProperties":true,"description":"Configuration details for using the BULK loading mechanism.","properties":{"load_type":{"type":"string","enum":["BULK"],"default":"BULK"},"azure_blob_storage_account_name":{"type":"string","description":"The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts","title":"Azure Blob Storage Account Name","examples":["mystorageaccount"]},"azure_blob_storage_container_name":{"type":"string","description":"The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers","title":"Azure Blob Storage Container Name","examples":["mycontainer"]},"shared_access_signature":{"type":"string","description":"A shared access signature (SAS) provides secure delegated access to resources in your storage account. See: https://learn.microsoft.com/azure/storage/common/storage-sas-overview","title":"Shared Access Signature","examples":["a012345678910ABCDEFGH/AbCdEfGhEXAMPLEKEY"],"airbyte_secret":true,"always_show":true},"bulk_load_data_source":{"type":"string","description":"Specifies the external data source name configured in MSSQL, which references the Azure Blob container. See: https://learn.microsoft.com/sql/t-sql/statements/bulk-insert-transact-sql","title":"BULK Load Data Source","examples":["MyAzureBlobStorage"],"order":4,"always_show":true},"bulk_load_validate_values_pre_load":{"type":"boolean","description":"When enabled, Airbyte will validate all values before loading them into the destination table. This provides stronger data integrity guarantees but may significantly impact performance.","title":"Pre-Load Value Validation","examples":["false"],"default":false,"order":5,"always_show":false}},"required":["load_type","azure_blob_storage_account_name","azure_blob_storage_container_name","shared_access_signature","bulk_load_data_source"]}],"description":"Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.","title":"Load Type","always_show":true,"order":8,"type":"object"}},"required":["host","port","database","schema","user","ssl_method","load_type"]},supportsIncremental=true,supportsNormalization=false,supportsDBT=false,supportedDestinationSyncModes=[overwrite, append, append_dedup],authSpecification=<null>,advancedAuth=<null>,protocolVersion=<null>,additionalProperties={}],tombstone=false,_public=true,custom=false,releaseStage=generally_available,releaseDate=<null>,resourceRequirements=<null>,protocolVersion=0.2.0,normalizationConfig=<null>,supportsDbt=<null>,allowedHosts=<null>,additionalProperties={connectorBuildOptions={baseImage=docker.io/airbyte/java-connector-base:1.0.0@sha256:be86e5684e1e6d9280512d3d8071b47153698fe08ad990949c8eeff02803201a}, connectorTestSuitesOptions=[{suite=unitTests, testSecrets=null, testConnections=null}, {suite=integrationTests, testSecrets=[{name=SECRET_DESTINATION_MSSQL_V2_BULK_LOAD_CONFIG, fileName=bulk_upload_config.json, secretStore={alias=airbyte-connector-testing-secret-store, type=GSM}}], testConnections=null}], language=java, supportLevel=certified, tags=[language:java], releases={breakingChanges={1.0.0={upgradeDeadline=2024-05-25, message=This version removes the option to use "normalization" with MSSQL. It also changes the schema and database of Airbyte's "raw" tables to be compatible with the new [Destinations V2](https://docs.airbyte.com/release_notes/upgrading_to_destinations_v2/#what-is-destinations-v2) format. These changes will likely require updates to downstream dbt / SQL models. Selecting `Upgrade` will upgrade **all** connections using this destination at their next sync.
, migrationDocumentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-migrations#1.0.0}, 2.0.0={upgradeDeadline=2025-09-11, message='This version introduces new configuration options (bulk insert via Azure Cloud Storage) and removes
the use of a raw table prior to final insertion in the destination table. These changes will either
require the execution of a truncate refresh on an existing connection or the creation of a new connection.
If a new connection is set up, you may delete the old connection and the raw table in the destination after
a successful initial sync of the new connection.
'
, migrationDocumentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-migrations#2.0.0}}, migrationDocumentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-migrations}, supportsRefreshes=true, ab_internal={sl=100, ql=100}, license=ELv2, generated={git={commit_sha=cbd55b3ff65e6f907dfa72e47b54b6f967cb5bc8, commit_timestamp=2025-03-11T16:00:29-04:00, commit_author=Jonathan Pearlin, commit_author_email=jonathan@airbyte.io}, source_file_info={metadata_etag=CKLRh/z4gowDEAE=, metadata_file_path=metadata/airbyte/destination-mssql/latest/metadata.yaml, metadata_bucket_name=prod-airbyte-cloud-connector-metadata-service, metadata_last_modified=2025-03-11T21:13:30.405000+00:00, registry_entry_generated_at=2025-03-11T21:16:51.899966}, metrics={all={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=all, connector_version=all, sync_success_rate=medium, usage=high}, cloud={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=cloud, connector_version=0.1.14, sync_success_rate=medium, usage=high}, oss={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=oss, connector_version=0.1.14, sync_success_rate=medium, usage=high}}, sbomUrl=https://connectors.airbyte.com/files/sbom/airbyte/destination-mssql/2.0.0.spdx.json}, sourceType=database, githubIssueLabel=destination-mssql, iconUrl=https://connectors.airbyte.com/files/metadata/airbyte/destination-mssql/latest/icon.svg, packageInfo={}, supportsFileTransfer=false}])
Connector Name
destination-mssql-v2
Connector Version
latest
What step the error happened?
Other
Relevant information
Got an error when check_update executes on backend.
I've looked at Docker Hub and yesterday had an update on this connector.
Airbyte version: v0.41.0 (please don't judge me... haha, update to 1.x.x incoming...)
Relevant log output
Internal Server Error: Duplicate key 37a928c1-2d5c-431a-a97d-ae236bd1ea0c (attempted merging values io.airbyte.config.StandardDestinationDefinition@2d65f7f0[destinationDefinitionId=37a928c1-2d5c-431a-a97d-ae236bd1ea0c,name=MS SQL Server V2,dockerRepository=airbyte/destination-mssql-v2,dockerImageTag=0.1.15,documentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-v2,icon=icon.svg,spec=io.airbyte.protocol.models.ConnectorSpecification@6f4a3078[documentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-v2,changelogUrl=<null>,connectionSpecification={"$schema":"http://json-schema.org/draft-07/schema#","title":"MSSQL V2 Destination Specification","type":"object","additionalProperties":true,"properties":{"host":{"type":"string","description":"The host name of the MSSQL database.","title":"Host","order":0},"port":{"type":"integer","description":"The port of the MSSQL database.","title":"Port","minimum":0,"maximum":65536,"examples":["1433"],"order":1},"database":{"type":"string","description":"The name of the MSSQL database.","title":"DB Name","order":2},"schema":{"type":"string","description":"The default schema tables are written to if the source does not specify a namespace. The usual value for this field is \"public\".","title":"Default Schema","examples":["public"],"default":"public","order":3},"user":{"type":"string","description":"The username which is used to access the database.","title":"User","order":4},"password":{"type":"string","description":"The password associated with this username.","title":"Password","airbyte_secret":true,"order":5},"jdbc_url_params":{"type":"string","description":"Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).","title":"JDBC URL Params","order":6},"ssl_method":{"oneOf":[{"title":"Unencrypted","type":"object","additionalProperties":true,"description":"The data transfer will not be encrypted.","properties":{"name":{"type":"string","enum":["unencrypted"],"default":"unencrypted"}},"required":["name"]},{"title":"Encrypted (trust server certificate)","type":"object","additionalProperties":true,"description":"Use the certificate provided by the server without verification. (For testing purposes only!)","properties":{"name":{"type":"string","enum":["encrypted_trust_server_certificate"],"default":"encrypted_trust_server_certificate"}},"required":["name"]},{"title":"Encrypted (verify certificate)","type":"object","additionalProperties":true,"description":"Verify and use the certificate provided by the server.","properties":{"name":{"type":"string","enum":["encrypted_verify_certificate"],"default":"encrypted_verify_certificate"},"trustStoreName":{"type":"string","description":"Specifies the name of the trust store.","title":"Trust Store Name","order":1},"trustStorePassword":{"type":"string","description":"Specifies the password of the trust store.","title":"Trust Store Password","airbyte_secret":true,"order":2},"hostNameInCertificate":{"type":"string","description":"Specifies the host name of the server. The value of this property must match the subject property of the certificate.","title":"Host Name In Certificate","order":3}},"required":["name"]}],"description":"The encryption method which is used to communicate with the database.","title":"SSL Method","order":7,"type":"object"},"load_type":{"oneOf":[{"title":"Insert Load","type":"object","additionalProperties":true,"description":"Configuration details for using the INSERT loading mechanism.","properties":{"load_type":{"type":"string","enum":["INSERT"],"default":"INSERT"}},"required":["load_type"]},{"title":"Bulk Load","type":"object","additionalProperties":true,"description":"Configuration details for using the BULK loading mechanism.","properties":{"load_type":{"type":"string","enum":["BULK"],"default":"BULK"},"azure_blob_storage_account_name":{"type":"string","description":"The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts","title":"Azure Blob Storage Account Name","examples":["mystorageaccount"]},"azure_blob_storage_container_name":{"type":"string","description":"The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers","title":"Azure Blob Storage Container Name","examples":["mycontainer"]},"shared_access_signature":{"type":"string","description":"A shared access signature (SAS) provides secure delegated access to resources in your storage account. See: https://learn.microsoft.com/azure/storage/common/storage-sas-overview","title":"Shared Access Signature","examples":["a012345678910ABCDEFGH/AbCdEfGhEXAMPLEKEY"],"airbyte_secret":true,"always_show":true},"bulk_load_data_source":{"type":"string","description":"Specifies the external data source name configured in MSSQL, which references the Azure Blob container. See: https://learn.microsoft.com/sql/t-sql/statements/bulk-insert-transact-sql","title":"BULK Load Data Source","examples":["MyAzureBlobStorage"],"order":4,"always_show":true},"bulk_load_validate_values_pre_load":{"type":"boolean","description":"When enabled, Airbyte will validate all values before loading them into the destination table. This provides stronger data integrity guarantees but may significantly impact performance.","title":"Pre-Load Value Validation","examples":["false"],"default":false,"order":5,"always_show":false}},"required":["load_type","azure_blob_storage_account_name","azure_blob_storage_container_name","shared_access_signature","bulk_load_data_source"]}],"description":"Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.","title":"Load Type","always_show":true,"order":8,"type":"object"}},"required":["host","port","database","schema","user","ssl_method","load_type"]},supportsIncremental=true,supportsNormalization=false,supportsDBT=false,supportedDestinationSyncModes=[overwrite, append, append_dedup],authSpecification=<null>,advancedAuth=<null>,protocolVersion=<null>,additionalProperties={}],tombstone=false,_public=true,custom=false,releaseStage=alpha,releaseDate=<null>,resourceRequirements=<null>,protocolVersion=0.2.0,normalizationConfig=<null>,supportsDbt=<null>,allowedHosts=<null>,additionalProperties={connectorBuildOptions={baseImage=docker.io/airbyte/java-connector-base:2.0.0@sha256:5a1a21c75c5e1282606de9fa539ba136520abe2fbd013058e988bb0297a9f454}, connectorTestSuitesOptions=[{suite=unitTests, testSecrets=null, testConnections=null}, {suite=integrationTests, testSecrets=[{name=SECRET_DESTINATION_MSSQL_V2_BULK_LOAD_CONFIG, fileName=bulk_upload_config.json, secretStore={alias=airbyte-connector-testing-secret-store, type=GSM}}], testConnections=null}], language=java, supportLevel=community, tags=[language:java], supportsRefreshes=true, ab_internal={sl=100, ql=100}, license=ELv2, generated={git={commit_sha=600587baa92fc46ef090e2a019ca105ca4649fd5, commit_timestamp=2025-03-10T08:35:24-07:00, commit_author=Johnny Schmidt, commit_author_email=john.schmidt@airbyte.io}, source_file_info={metadata_etag=CJrH2bXw/4sDEAE=, metadata_file_path=metadata/airbyte/destination-mssql-v2/latest/metadata.yaml, metadata_bucket_name=prod-airbyte-cloud-connector-metadata-service, metadata_last_modified=2025-03-10T15:57:16.158000+00:00, registry_entry_generated_at=2025-03-10T16:00:36.748103}, metrics={all={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=all, connector_version=all, sync_success_rate=medium, usage=high}, cloud={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=cloud, connector_version=0.1.14, sync_success_rate=medium, usage=high}, oss={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=oss, connector_version=0.1.14, sync_success_rate=medium, usage=high}}, sbomUrl=https://connectors.airbyte.com/files/sbom/airbyte/destination-mssql-v2/0.1.15.spdx.json}, sourceType=database, githubIssueLabel=destination-mssql-v2, iconUrl=https://connectors.airbyte.com/files/metadata/airbyte/destination-mssql-v2/latest/icon.svg, packageInfo={}, supportsFileTransfer=false}] and io.airbyte.config.StandardDestinationDefinition@63e33c90[destinationDefinitionId=37a928c1-2d5c-431a-a97d-ae236bd1ea0c,name=MS SQL Server,dockerRepository=airbyte/destination-mssql,dockerImageTag=2.0.0,documentationUrl=https://docs.airbyte.com/integrations/destinations/mssql,icon=icon.svg,spec=io.airbyte.protocol.models.ConnectorSpecification@6bffbecc[documentationUrl=https://docs.airbyte.com/integrations/destinations/mssql,changelogUrl=<null>,connectionSpecification={"$schema":"http://json-schema.org/draft-07/schema#","title":"MSSQL Destination Specification","type":"object","additionalProperties":true,"properties":{"host":{"type":"string","description":"The host name of the MSSQL database.","title":"Host","order":0},"port":{"type":"integer","description":"The port of the MSSQL database.","title":"Port","minimum":0,"maximum":65536,"examples":["1433"],"order":1},"database":{"type":"string","description":"The name of the MSSQL database.","title":"DB Name","order":2},"schema":{"type":"string","description":"The default schema tables are written to if the source does not specify a namespace. The usual value for this field is \"public\".","title":"Default Schema","examples":["public"],"default":"public","order":3},"user":{"type":"string","description":"The username which is used to access the database.","title":"User","order":4},"password":{"type":"string","description":"The password associated with this username.","title":"Password","airbyte_secret":true,"order":5},"jdbc_url_params":{"type":"string","description":"Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).","title":"JDBC URL Params","order":6},"ssl_method":{"oneOf":[{"title":"Unencrypted","type":"object","additionalProperties":true,"description":"The data transfer will not be encrypted.","properties":{"name":{"type":"string","enum":["unencrypted"],"default":"unencrypted"}},"required":["name"]},{"title":"Encrypted (trust server certificate)","type":"object","additionalProperties":true,"description":"Use the certificate provided by the server without verification. (For testing purposes only!)","properties":{"name":{"type":"string","enum":["encrypted_trust_server_certificate"],"default":"encrypted_trust_server_certificate"}},"required":["name"]},{"title":"Encrypted (verify certificate)","type":"object","additionalProperties":true,"description":"Verify and use the certificate provided by the server.","properties":{"name":{"type":"string","enum":["encrypted_verify_certificate"],"default":"encrypted_verify_certificate"},"trustStoreName":{"type":"string","description":"Specifies the name of the trust store.","title":"Trust Store Name","order":1},"trustStorePassword":{"type":"string","description":"Specifies the password of the trust store.","title":"Trust Store Password","airbyte_secret":true,"order":2},"hostNameInCertificate":{"type":"string","description":"Specifies the host name of the server. The value of this property must match the subject property of the certificate.","title":"Host Name In Certificate","order":3}},"required":["name"]}],"description":"The encryption method which is used to communicate with the database.","title":"SSL Method","order":7,"type":"object"},"load_type":{"oneOf":[{"title":"Insert Load","type":"object","additionalProperties":true,"description":"Configuration details for using the INSERT loading mechanism.","properties":{"load_type":{"type":"string","enum":["INSERT"],"default":"INSERT"}},"required":["load_type"]},{"title":"Bulk Load","type":"object","additionalProperties":true,"description":"Configuration details for using the BULK loading mechanism.","properties":{"load_type":{"type":"string","enum":["BULK"],"default":"BULK"},"azure_blob_storage_account_name":{"type":"string","description":"The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts","title":"Azure Blob Storage Account Name","examples":["mystorageaccount"]},"azure_blob_storage_container_name":{"type":"string","description":"The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers","title":"Azure Blob Storage Container Name","examples":["mycontainer"]},"shared_access_signature":{"type":"string","description":"A shared access signature (SAS) provides secure delegated access to resources in your storage account. See: https://learn.microsoft.com/azure/storage/common/storage-sas-overview","title":"Shared Access Signature","examples":["a012345678910ABCDEFGH/AbCdEfGhEXAMPLEKEY"],"airbyte_secret":true,"always_show":true},"bulk_load_data_source":{"type":"string","description":"Specifies the external data source name configured in MSSQL, which references the Azure Blob container. See: https://learn.microsoft.com/sql/t-sql/statements/bulk-insert-transact-sql","title":"BULK Load Data Source","examples":["MyAzureBlobStorage"],"order":4,"always_show":true},"bulk_load_validate_values_pre_load":{"type":"boolean","description":"When enabled, Airbyte will validate all values before loading them into the destination table. This provides stronger data integrity guarantees but may significantly impact performance.","title":"Pre-Load Value Validation","examples":["false"],"default":false,"order":5,"always_show":false}},"required":["load_type","azure_blob_storage_account_name","azure_blob_storage_container_name","shared_access_signature","bulk_load_data_source"]}],"description":"Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.","title":"Load Type","always_show":true,"order":8,"type":"object"}},"required":["host","port","database","schema","user","ssl_method","load_type"]},supportsIncremental=true,supportsNormalization=false,supportsDBT=false,supportedDestinationSyncModes=[overwrite, append, append_dedup],authSpecification=<null>,advancedAuth=<null>,protocolVersion=<null>,additionalProperties={}],tombstone=false,_public=true,custom=false,releaseStage=generally_available,releaseDate=<null>,resourceRequirements=<null>,protocolVersion=0.2.0,normalizationConfig=<null>,supportsDbt=<null>,allowedHosts=<null>,additionalProperties={connectorBuildOptions={baseImage=docker.io/airbyte/java-connector-base:1.0.0@sha256:be86e5684e1e6d9280512d3d8071b47153698fe08ad990949c8eeff02803201a}, connectorTestSuitesOptions=[{suite=unitTests, testSecrets=null, testConnections=null}, {suite=integrationTests, testSecrets=[{name=SECRET_DESTINATION_MSSQL_V2_BULK_LOAD_CONFIG, fileName=bulk_upload_config.json, secretStore={alias=airbyte-connector-testing-secret-store, type=GSM}}], testConnections=null}], language=java, supportLevel=certified, tags=[language:java], releases={breakingChanges={1.0.0={upgradeDeadline=2024-05-25, message=This version removes the option to use "normalization" with MSSQL. It also changes the schema and database of Airbyte's "raw" tables to be compatible with the new [Destinations V2](https://docs.airbyte.com/release_notes/upgrading_to_destinations_v2/#what-is-destinations-v2) format. These changes will likely require updates to downstream dbt / SQL models. Selecting `Upgrade` will upgrade **all** connections using this destination at their next sync. , migrationDocumentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-migrations#1.0.0}, 2.0.0={upgradeDeadline=2025-09-11, message='This version introduces new configuration options (bulk insert via Azure Cloud Storage) and removes the use of a raw table prior to final insertion in the destination table. These changes will either require the execution of a truncate refresh on an existing connection or the creation of a new connection. If a new connection is set up, you may delete the old connection and the raw table in the destination after a successful initial sync of the new connection. ' , migrationDocumentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-migrations#2.0.0}}, migrationDocumentationUrl=https://docs.airbyte.com/integrations/destinations/mssql-migrations}, supportsRefreshes=true, ab_internal={sl=100, ql=100}, license=ELv2, generated={git={commit_sha=cbd55b3ff65e6f907dfa72e47b54b6f967cb5bc8, commit_timestamp=2025-03-11T16:00:29-04:00, commit_author=Jonathan Pearlin, commit_author_email=jonathan@airbyte.io}, source_file_info={metadata_etag=CKLRh/z4gowDEAE=, metadata_file_path=metadata/airbyte/destination-mssql/latest/metadata.yaml, metadata_bucket_name=prod-airbyte-cloud-connector-metadata-service, metadata_last_modified=2025-03-11T21:13:30.405000+00:00, registry_entry_generated_at=2025-03-11T21:16:51.899966}, metrics={all={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=all, connector_version=all, sync_success_rate=medium, usage=high}, cloud={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=cloud, connector_version=0.1.14, sync_success_rate=medium, usage=high}, oss={connector_type=destination, connector_definition_id=37a928c1-2d5c-431a-a97d-ae236bd1ea0c, connector_name=MS SQL Server V2, docker_repository=airbyte/destination-mssql-v2, airbyte_platform=oss, connector_version=0.1.14, sync_success_rate=medium, usage=high}}, sbomUrl=https://connectors.airbyte.com/files/sbom/airbyte/destination-mssql/2.0.0.spdx.json}, sourceType=database, githubIssueLabel=destination-mssql, iconUrl=https://connectors.airbyte.com/files/metadata/airbyte/destination-mssql/latest/icon.svg, packageInfo={}, supportsFileTransfer=false}])Contribute