airbyte 0.8.0-beta2, Mar 27 25

airbyte 0.8.0-beta2 published on Thursday, Mar 27, 2025 by airbytehq

airbyte.DestinationMssql

Explore with Pulumi AI

airbyte 0.8.0-beta2 published on Thursday, Mar 27, 2025 by airbytehq

Create DestinationMssql Resource

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

Constructor syntax

new DestinationMssql(name: string, args: DestinationMssqlArgs, opts?: CustomResourceOptions);

@overload
def DestinationMssql(resource_name: str,
                     args: DestinationMssqlArgs,
                     opts: Optional[ResourceOptions] = None)

@overload
def DestinationMssql(resource_name: str,
                     opts: Optional[ResourceOptions] = None,
                     configuration: Optional[DestinationMssqlConfigurationArgs] = None,
                     workspace_id: Optional[str] = None,
                     definition_id: Optional[str] = None,
                     name: Optional[str] = None)

func NewDestinationMssql(ctx *Context, name string, args DestinationMssqlArgs, opts ...ResourceOption) (*DestinationMssql, error)

public DestinationMssql(string name, DestinationMssqlArgs args, CustomResourceOptions? opts = null)

public DestinationMssql(String name, DestinationMssqlArgs args)
public DestinationMssql(String name, DestinationMssqlArgs args, CustomResourceOptions options)

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

Parameters

name string: The unique name of the resource.
args DestinationMssqlArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

resource_name str: The unique name of the resource.
args DestinationMssqlArgs: The arguments to resource properties.
opts ResourceOptions: Bag of options to control resource's behavior.

ctx Context: Context object for the current deployment.
name string: The unique name of the resource.
args DestinationMssqlArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args DestinationMssqlArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args DestinationMssqlArgs: 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 destinationMssqlResource = new Airbyte.DestinationMssql("destinationMssqlResource", new()
{
    Configuration = new Airbyte.Inputs.DestinationMssqlConfigurationArgs
    {
        Database = "string",
        Host = "string",
        LoadType = new Airbyte.Inputs.DestinationMssqlConfigurationLoadTypeArgs
        {
            BulkLoad = new Airbyte.Inputs.DestinationMssqlConfigurationLoadTypeBulkLoadArgs
            {
                AzureBlobStorageAccountName = "string",
                AzureBlobStorageContainerName = "string",
                BulkLoadDataSource = "string",
                SharedAccessSignature = "string",
                AdditionalProperties = "string",
                BulkLoadValidateValuesPreLoad = false,
                LoadType = "string",
            },
            InsertLoad = new Airbyte.Inputs.DestinationMssqlConfigurationLoadTypeInsertLoadArgs
            {
                AdditionalProperties = "string",
                LoadType = "string",
            },
        },
        Port = 0,
        SslMethod = new Airbyte.Inputs.DestinationMssqlConfigurationSslMethodArgs
        {
            EncryptedTrustServerCertificate = new Airbyte.Inputs.DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificateArgs
            {
                AdditionalProperties = "string",
                Name = "string",
            },
            EncryptedVerifyCertificate = new Airbyte.Inputs.DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs
            {
                AdditionalProperties = "string",
                HostNameInCertificate = "string",
                Name = "string",
                TrustStoreName = "string",
                TrustStorePassword = "string",
            },
            Unencrypted = new Airbyte.Inputs.DestinationMssqlConfigurationSslMethodUnencryptedArgs
            {
                AdditionalProperties = "string",
                Name = "string",
            },
        },
        User = "string",
        JdbcUrlParams = "string",
        Password = "string",
        Schema = "string",
    },
    WorkspaceId = "string",
    DefinitionId = "string",
    Name = "string",
});

example, err := airbyte.NewDestinationMssql(ctx, "destinationMssqlResource", &airbyte.DestinationMssqlArgs{
Configuration: &.DestinationMssqlConfigurationArgs{
Database: pulumi.String("string"),
Host: pulumi.String("string"),
LoadType: &.DestinationMssqlConfigurationLoadTypeArgs{
BulkLoad: &.DestinationMssqlConfigurationLoadTypeBulkLoadArgs{
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: &.DestinationMssqlConfigurationLoadTypeInsertLoadArgs{
AdditionalProperties: pulumi.String("string"),
LoadType: pulumi.String("string"),
},
},
Port: pulumi.Float64(0),
SslMethod: &.DestinationMssqlConfigurationSslMethodArgs{
EncryptedTrustServerCertificate: &.DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificateArgs{
AdditionalProperties: pulumi.String("string"),
Name: pulumi.String("string"),
},
EncryptedVerifyCertificate: &.DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs{
AdditionalProperties: pulumi.String("string"),
HostNameInCertificate: pulumi.String("string"),
Name: pulumi.String("string"),
TrustStoreName: pulumi.String("string"),
TrustStorePassword: pulumi.String("string"),
},
Unencrypted: &.DestinationMssqlConfigurationSslMethodUnencryptedArgs{
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"),
})

var destinationMssqlResource = new DestinationMssql("destinationMssqlResource", DestinationMssqlArgs.builder()
    .configuration(DestinationMssqlConfigurationArgs.builder()
        .database("string")
        .host("string")
        .loadType(DestinationMssqlConfigurationLoadTypeArgs.builder()
            .bulkLoad(DestinationMssqlConfigurationLoadTypeBulkLoadArgs.builder()
                .azureBlobStorageAccountName("string")
                .azureBlobStorageContainerName("string")
                .bulkLoadDataSource("string")
                .sharedAccessSignature("string")
                .additionalProperties("string")
                .bulkLoadValidateValuesPreLoad(false)
                .loadType("string")
                .build())
            .insertLoad(DestinationMssqlConfigurationLoadTypeInsertLoadArgs.builder()
                .additionalProperties("string")
                .loadType("string")
                .build())
            .build())
        .port(0)
        .sslMethod(DestinationMssqlConfigurationSslMethodArgs.builder()
            .encryptedTrustServerCertificate(DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificateArgs.builder()
                .additionalProperties("string")
                .name("string")
                .build())
            .encryptedVerifyCertificate(DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs.builder()
                .additionalProperties("string")
                .hostNameInCertificate("string")
                .name("string")
                .trustStoreName("string")
                .trustStorePassword("string")
                .build())
            .unencrypted(DestinationMssqlConfigurationSslMethodUnencryptedArgs.builder()
                .additionalProperties("string")
                .name("string")
                .build())
            .build())
        .user("string")
        .jdbcUrlParams("string")
        .password("string")
        .schema("string")
        .build())
    .workspaceId("string")
    .definitionId("string")
    .name("string")
    .build());

destination_mssql_resource = airbyte.DestinationMssql("destinationMssqlResource",
    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")

const destinationMssqlResource = new airbyte.DestinationMssql("destinationMssqlResource", {
    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",
});

type: airbyte:DestinationMssql
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

DestinationMssql 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 DestinationMssql resource accepts the following input properties:

Configuration DestinationMssqlConfiguration
WorkspaceId 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 DestinationMssqlConfigurationArgs
WorkspaceId 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 DestinationMssqlConfiguration
workspaceId 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 DestinationMssqlConfiguration
workspaceId 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 DestinationMssqlConfigurationArgs
workspace_id 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 Property Map
workspaceId 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 DestinationMssql resource produces the following output properties:

CreatedAt double
DestinationId string
DestinationType string
Id string: The provider-assigned unique ID for this managed resource.
ResourceAllocation DestinationMssqlResourceAllocation: 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 DestinationMssqlResourceAllocation: 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 DestinationMssqlResourceAllocation: 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 DestinationMssqlResourceAllocation: 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 DestinationMssqlResourceAllocation: 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 DestinationMssql Resource

Get an existing DestinationMssql 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?: DestinationMssqlState, opts?: CustomResourceOptions): DestinationMssql

@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        configuration: Optional[DestinationMssqlConfigurationArgs] = 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[DestinationMssqlResourceAllocationArgs] = None,
        workspace_id: Optional[str] = None) -> DestinationMssql

func GetDestinationMssql(ctx *Context, name string, id IDInput, state *DestinationMssqlState, opts ...ResourceOption) (*DestinationMssql, error)

public static DestinationMssql Get(string name, Input<string> id, DestinationMssqlState? state, CustomResourceOptions? opts = null)

public static DestinationMssql get(String name, Output<String> id, DestinationMssqlState state, CustomResourceOptions options)

resources:  _:    type: airbyte:DestinationMssql    get:      id: ${id}

name: The unique name of the resulting resource.
id: 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: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.

name: The unique name of the resulting resource.
id: 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: The unique name of the resulting resource.
id: 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: The unique name of the resulting resource.
id: 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 DestinationMssqlConfiguration
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 DestinationMssqlResourceAllocation: 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 DestinationMssqlConfigurationArgs
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 DestinationMssqlResourceAllocationArgs: 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 DestinationMssqlConfiguration
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 DestinationMssqlResourceAllocation: 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 DestinationMssqlConfiguration
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 DestinationMssqlResourceAllocation: 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 DestinationMssqlConfigurationArgs
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 DestinationMssqlResourceAllocationArgs: 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

DestinationMssqlConfiguration, DestinationMssqlConfigurationArgs

Database string: The name of the MSSQL database.
Host string: The host name of the MSSQL database.
LoadType DestinationMssqlConfigurationLoadType: Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
Port double: The port of the MSSQL database.
SslMethod DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
User 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 string: The name of the MSSQL database.
Host string: The host name of the MSSQL database.
LoadType DestinationMssqlConfigurationLoadType: Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
Port float64: The port of the MSSQL database.
SslMethod DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
User 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 String: The name of the MSSQL database.
host String: The host name of the MSSQL database.
loadType DestinationMssqlConfigurationLoadType: Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
port Double: The port of the MSSQL database.
sslMethod DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
user 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 string: The name of the MSSQL database.
host string: The host name of the MSSQL database.
loadType DestinationMssqlConfigurationLoadType: Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
port number: The port of the MSSQL database.
sslMethod DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
user 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 str: The name of the MSSQL database.
host str: The host name of the MSSQL database.
load_type DestinationMssqlConfigurationLoadType: Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
port float: The port of the MSSQL database.
ssl_method DestinationMssqlConfigurationSslMethod: The encryption method which is used to communicate with the database.
user 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 String: The name of the MSSQL database.
host String: The host name of the MSSQL database.
loadType Property Map: Specifies the type of load mechanism (e.g., BULK, INSERT) and its associated configuration.
port Number: The port of the MSSQL database.
sslMethod Property Map: The encryption method which is used to communicate with the database.
user 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"

DestinationMssqlConfigurationLoadType, DestinationMssqlConfigurationLoadTypeArgs

BulkLoad DestinationMssqlConfigurationLoadTypeBulkLoad: Configuration details for using the BULK loading mechanism.
InsertLoad DestinationMssqlConfigurationLoadTypeInsertLoad: Configuration details for using the INSERT loading mechanism.

BulkLoad DestinationMssqlConfigurationLoadTypeBulkLoad: Configuration details for using the BULK loading mechanism.
InsertLoad DestinationMssqlConfigurationLoadTypeInsertLoad: Configuration details for using the INSERT loading mechanism.

bulkLoad DestinationMssqlConfigurationLoadTypeBulkLoad: Configuration details for using the BULK loading mechanism.
insertLoad DestinationMssqlConfigurationLoadTypeInsertLoad: Configuration details for using the INSERT loading mechanism.

bulkLoad DestinationMssqlConfigurationLoadTypeBulkLoad: Configuration details for using the BULK loading mechanism.
insertLoad DestinationMssqlConfigurationLoadTypeInsertLoad: Configuration details for using the INSERT loading mechanism.

bulk_load DestinationMssqlConfigurationLoadTypeBulkLoad: Configuration details for using the BULK loading mechanism.
insert_load DestinationMssqlConfigurationLoadTypeInsertLoad: 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.

DestinationMssqlConfigurationLoadTypeBulkLoad, DestinationMssqlConfigurationLoadTypeBulkLoadArgs

AzureBlobStorageAccountName string: The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
AzureBlobStorageContainerName string: The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
BulkLoadDataSource 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 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 string: The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
AzureBlobStorageContainerName string: The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
BulkLoadDataSource 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 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 String: The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
azureBlobStorageContainerName String: The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
bulkLoadDataSource 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 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 string: The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
azureBlobStorageContainerName string: The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
bulkLoadDataSource 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 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 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 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 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 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 String: The name of the Azure Blob Storage account. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#storage-accounts
azureBlobStorageContainerName String: The name of the Azure Blob Storage container. See: https://learn.microsoft.com/azure/storage/blobs/storage-blobs-introduction#containers
bulkLoadDataSource 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 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"

DestinationMssqlConfigurationLoadTypeInsertLoad, DestinationMssqlConfigurationLoadTypeInsertLoadArgs

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"

DestinationMssqlConfigurationSslMethod, DestinationMssqlConfigurationSslMethodArgs

EncryptedTrustServerCertificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
EncryptedVerifyCertificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
Unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: The data transfer will not be encrypted.

EncryptedTrustServerCertificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
EncryptedVerifyCertificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
Unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: The data transfer will not be encrypted.

encryptedTrustServerCertificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
encryptedVerifyCertificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: The data transfer will not be encrypted.

encryptedTrustServerCertificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
encryptedVerifyCertificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: The data transfer will not be encrypted.

encrypted_trust_server_certificate DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate: Use the certificate provided by the server without verification. (For testing purposes only!)
encrypted_verify_certificate DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate: Verify and use the certificate provided by the server.
unencrypted DestinationMssqlConfigurationSslMethodUnencrypted: 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.

DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate, DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificateArgs

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"

DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate, DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs

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.

DestinationMssqlConfigurationSslMethodUnencrypted, DestinationMssqlConfigurationSslMethodUnencryptedArgs

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"

DestinationMssqlResourceAllocation, DestinationMssqlResourceAllocationArgs

Default DestinationMssqlResourceAllocationDefault: optional resource requirements to run workers (blank for unbounded allocations)
JobSpecifics List<DestinationMssqlResourceAllocationJobSpecific>

Default DestinationMssqlResourceAllocationDefault: optional resource requirements to run workers (blank for unbounded allocations)
JobSpecifics []DestinationMssqlResourceAllocationJobSpecific

default_ DestinationMssqlResourceAllocationDefault: optional resource requirements to run workers (blank for unbounded allocations)
jobSpecifics List<DestinationMssqlResourceAllocationJobSpecific>

default DestinationMssqlResourceAllocationDefault: optional resource requirements to run workers (blank for unbounded allocations)
jobSpecifics DestinationMssqlResourceAllocationJobSpecific[]

default DestinationMssqlResourceAllocationDefault: optional resource requirements to run workers (blank for unbounded allocations)
job_specifics Sequence[DestinationMssqlResourceAllocationJobSpecific]

default Property Map: optional resource requirements to run workers (blank for unbounded allocations)
jobSpecifics List<Property Map>

DestinationMssqlResourceAllocationDefault, DestinationMssqlResourceAllocationDefaultArgs

CpuLimit string
CpuRequest string
EphemeralStorageLimit string
EphemeralStorageRequest string
MemoryLimit string
MemoryRequest string

CpuLimit string
CpuRequest string
EphemeralStorageLimit string
EphemeralStorageRequest string
MemoryLimit string
MemoryRequest string

cpuLimit String
cpuRequest String
ephemeralStorageLimit String
ephemeralStorageRequest String
memoryLimit String
memoryRequest String

cpuLimit string
cpuRequest string
ephemeralStorageLimit string
ephemeralStorageRequest string
memoryLimit string
memoryRequest string

cpu_limit str
cpu_request str
ephemeral_storage_limit str
ephemeral_storage_request str
memory_limit str
memory_request str

cpuLimit String
cpuRequest String
ephemeralStorageLimit String
ephemeralStorageRequest String
memoryLimit String
memoryRequest String

DestinationMssqlResourceAllocationJobSpecific, DestinationMssqlResourceAllocationJobSpecificArgs

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 DestinationMssqlResourceAllocationJobSpecificResourceRequirements: 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 DestinationMssqlResourceAllocationJobSpecificResourceRequirements: 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 DestinationMssqlResourceAllocationJobSpecificResourceRequirements: 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 DestinationMssqlResourceAllocationJobSpecificResourceRequirements: 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 DestinationMssqlResourceAllocationJobSpecificResourceRequirements: 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)

DestinationMssqlResourceAllocationJobSpecificResourceRequirements, DestinationMssqlResourceAllocationJobSpecificResourceRequirementsArgs

CpuLimit string
CpuRequest string
EphemeralStorageLimit string
EphemeralStorageRequest string
MemoryLimit string
MemoryRequest string

CpuLimit string
CpuRequest string
EphemeralStorageLimit string
EphemeralStorageRequest string
MemoryLimit string
MemoryRequest string

cpuLimit String
cpuRequest String
ephemeralStorageLimit String
ephemeralStorageRequest String
memoryLimit String
memoryRequest String

cpuLimit string
cpuRequest string
ephemeralStorageLimit string
ephemeralStorageRequest string
memoryLimit string
memoryRequest string

cpu_limit str
cpu_request str
ephemeral_storage_limit str
ephemeral_storage_request str
memory_limit str
memory_request str

cpuLimit String
cpuRequest String
ephemeralStorageLimit String
ephemeralStorageRequest String
memoryLimit String
memoryRequest String

Import

$ pulumi import airbyte:index/destinationMssql:DestinationMssql my_airbyte_destination_mssql ""

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.8.0-beta2 published on Thursday, Mar 27, 2025 by airbytehq

airbytehq/terraform-provider-airbyte

airbyte.DestinationMssql

On this page

On this page

Create DestinationMssql Resource

Constructor syntax

Parameters

Constructor example

DestinationMssql Resource Properties

Inputs

Outputs

Look up Existing DestinationMssql Resource

Supporting Types

DestinationMssqlConfiguration, DestinationMssqlConfigurationArgs

DestinationMssqlConfigurationLoadType, DestinationMssqlConfigurationLoadTypeArgs

DestinationMssqlConfigurationLoadTypeBulkLoad, DestinationMssqlConfigurationLoadTypeBulkLoadArgs

DestinationMssqlConfigurationLoadTypeInsertLoad, DestinationMssqlConfigurationLoadTypeInsertLoadArgs

DestinationMssqlConfigurationSslMethod, DestinationMssqlConfigurationSslMethodArgs

DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificate, DestinationMssqlConfigurationSslMethodEncryptedTrustServerCertificateArgs

DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificate, DestinationMssqlConfigurationSslMethodEncryptedVerifyCertificateArgs

DestinationMssqlConfigurationSslMethodUnencrypted, DestinationMssqlConfigurationSslMethodUnencryptedArgs

DestinationMssqlResourceAllocation, DestinationMssqlResourceAllocationArgs

DestinationMssqlResourceAllocationDefault, DestinationMssqlResourceAllocationDefaultArgs

DestinationMssqlResourceAllocationJobSpecific, DestinationMssqlResourceAllocationJobSpecificArgs

DestinationMssqlResourceAllocationJobSpecificResourceRequirements, DestinationMssqlResourceAllocationJobSpecificResourceRequirementsArgs

Import

Package Details

On this page

On this page