Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Airbyte Provider
  3. API Docs
  4. DestinationMssqlV2
airbyte 0.10.0 published on Monday, Apr 14, 2025 by airbytehq
airbytehq/terraform-provider-airbyte

airbyte.DestinationMssqlV2

Explore with Pulumi AI

airbyte 0.10.0 published on Monday, Apr 14, 2025 by airbytehq
airbytehq/terraform-provider-airbyte

DestinationMssqlV2 Resource

Example Usage

Coming soon!

Coming soon!

Coming soon!

Coming soon!

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.airbyte.DestinationMssqlV2;
import com.pulumi.airbyte.DestinationMssqlV2Args;
import com.pulumi.airbyte.inputs.DestinationMssqlV2ConfigurationArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var myDestinationMssqlv2 = new DestinationMssqlV2("myDestinationMssqlv2", DestinationMssqlV2Args.builder()
            .configuration(DestinationMssqlV2ConfigurationArgs.builder()
                .database("...my_database...")
                .host("...my_host...")
                .jdbc_url_params("...my_jdbc_url_params...")
                .load_type(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
                .password("...my_password...")
                .port(1433)
                .schema("public")
                .ssl_method()
                .user("...my_user...")
                .build())
            .definitionId("c9fa67bf-f0a4-4a94-a50c-0a2889bc913d")
            .workspaceId("ce5dceb6-f2b2-4d39-b087-2eee8dcc9b07")
            .build());

    }
}
Copy
resources:
  myDestinationMssqlv2:
    type: airbyte:DestinationMssqlV2
    properties:
      configuration:
        database: '...my_database...'
        host: '...my_host...'
        jdbc_url_params: '...my_jdbc_url_params...'
        load_type:
          insertLoad:
            additionalProperties: '{ "see": "documentation" }'
            loadType: INSERT
        password: '...my_password...'
        port: 1433
        schema: public
        ssl_method: {}
        user: '...my_user...'
      definitionId: c9fa67bf-f0a4-4a94-a50c-0a2889bc913d
      workspaceId: ce5dceb6-f2b2-4d39-b087-2eee8dcc9b07
Copy

Create DestinationMssqlV2 Resource

Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

Constructor syntax

new DestinationMssqlV2(name: string, args: DestinationMssqlV2Args, opts?: CustomResourceOptions);
@overload
def DestinationMssqlV2(resource_name: str,
                       args: DestinationMssqlV2Args,
                       opts: Optional[ResourceOptions] = None)

@overload
def DestinationMssqlV2(resource_name: str,
                       opts: Optional[ResourceOptions] = None,
                       configuration: Optional[DestinationMssqlV2ConfigurationArgs] = None,
                       workspace_id: Optional[str] = None,
                       definition_id: Optional[str] = None,
                       name: Optional[str] = None)
func NewDestinationMssqlV2(ctx *Context, name string, args DestinationMssqlV2Args, opts ...ResourceOption) (*DestinationMssqlV2, error)
public DestinationMssqlV2(string name, DestinationMssqlV2Args args, CustomResourceOptions? opts = null)
public DestinationMssqlV2(String name, DestinationMssqlV2Args args)
public DestinationMssqlV2(String name, DestinationMssqlV2Args args, CustomResourceOptions options)

type: airbyte:DestinationMssqlV2
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name This property is required. string
The unique name of the resource.
args This property is required. DestinationMssqlV2Args
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args This property is required. DestinationMssqlV2Args
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name This property is required. string
The unique name of the resource.
args This property is required. DestinationMssqlV2Args
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args This property is required. DestinationMssqlV2Args
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. DestinationMssqlV2Args
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

Constructor example

The following reference example uses placeholder values for all input properties.

var destinationMssqlV2Resource = new Airbyte.DestinationMssqlV2("destinationMssqlV2Resource", new()
{
    Configuration = new Airbyte.Inputs.DestinationMssqlV2ConfigurationArgs
    {
        Database = "string",
        Host = "string",
        LoadType = new Airbyte.Inputs.DestinationMssqlV2ConfigurationLoadTypeArgs
        {
            BulkLoad = new Airbyte.Inputs.DestinationMssqlV2ConfigurationLoadTypeBulkLoadArgs
            {
                AzureBlobStorageAccountName = "string",
                AzureBlobStorageContainerName = "string",
                BulkLoadDataSource = "string",
                SharedAccessSignature = "string",
                AdditionalProperties = "string",
                BulkLoadValidateValuesPreLoad = false,
                LoadType = "string",
            },
            InsertLoad = new Airbyte.Inputs.DestinationMssqlV2ConfigurationLoadTypeInsertLoadArgs
            {
                AdditionalProperties = "string",
                LoadType = "string",
            },
        },
        Port = 0,
        SslMethod = new Airbyte.Inputs.DestinationMssqlV2ConfigurationSslMethodArgs
        {
            EncryptedTrustServerCertificate = new Airbyte.Inputs.DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificateArgs
            {
                AdditionalProperties = "string",
                Name = "string",
            },
            EncryptedVerifyCertificate = new Airbyte.Inputs.DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificateArgs
            {
                AdditionalProperties = "string",
                HostNameInCertificate = "string",
                Name = "string",
                TrustStoreName = "string",
                TrustStorePassword = "string",
            },
            Unencrypted = new Airbyte.Inputs.DestinationMssqlV2ConfigurationSslMethodUnencryptedArgs
            {
                AdditionalProperties = "string",
                Name = "string",
            },
        },
        User = "string",
        JdbcUrlParams = "string",
        Password = "string",
        Schema = "string",
    },
    WorkspaceId = "string",
    DefinitionId = "string",
    Name = "string",
});
Copy
example, err := airbyte.NewDestinationMssqlV2(ctx, "destinationMssqlV2Resource", &airbyte.DestinationMssqlV2Args{
Configuration: &.DestinationMssqlV2ConfigurationArgs{
Database: pulumi.String("string"),
Host: pulumi.String("string"),
LoadType: &.DestinationMssqlV2ConfigurationLoadTypeArgs{
BulkLoad: &.DestinationMssqlV2ConfigurationLoadTypeBulkLoadArgs{
AzureBlobStorageAccountName: pulumi.String("string"),
AzureBlobStorageContainerName: pulumi.String("string"),
BulkLoadDataSource: pulumi.String("string"),
SharedAccessSignature: pulumi.String("string"),
AdditionalProperties: pulumi.String("string"),
BulkLoadValidateValuesPreLoad: pulumi.Bool(false),
LoadType: pulumi.String("string"),
},
InsertLoad: &.DestinationMssqlV2ConfigurationLoadTypeInsertLoadArgs{
AdditionalProperties: pulumi.String("string"),
LoadType: pulumi.String("string"),
},
},
Port: pulumi.Float64(0),
SslMethod: &.DestinationMssqlV2ConfigurationSslMethodArgs{
EncryptedTrustServerCertificate: &.DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificateArgs{
AdditionalProperties: pulumi.String("string"),
Name: pulumi.String("string"),
},
EncryptedVerifyCertificate: &.DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificateArgs{
AdditionalProperties: pulumi.String("string"),
HostNameInCertificate: pulumi.String("string"),
Name: pulumi.String("string"),
TrustStoreName: pulumi.String("string"),
TrustStorePassword: pulumi.String("string"),
},
Unencrypted: &.DestinationMssqlV2ConfigurationSslMethodUnencryptedArgs{
AdditionalProperties: pulumi.String("string"),
Name: pulumi.String("string"),
},
},
User: pulumi.String("string"),
JdbcUrlParams: pulumi.String("string"),
Password: pulumi.String("string"),
Schema: pulumi.String("string"),
},
WorkspaceId: pulumi.String("string"),
DefinitionId: pulumi.String("string"),
Name: pulumi.String("string"),
})
Copy
var destinationMssqlV2Resource = new DestinationMssqlV2("destinationMssqlV2Resource", DestinationMssqlV2Args.builder()
    .configuration(DestinationMssqlV2ConfigurationArgs.builder()
        .database("string")
        .host("string")
        .loadType(DestinationMssqlV2ConfigurationLoadTypeArgs.builder()
            .bulkLoad(DestinationMssqlV2ConfigurationLoadTypeBulkLoadArgs.builder()
                .azureBlobStorageAccountName("string")
                .azureBlobStorageContainerName("string")
                .bulkLoadDataSource("string")
                .sharedAccessSignature("string")
                .additionalProperties("string")
                .bulkLoadValidateValuesPreLoad(false)
                .loadType("string")
                .build())
            .insertLoad(DestinationMssqlV2ConfigurationLoadTypeInsertLoadArgs.builder()
                .additionalProperties("string")
                .loadType("string")
                .build())
            .build())
        .port(0)
        .sslMethod(DestinationMssqlV2ConfigurationSslMethodArgs.builder()
            .encryptedTrustServerCertificate(DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificateArgs.builder()
                .additionalProperties("string")
                .name("string")
                .build())
            .encryptedVerifyCertificate(DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificateArgs.builder()
                .additionalProperties("string")
                .hostNameInCertificate("string")
                .name("string")
                .trustStoreName("string")
                .trustStorePassword("string")
                .build())
            .unencrypted(DestinationMssqlV2ConfigurationSslMethodUnencryptedArgs.builder()
                .additionalProperties("string")
                .name("string")
                .build())
            .build())
        .user("string")
        .jdbcUrlParams("string")
        .password("string")
        .schema("string")
        .build())
    .workspaceId("string")
    .definitionId("string")
    .name("string")
    .build());
Copy
destination_mssql_v2_resource = airbyte.DestinationMssqlV2("destinationMssqlV2Resource",
    configuration={
        "database": "string",
        "host": "string",
        "load_type": {
            "bulk_load": {
                "azure_blob_storage_account_name": "string",
                "azure_blob_storage_container_name": "string",
                "bulk_load_data_source": "string",
                "shared_access_signature": "string",
                "additional_properties": "string",
                "bulk_load_validate_values_pre_load": False,
                "load_type": "string",
            },
            "insert_load": {
                "additional_properties": "string",
                "load_type": "string",
            },
        },
        "port": 0,
        "ssl_method": {
            "encrypted_trust_server_certificate": {
                "additional_properties": "string",
                "name": "string",
            },
            "encrypted_verify_certificate": {
                "additional_properties": "string",
                "host_name_in_certificate": "string",
                "name": "string",
                "trust_store_name": "string",
                "trust_store_password": "string",
            },
            "unencrypted": {
                "additional_properties": "string",
                "name": "string",
            },
        },
        "user": "string",
        "jdbc_url_params": "string",
        "password": "string",
        "schema": "string",
    },
    workspace_id="string",
    definition_id="string",
    name="string")
Copy
const destinationMssqlV2Resource = new airbyte.DestinationMssqlV2("destinationMssqlV2Resource", {
    configuration: {
        database: "string",
        host: "string",
        loadType: {
            bulkLoad: {
                azureBlobStorageAccountName: "string",
                azureBlobStorageContainerName: "string",
                bulkLoadDataSource: "string",
                sharedAccessSignature: "string",
                additionalProperties: "string",
                bulkLoadValidateValuesPreLoad: false,
                loadType: "string",
            },
            insertLoad: {
                additionalProperties: "string",
                loadType: "string",
            },
        },
        port: 0,
        sslMethod: {
            encryptedTrustServerCertificate: {
                additionalProperties: "string",
                name: "string",
            },
            encryptedVerifyCertificate: {
                additionalProperties: "string",
                hostNameInCertificate: "string",
                name: "string",
                trustStoreName: "string",
                trustStorePassword: "string",
            },
            unencrypted: {
                additionalProperties: "string",
                name: "string",
            },
        },
        user: "string",
        jdbcUrlParams: "string",
        password: "string",
        schema: "string",
    },
    workspaceId: "string",
    definitionId: "string",
    name: "string",
});
Copy
type: airbyte:DestinationMssqlV2
properties:
    configuration:
        database: string
        host: string
        jdbcUrlParams: string
        loadType:
            bulkLoad:
                additionalProperties: string
                azureBlobStorageAccountName: string
                azureBlobStorageContainerName: string
                bulkLoadDataSource: string
                bulkLoadValidateValuesPreLoad: false
                loadType: string
                sharedAccessSignature: string
            insertLoad:
                additionalProperties: string
                loadType: string
        password: string
        port: 0
        schema: string
        sslMethod:
            encryptedTrustServerCertificate:
                additionalProperties: string
                name: string
            encryptedVerifyCertificate:
                additionalProperties: string
                hostNameInCertificate: string
                name: string
                trustStoreName: string
                trustStorePassword: string
            unencrypted:
                additionalProperties: string
                name: string
        user: string
    definitionId: string
    name: string
    workspaceId: string
Copy

DestinationMssqlV2 Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

The DestinationMssqlV2 resource accepts the following input properties:

Configuration This property is required. DestinationMssqlV2Configuration
WorkspaceId This property is required. string
DefinitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
Name string
Name of the destination e.g. dev-mysql-instance.
Configuration This property is required. DestinationMssqlV2ConfigurationArgs
WorkspaceId This property is required. string
DefinitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
Name string
Name of the destination e.g. dev-mysql-instance.
configuration This property is required. DestinationMssqlV2Configuration
workspaceId This property is required. String
definitionId String
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name String
Name of the destination e.g. dev-mysql-instance.
configuration This property is required. DestinationMssqlV2Configuration
workspaceId This property is required. string
definitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name string
Name of the destination e.g. dev-mysql-instance.
configuration This property is required. DestinationMssqlV2ConfigurationArgs
workspace_id This property is required. str
definition_id str
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name str
Name of the destination e.g. dev-mysql-instance.
configuration This property is required. Property Map
workspaceId This property is required. String
definitionId String
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
name String
Name of the destination e.g. dev-mysql-instance.

Outputs

All input properties are implicitly available as output properties. Additionally, the DestinationMssqlV2 resource produces the following output properties:

CreatedAt double
DestinationId string
DestinationType string
Id string
The provider-assigned unique ID for this managed resource.
ResourceAllocation DestinationMssqlV2ResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
CreatedAt float64
DestinationId string
DestinationType string
Id string
The provider-assigned unique ID for this managed resource.
ResourceAllocation DestinationMssqlV2ResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
createdAt Double
destinationId String
destinationType String
id String
The provider-assigned unique ID for this managed resource.
resourceAllocation DestinationMssqlV2ResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
createdAt number
destinationId string
destinationType string
id string
The provider-assigned unique ID for this managed resource.
resourceAllocation DestinationMssqlV2ResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
created_at float
destination_id str
destination_type str
id str
The provider-assigned unique ID for this managed resource.
resource_allocation DestinationMssqlV2ResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
createdAt Number
destinationId String
destinationType String
id String
The provider-assigned unique ID for this managed resource.
resourceAllocation Property Map
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.

Look up Existing DestinationMssqlV2 Resource

Get an existing DestinationMssqlV2 resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: DestinationMssqlV2State, opts?: CustomResourceOptions): DestinationMssqlV2
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        configuration: Optional[DestinationMssqlV2ConfigurationArgs] = None,
        created_at: Optional[float] = None,
        definition_id: Optional[str] = None,
        destination_id: Optional[str] = None,
        destination_type: Optional[str] = None,
        name: Optional[str] = None,
        resource_allocation: Optional[DestinationMssqlV2ResourceAllocationArgs] = None,
        workspace_id: Optional[str] = None) -> DestinationMssqlV2
func GetDestinationMssqlV2(ctx *Context, name string, id IDInput, state *DestinationMssqlV2State, opts ...ResourceOption) (*DestinationMssqlV2, error)
public static DestinationMssqlV2 Get(string name, Input<string> id, DestinationMssqlV2State? state, CustomResourceOptions? opts = null)
public static DestinationMssqlV2 get(String name, Output<String> id, DestinationMssqlV2State state, CustomResourceOptions options)
resources:  _:    type: airbyte:DestinationMssqlV2    get:      id: ${id}
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
resource_name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
Configuration DestinationMssqlV2Configuration
CreatedAt double
DefinitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
DestinationId string
DestinationType string
Name string
Name of the destination e.g. dev-mysql-instance.
ResourceAllocation DestinationMssqlV2ResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
WorkspaceId string
Configuration DestinationMssqlV2ConfigurationArgs
CreatedAt float64
DefinitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
DestinationId string
DestinationType string
Name string
Name of the destination e.g. dev-mysql-instance.
ResourceAllocation DestinationMssqlV2ResourceAllocationArgs
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
WorkspaceId string
configuration DestinationMssqlV2Configuration
createdAt Double
definitionId String
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
destinationId String
destinationType String
name String
Name of the destination e.g. dev-mysql-instance.
resourceAllocation DestinationMssqlV2ResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
workspaceId String
configuration DestinationMssqlV2Configuration
createdAt number
definitionId string
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
destinationId string
destinationType string
name string
Name of the destination e.g. dev-mysql-instance.
resourceAllocation DestinationMssqlV2ResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
workspaceId string
configuration DestinationMssqlV2ConfigurationArgs
created_at float
definition_id str
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
destination_id str
destination_type str
name str
Name of the destination e.g. dev-mysql-instance.
resource_allocation DestinationMssqlV2ResourceAllocationArgs
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
workspace_id str
configuration Property Map
createdAt Number
definitionId String
The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
destinationId String
destinationType String
name String
Name of the destination e.g. dev-mysql-instance.
resourceAllocation Property Map
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
workspaceId String

Supporting Types

DestinationMssqlV2Configuration
, DestinationMssqlV2ConfigurationArgs

Database This property is required. string
The name of the MSSQL database.
Host This property is required. string
The host name of the MSSQL database.
LoadType This property is required. DestinationMssqlV2ConfigurationLoadType
Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
Port This property is required. double
The port of the MSSQL database.
SslMethod This property is required. DestinationMssqlV2ConfigurationSslMethod
The encryption method which is used to communicate with the database.
User This property is required. string
The username which is used to access the database.
JdbcUrlParams string
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).
Password string
The password associated with this username.
Schema string
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
Database This property is required. string
The name of the MSSQL database.
Host This property is required. string
The host name of the MSSQL database.
LoadType This property is required. DestinationMssqlV2ConfigurationLoadType
Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
Port This property is required. float64
The port of the MSSQL database.
SslMethod This property is required. DestinationMssqlV2ConfigurationSslMethod
The encryption method which is used to communicate with the database.
User This property is required. string
The username which is used to access the database.
JdbcUrlParams string
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).
Password string
The password associated with this username.
Schema string
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
database This property is required. String
The name of the MSSQL database.
host This property is required. String
The host name of the MSSQL database.
loadType This property is required. DestinationMssqlV2ConfigurationLoadType
Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
port This property is required. Double
The port of the MSSQL database.
sslMethod This property is required. DestinationMssqlV2ConfigurationSslMethod
The encryption method which is used to communicate with the database.
user This property is required. String
The username which is used to access the database.
jdbcUrlParams String
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).
password String
The password associated with this username.
schema String
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
database This property is required. string
The name of the MSSQL database.
host This property is required. string
The host name of the MSSQL database.
loadType This property is required. DestinationMssqlV2ConfigurationLoadType
Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
port This property is required. number
The port of the MSSQL database.
sslMethod This property is required. DestinationMssqlV2ConfigurationSslMethod
The encryption method which is used to communicate with the database.
user This property is required. string
The username which is used to access the database.
jdbcUrlParams string
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).
password string
The password associated with this username.
schema string
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
database This property is required. str
The name of the MSSQL database.
host This property is required. str
The host name of the MSSQL database.
load_type This property is required. DestinationMssqlV2ConfigurationLoadType
Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
port This property is required. float
The port of the MSSQL database.
ssl_method This property is required. DestinationMssqlV2ConfigurationSslMethod
The encryption method which is used to communicate with the database.
user This property is required. str
The username which is used to access the database.
jdbc_url_params str
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).
password str
The password associated with this username.
schema str
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"
database This property is required. String
The name of the MSSQL database.
host This property is required. String
The host name of the MSSQL database.
loadType This property is required. Property Map
Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
port This property is required. Number
The port of the MSSQL database.
sslMethod This property is required. Property Map
The encryption method which is used to communicate with the database.
user This property is required. String
The username which is used to access the database.
jdbcUrlParams String
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).
password String
The password associated with this username.
schema String
The default schema tables are written to if the source does not specify a namespace. The usual value for this field is "public". Default: "public"

DestinationMssqlV2ConfigurationLoadType
, DestinationMssqlV2ConfigurationLoadTypeArgs

BulkLoad DestinationMssqlV2ConfigurationLoadTypeBulkLoad
Configuration details for using the BULK loading mechanism.
InsertLoad DestinationMssqlV2ConfigurationLoadTypeInsertLoad
Configuration details for using the INSERT loading mechanism.
BulkLoad DestinationMssqlV2ConfigurationLoadTypeBulkLoad
Configuration details for using the BULK loading mechanism.
InsertLoad DestinationMssqlV2ConfigurationLoadTypeInsertLoad
Configuration details for using the INSERT loading mechanism.
bulkLoad DestinationMssqlV2ConfigurationLoadTypeBulkLoad
Configuration details for using the BULK loading mechanism.
insertLoad DestinationMssqlV2ConfigurationLoadTypeInsertLoad
Configuration details for using the INSERT loading mechanism.
bulkLoad DestinationMssqlV2ConfigurationLoadTypeBulkLoad
Configuration details for using the BULK loading mechanism.
insertLoad DestinationMssqlV2ConfigurationLoadTypeInsertLoad
Configuration details for using the INSERT loading mechanism.
bulk_load DestinationMssqlV2ConfigurationLoadTypeBulkLoad
Configuration details for using the BULK loading mechanism.
insert_load DestinationMssqlV2ConfigurationLoadTypeInsertLoad
Configuration details for using the INSERT loading mechanism.
bulkLoad Property Map
Configuration details for using the BULK loading mechanism.
insertLoad Property Map
Configuration details for using the INSERT loading mechanism.

DestinationMssqlV2ConfigurationLoadTypeBulkLoad
, DestinationMssqlV2ConfigurationLoadTypeBulkLoadArgs

AzureBlobStorageAccountName This property is required. string
The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
AzureBlobStorageContainerName This property is required. string
The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
BulkLoadDataSource This property is required. string
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
SharedAccessSignature This property is required. string
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
AdditionalProperties string
Parsed as JSON.
BulkLoadValidateValuesPreLoad bool
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. Default: false
LoadType string
Default: "BULK"; must be "BULK"
AzureBlobStorageAccountName This property is required. string
The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
AzureBlobStorageContainerName This property is required. string
The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
BulkLoadDataSource This property is required. string
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
SharedAccessSignature This property is required. string
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
AdditionalProperties string
Parsed as JSON.
BulkLoadValidateValuesPreLoad bool
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. Default: false
LoadType string
Default: "BULK"; must be "BULK"
azureBlobStorageAccountName This property is required. String
The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
azureBlobStorageContainerName This property is required. String
The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
bulkLoadDataSource This property is required. String
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
sharedAccessSignature This property is required. String
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
additionalProperties String
Parsed as JSON.
bulkLoadValidateValuesPreLoad Boolean
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. Default: false
loadType String
Default: "BULK"; must be "BULK"
azureBlobStorageAccountName This property is required. string
The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
azureBlobStorageContainerName This property is required. string
The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
bulkLoadDataSource This property is required. string
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
sharedAccessSignature This property is required. string
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
additionalProperties string
Parsed as JSON.
bulkLoadValidateValuesPreLoad boolean
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. Default: false
loadType string
Default: "BULK"; must be "BULK"
azure_blob_storage_account_name This property is required. str
The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
azure_blob_storage_container_name This property is required. str
The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
bulk_load_data_source This property is required. str
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
shared_access_signature This property is required. str
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
additional_properties str
Parsed as JSON.
bulk_load_validate_values_pre_load bool
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. Default: false
load_type str
Default: "BULK"; must be "BULK"
azureBlobStorageAccountName This property is required. String
The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
azureBlobStorageContainerName This property is required. String
The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
bulkLoadDataSource This property is required. String
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
sharedAccessSignature This property is required. String
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
additionalProperties String
Parsed as JSON.
bulkLoadValidateValuesPreLoad Boolean
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. Default: false
loadType String
Default: "BULK"; must be "BULK"

DestinationMssqlV2ConfigurationLoadTypeInsertLoad
, DestinationMssqlV2ConfigurationLoadTypeInsertLoadArgs

AdditionalProperties string
Parsed as JSON.
LoadType string
Default: "INSERT"; must be "INSERT"
AdditionalProperties string
Parsed as JSON.
LoadType string
Default: "INSERT"; must be "INSERT"
additionalProperties String
Parsed as JSON.
loadType String
Default: "INSERT"; must be "INSERT"
additionalProperties string
Parsed as JSON.
loadType string
Default: "INSERT"; must be "INSERT"
additional_properties str
Parsed as JSON.
load_type str
Default: "INSERT"; must be "INSERT"
additionalProperties String
Parsed as JSON.
loadType String
Default: "INSERT"; must be "INSERT"

DestinationMssqlV2ConfigurationSslMethod
, DestinationMssqlV2ConfigurationSslMethodArgs

EncryptedTrustServerCertificate DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificate
Use the certificate provided by the server without verification. (For testing purposes only!)
EncryptedVerifyCertificate DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificate
Verify and use the certificate provided by the server.
Unencrypted DestinationMssqlV2ConfigurationSslMethodUnencrypted
The data transfer will not be encrypted.
EncryptedTrustServerCertificate DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificate
Use the certificate provided by the server without verification. (For testing purposes only!)
EncryptedVerifyCertificate DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificate
Verify and use the certificate provided by the server.
Unencrypted DestinationMssqlV2ConfigurationSslMethodUnencrypted
The data transfer will not be encrypted.
encryptedTrustServerCertificate DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificate
Use the certificate provided by the server without verification. (For testing purposes only!)
encryptedVerifyCertificate DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificate
Verify and use the certificate provided by the server.
unencrypted DestinationMssqlV2ConfigurationSslMethodUnencrypted
The data transfer will not be encrypted.
encryptedTrustServerCertificate DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificate
Use the certificate provided by the server without verification. (For testing purposes only!)
encryptedVerifyCertificate DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificate
Verify and use the certificate provided by the server.
unencrypted DestinationMssqlV2ConfigurationSslMethodUnencrypted
The data transfer will not be encrypted.
encrypted_trust_server_certificate DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificate
Use the certificate provided by the server without verification. (For testing purposes only!)
encrypted_verify_certificate DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificate
Verify and use the certificate provided by the server.
unencrypted DestinationMssqlV2ConfigurationSslMethodUnencrypted
The data transfer will not be encrypted.
encryptedTrustServerCertificate Property Map
Use the certificate provided by the server without verification. (For testing purposes only!)
encryptedVerifyCertificate Property Map
Verify and use the certificate provided by the server.
unencrypted Property Map
The data transfer will not be encrypted.

DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificate
, DestinationMssqlV2ConfigurationSslMethodEncryptedTrustServerCertificateArgs

AdditionalProperties string
Parsed as JSON.
Name string
Default: "encryptedtrustservercertificate"; must be "encryptedtrustservercertificate"
AdditionalProperties string
Parsed as JSON.
Name string
Default: "encryptedtrustservercertificate"; must be "encryptedtrustservercertificate"
additionalProperties String
Parsed as JSON.
name String
Default: "encryptedtrustservercertificate"; must be "encryptedtrustservercertificate"
additionalProperties string
Parsed as JSON.
name string
Default: "encryptedtrustservercertificate"; must be "encryptedtrustservercertificate"
additional_properties str
Parsed as JSON.
name str
Default: "encryptedtrustservercertificate"; must be "encryptedtrustservercertificate"
additionalProperties String
Parsed as JSON.
name String
Default: "encryptedtrustservercertificate"; must be "encryptedtrustservercertificate"

DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificate
, DestinationMssqlV2ConfigurationSslMethodEncryptedVerifyCertificateArgs

AdditionalProperties string
Parsed as JSON.
HostNameInCertificate string
Specifies the host name of the server. The value of this property must match the subject property of the certificate.
Name string
Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
TrustStoreName string
Specifies the name of the trust store.
TrustStorePassword string
Specifies the password of the trust store.
AdditionalProperties string
Parsed as JSON.
HostNameInCertificate string
Specifies the host name of the server. The value of this property must match the subject property of the certificate.
Name string
Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
TrustStoreName string
Specifies the name of the trust store.
TrustStorePassword string
Specifies the password of the trust store.
additionalProperties String
Parsed as JSON.
hostNameInCertificate String
Specifies the host name of the server. The value of this property must match the subject property of the certificate.
name String
Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
trustStoreName String
Specifies the name of the trust store.
trustStorePassword String
Specifies the password of the trust store.
additionalProperties string
Parsed as JSON.
hostNameInCertificate string
Specifies the host name of the server. The value of this property must match the subject property of the certificate.
name string
Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
trustStoreName string
Specifies the name of the trust store.
trustStorePassword string
Specifies the password of the trust store.
additional_properties str
Parsed as JSON.
host_name_in_certificate str
Specifies the host name of the server. The value of this property must match the subject property of the certificate.
name str
Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
trust_store_name str
Specifies the name of the trust store.
trust_store_password str
Specifies the password of the trust store.
additionalProperties String
Parsed as JSON.
hostNameInCertificate String
Specifies the host name of the server. The value of this property must match the subject property of the certificate.
name String
Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
trustStoreName String
Specifies the name of the trust store.
trustStorePassword String
Specifies the password of the trust store.

DestinationMssqlV2ConfigurationSslMethodUnencrypted
, DestinationMssqlV2ConfigurationSslMethodUnencryptedArgs

AdditionalProperties string
Parsed as JSON.
Name string
Default: "unencrypted"; must be "unencrypted"
AdditionalProperties string
Parsed as JSON.
Name string
Default: "unencrypted"; must be "unencrypted"
additionalProperties String
Parsed as JSON.
name String
Default: "unencrypted"; must be "unencrypted"
additionalProperties string
Parsed as JSON.
name string
Default: "unencrypted"; must be "unencrypted"
additional_properties str
Parsed as JSON.
name str
Default: "unencrypted"; must be "unencrypted"
additionalProperties String
Parsed as JSON.
name String
Default: "unencrypted"; must be "unencrypted"

DestinationMssqlV2ResourceAllocation
, DestinationMssqlV2ResourceAllocationArgs

Default DestinationMssqlV2ResourceAllocationDefault
optional resource requirements to run workers (blank for unbounded allocations)
JobSpecifics List<DestinationMssqlV2ResourceAllocationJobSpecific>
Default DestinationMssqlV2ResourceAllocationDefault
optional resource requirements to run workers (blank for unbounded allocations)
JobSpecifics []DestinationMssqlV2ResourceAllocationJobSpecific
default_ DestinationMssqlV2ResourceAllocationDefault
optional resource requirements to run workers (blank for unbounded allocations)
jobSpecifics List<DestinationMssqlV2ResourceAllocationJobSpecific>
default DestinationMssqlV2ResourceAllocationDefault
optional resource requirements to run workers (blank for unbounded allocations)
jobSpecifics DestinationMssqlV2ResourceAllocationJobSpecific[]
default DestinationMssqlV2ResourceAllocationDefault
optional resource requirements to run workers (blank for unbounded allocations)
job_specifics Sequence[DestinationMssqlV2ResourceAllocationJobSpecific]
default Property Map
optional resource requirements to run workers (blank for unbounded allocations)
jobSpecifics List<Property Map>

DestinationMssqlV2ResourceAllocationDefault
, DestinationMssqlV2ResourceAllocationDefaultArgs

DestinationMssqlV2ResourceAllocationJobSpecific
, DestinationMssqlV2ResourceAllocationJobSpecificArgs

JobType string
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
ResourceRequirements DestinationMssqlV2ResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
JobType string
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
ResourceRequirements DestinationMssqlV2ResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
jobType String
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
resourceRequirements DestinationMssqlV2ResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
jobType string
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
resourceRequirements DestinationMssqlV2ResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
job_type str
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
resource_requirements DestinationMssqlV2ResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
jobType String
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
resourceRequirements Property Map
optional resource requirements to run workers (blank for unbounded allocations)

DestinationMssqlV2ResourceAllocationJobSpecificResourceRequirements
, DestinationMssqlV2ResourceAllocationJobSpecificResourceRequirementsArgs

Import

$ pulumi import airbyte:index/destinationMssqlV2:DestinationMssqlV2 my_airbyte_destination_mssql_v2 ""
Copy

To learn more about importing existing cloud resources, see Importing resources.

Package Details

Repository
airbyte airbytehq/terraform-provider-airbyte
License
Notes
This Pulumi package is based on the airbyte Terraform Provider.
airbyte 0.10.0 published on Monday, Apr 14, 2025 by airbytehq
airbytehq/terraform-provider-airbyte