1. Packages
  2. Airbyte Provider
  3. API Docs
  4. SourceMssql
airbyte 1.0.0-rc6 published on Monday, Feb 16, 2026 by airbytehq
Schema (JSON)
airbytehq/terraform-provider-airbyte

airbyte.SourceMssql

airbyte logo
airbyte 1.0.0-rc6 published on Monday, Feb 16, 2026 by airbytehq
Schema (JSON)
airbytehq/terraform-provider-airbyte

    SourceMssql Resource

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as airbyte from "@pulumi/airbyte";

const mySourceMssql = new airbyte.SourceMssql("my_source_mssql", {
    configuration: {
        additionalProperties: {
            key: {},
        },
        additionalProperties1: "{ \"see\": \"documentation\" }",
        checkPrivileges: false,
        checkpointTargetIntervalSeconds: 4,
        concurrency: 4,
        database: "master",
        host: "...my_host...",
        jdbcUrlParams: "...my_jdbc_url_params...",
        password: "...my_password...",
        port: 1433,
        replicationMethod: {
            readChangesUsingChangeDataCaptureCdc: {
                additionalProperties: "{ \"see\": \"documentation\" }",
                initialLoadTimeoutHours: 4,
                initialWaitingSeconds: 0,
                invalidCdcCursorPositionBehavior: "Re-sync data",
                method: "CDC",
                pollIntervalMs: 6,
            },
        },
        schemas: [],
        sslMode: {},
        tunnelMethod: {
            noTunnel: {
                additionalProperties: "{ \"see\": \"documentation\" }",
                tunnelMethod: "NO_TUNNEL",
            },
        },
        username: "...my_username...",
    },
    definitionId: "3156776f-a553-4f83-b7be-07e1d515092f",
    name: "...my_name...",
    secretId: "...my_secret_id...",
    workspaceId: "89a5f137-cba1-4f2e-85cc-db4cd4426082",
});

    import pulumi
import pulumi_airbyte as airbyte

my_source_mssql = airbyte.SourceMssql("my_source_mssql",
    configuration={
        "additional_properties": {
            "key": {},
        },
        "additional_properties1": "{ \"see\": \"documentation\" }",
        "check_privileges": False,
        "checkpoint_target_interval_seconds": 4,
        "concurrency": 4,
        "database": "master",
        "host": "...my_host...",
        "jdbc_url_params": "...my_jdbc_url_params...",
        "password": "...my_password...",
        "port": 1433,
        "replication_method": {
            "read_changes_using_change_data_capture_cdc": {
                "additional_properties": "{ \"see\": \"documentation\" }",
                "initial_load_timeout_hours": 4,
                "initial_waiting_seconds": 0,
                "invalid_cdc_cursor_position_behavior": "Re-sync data",
                "method": "CDC",
                "poll_interval_ms": 6,
            },
        },
        "schemas": [],
        "ssl_mode": {},
        "tunnel_method": {
            "no_tunnel": {
                "additional_properties": "{ \"see\": \"documentation\" }",
                "tunnel_method": "NO_TUNNEL",
            },
        },
        "username": "...my_username...",
    },
    definition_id="3156776f-a553-4f83-b7be-07e1d515092f",
    name="...my_name...",
    secret_id="...my_secret_id...",
    workspace_id="89a5f137-cba1-4f2e-85cc-db4cd4426082")

    package main

import (
	"github.com/pulumi/pulumi-terraform-provider/sdks/go/airbyte/airbyte"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := airbyte.NewSourceMssql(ctx, "my_source_mssql", &airbyte.SourceMssqlArgs{
			Configuration: &airbyte.SourceMssqlConfigurationArgs{
				AdditionalProperties: pulumi.StringMapMap{
					"key": pulumi.StringMap{},
				},
				AdditionalProperties1:           pulumi.String("{ \"see\": \"documentation\" }"),
				CheckPrivileges:                 pulumi.Bool(false),
				CheckpointTargetIntervalSeconds: pulumi.Float64(4),
				Concurrency:                     pulumi.Float64(4),
				Database:                        pulumi.String("master"),
				Host:                            pulumi.String("...my_host..."),
				JdbcUrlParams:                   pulumi.String("...my_jdbc_url_params..."),
				Password:                        pulumi.String("...my_password..."),
				Port:                            pulumi.Float64(1433),
				ReplicationMethod: &airbyte.SourceMssqlConfigurationReplicationMethodArgs{
					ReadChangesUsingChangeDataCaptureCdc: &airbyte.SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdcArgs{
						AdditionalProperties:             pulumi.String("{ \"see\": \"documentation\" }"),
						InitialLoadTimeoutHours:          pulumi.Float64(4),
						InitialWaitingSeconds:            pulumi.Float64(0),
						InvalidCdcCursorPositionBehavior: pulumi.String("Re-sync data"),
						Method:                           pulumi.String("CDC"),
						PollIntervalMs:                   pulumi.Float64(6),
					},
				},
				Schemas: pulumi.StringArray{},
				SslMode: &airbyte.SourceMssqlConfigurationSslModeArgs{},
				TunnelMethod: &airbyte.SourceMssqlConfigurationTunnelMethodArgs{
					NoTunnel: &airbyte.SourceMssqlConfigurationTunnelMethodNoTunnelArgs{
						AdditionalProperties: pulumi.String("{ \"see\": \"documentation\" }"),
						TunnelMethod:         pulumi.String("NO_TUNNEL"),
					},
				},
				Username: pulumi.String("...my_username..."),
			},
			DefinitionId: pulumi.String("3156776f-a553-4f83-b7be-07e1d515092f"),
			Name:         pulumi.String("...my_name..."),
			SecretId:     pulumi.String("...my_secret_id..."),
			WorkspaceId:  pulumi.String("89a5f137-cba1-4f2e-85cc-db4cd4426082"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Airbyte = Pulumi.Airbyte;

return await Deployment.RunAsync(() => 
{
    var mySourceMssql = new Airbyte.SourceMssql("my_source_mssql", new()
    {
        Configuration = new Airbyte.Inputs.SourceMssqlConfigurationArgs
        {
            AdditionalProperties = 
            {
                { "key", null },
            },
            AdditionalProperties1 = "{ \"see\": \"documentation\" }",
            CheckPrivileges = false,
            CheckpointTargetIntervalSeconds = 4,
            Concurrency = 4,
            Database = "master",
            Host = "...my_host...",
            JdbcUrlParams = "...my_jdbc_url_params...",
            Password = "...my_password...",
            Port = 1433,
            ReplicationMethod = new Airbyte.Inputs.SourceMssqlConfigurationReplicationMethodArgs
            {
                ReadChangesUsingChangeDataCaptureCdc = new Airbyte.Inputs.SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdcArgs
                {
                    AdditionalProperties = "{ \"see\": \"documentation\" }",
                    InitialLoadTimeoutHours = 4,
                    InitialWaitingSeconds = 0,
                    InvalidCdcCursorPositionBehavior = "Re-sync data",
                    Method = "CDC",
                    PollIntervalMs = 6,
                },
            },
            Schemas = new() { },
            SslMode = null,
            TunnelMethod = new Airbyte.Inputs.SourceMssqlConfigurationTunnelMethodArgs
            {
                NoTunnel = new Airbyte.Inputs.SourceMssqlConfigurationTunnelMethodNoTunnelArgs
                {
                    AdditionalProperties = "{ \"see\": \"documentation\" }",
                    TunnelMethod = "NO_TUNNEL",
                },
            },
            Username = "...my_username...",
        },
        DefinitionId = "3156776f-a553-4f83-b7be-07e1d515092f",
        Name = "...my_name...",
        SecretId = "...my_secret_id...",
        WorkspaceId = "89a5f137-cba1-4f2e-85cc-db4cd4426082",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.airbyte.SourceMssql;
import com.pulumi.airbyte.SourceMssqlArgs;
import com.pulumi.airbyte.inputs.SourceMssqlConfigurationArgs;
import com.pulumi.airbyte.inputs.SourceMssqlConfigurationReplicationMethodArgs;
import com.pulumi.airbyte.inputs.SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdcArgs;
import com.pulumi.airbyte.inputs.SourceMssqlConfigurationSslModeArgs;
import com.pulumi.airbyte.inputs.SourceMssqlConfigurationTunnelMethodArgs;
import com.pulumi.airbyte.inputs.SourceMssqlConfigurationTunnelMethodNoTunnelArgs;
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 mySourceMssql = new SourceMssql("mySourceMssql", SourceMssqlArgs.builder()
            .configuration(SourceMssqlConfigurationArgs.builder()
                .additionalProperties(Map.of("key", Map.ofEntries(
                )))
                .additionalProperties1("{ \"see\": \"documentation\" }")
                .checkPrivileges(false)
                .checkpointTargetIntervalSeconds(4.0)
                .concurrency(4.0)
                .database("master")
                .host("...my_host...")
                .jdbcUrlParams("...my_jdbc_url_params...")
                .password("...my_password...")
                .port(1433.0)
                .replicationMethod(SourceMssqlConfigurationReplicationMethodArgs.builder()
                    .readChangesUsingChangeDataCaptureCdc(SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdcArgs.builder()
                        .additionalProperties("{ \"see\": \"documentation\" }")
                        .initialLoadTimeoutHours(4.0)
                        .initialWaitingSeconds(0.0)
                        .invalidCdcCursorPositionBehavior("Re-sync data")
                        .method("CDC")
                        .pollIntervalMs(6.0)
                        .build())
                    .build())
                .schemas()
                .sslMode(SourceMssqlConfigurationSslModeArgs.builder()
                    .build())
                .tunnelMethod(SourceMssqlConfigurationTunnelMethodArgs.builder()
                    .noTunnel(SourceMssqlConfigurationTunnelMethodNoTunnelArgs.builder()
                        .additionalProperties("{ \"see\": \"documentation\" }")
                        .tunnelMethod("NO_TUNNEL")
                        .build())
                    .build())
                .username("...my_username...")
                .build())
            .definitionId("3156776f-a553-4f83-b7be-07e1d515092f")
            .name("...my_name...")
            .secretId("...my_secret_id...")
            .workspaceId("89a5f137-cba1-4f2e-85cc-db4cd4426082")
            .build());

    }
}

    resources:
  mySourceMssql:
    type: airbyte:SourceMssql
    name: my_source_mssql
    properties:
      configuration:
        additionalProperties:
          key: {}
        additionalProperties1: '{ "see": "documentation" }'
        checkPrivileges: false
        checkpointTargetIntervalSeconds: 4
        concurrency: 4
        database: master
        host: '...my_host...'
        jdbcUrlParams: '...my_jdbc_url_params...'
        password: '...my_password...'
        port: 1433
        replicationMethod:
          readChangesUsingChangeDataCaptureCdc:
            additionalProperties: '{ "see": "documentation" }'
            initialLoadTimeoutHours: 4
            initialWaitingSeconds: 0
            invalidCdcCursorPositionBehavior: Re-sync data
            method: CDC
            pollIntervalMs: 6
        schemas: []
        sslMode: {}
        tunnelMethod:
          noTunnel:
            additionalProperties: '{ "see": "documentation" }'
            tunnelMethod: NO_TUNNEL
        username: '...my_username...'
      definitionId: 3156776f-a553-4f83-b7be-07e1d515092f
      name: '...my_name...'
      secretId: '...my_secret_id...'
      workspaceId: 89a5f137-cba1-4f2e-85cc-db4cd4426082

    Create SourceMssql Resource

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

    Constructor syntax

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

@overload
def SourceMssql(resource_name: str,
                opts: Optional[ResourceOptions] = None,
                configuration: Optional[SourceMssqlConfigurationArgs] = None,
                workspace_id: Optional[str] = None,
                definition_id: Optional[str] = None,
                name: Optional[str] = None,
                secret_id: Optional[str] = None)
    func NewSourceMssql(ctx *Context, name string, args SourceMssqlArgs, opts ...ResourceOption) (*SourceMssql, error)
    public SourceMssql(string name, SourceMssqlArgs args, CustomResourceOptions? opts = null)
    public SourceMssql(String name, SourceMssqlArgs args)
public SourceMssql(String name, SourceMssqlArgs args, CustomResourceOptions options)

    type: airbyte:SourceMssql
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 SourceMssqlArgs
    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 SourceMssqlArgs
    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 SourceMssqlArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SourceMssqlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SourceMssqlArgs
    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 sourceMssqlResource = new Airbyte.SourceMssql("sourceMssqlResource", new()
{
    Configuration = new Airbyte.Inputs.SourceMssqlConfigurationArgs
    {
        Host = "string",
        Username = "string",
        ReplicationMethod = new Airbyte.Inputs.SourceMssqlConfigurationReplicationMethodArgs
        {
            ReadChangesUsingChangeDataCaptureCdc = new Airbyte.Inputs.SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdcArgs
            {
                AdditionalProperties = "string",
                InitialLoadTimeoutHours = 0,
                InitialWaitingSeconds = 0,
                InvalidCdcCursorPositionBehavior = "string",
                Method = "string",
                PollIntervalMs = 0,
            },
            ScanChangesWithUserDefinedCursor = new Airbyte.Inputs.SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursorArgs
            {
                AdditionalProperties = "string",
                ExcludeTodaysData = false,
                Method = "string",
            },
        },
        AdditionalProperties = 
        {
            { "string", 
            {
                { "string", "string" },
            } },
        },
        Password = "string",
        Database = "string",
        CheckpointTargetIntervalSeconds = 0,
        JdbcUrlParams = "string",
        Concurrency = 0,
        Port = 0,
        CheckPrivileges = false,
        Schemas = new[]
        {
            "string",
        },
        SslMode = new Airbyte.Inputs.SourceMssqlConfigurationSslModeArgs
        {
            EncryptedTrustServerCertificate = new Airbyte.Inputs.SourceMssqlConfigurationSslModeEncryptedTrustServerCertificateArgs
            {
                AdditionalProperties = "string",
                Mode = "string",
            },
            EncryptedVerifyCertificate = new Airbyte.Inputs.SourceMssqlConfigurationSslModeEncryptedVerifyCertificateArgs
            {
                AdditionalProperties = "string",
                Certificate = "string",
                HostNameInCertificate = "string",
                Mode = "string",
            },
            Unencrypted = new Airbyte.Inputs.SourceMssqlConfigurationSslModeUnencryptedArgs
            {
                AdditionalProperties = "string",
                Mode = "string",
            },
        },
        TunnelMethod = new Airbyte.Inputs.SourceMssqlConfigurationTunnelMethodArgs
        {
            NoTunnel = new Airbyte.Inputs.SourceMssqlConfigurationTunnelMethodNoTunnelArgs
            {
                AdditionalProperties = "string",
                TunnelMethod = "string",
            },
            PasswordAuthentication = new Airbyte.Inputs.SourceMssqlConfigurationTunnelMethodPasswordAuthenticationArgs
            {
                TunnelHost = "string",
                TunnelUser = "string",
                TunnelUserPassword = "string",
                AdditionalProperties = "string",
                TunnelMethod = "string",
                TunnelPort = 0,
            },
            SshKeyAuthentication = new Airbyte.Inputs.SourceMssqlConfigurationTunnelMethodSshKeyAuthenticationArgs
            {
                SshKey = "string",
                TunnelHost = "string",
                TunnelUser = "string",
                AdditionalProperties = "string",
                TunnelMethod = "string",
                TunnelPort = 0,
            },
        },
        AdditionalProperties1 = "string",
    },
    WorkspaceId = "string",
    DefinitionId = "string",
    Name = "string",
    SecretId = "string",
});

    example, err := airbyte.NewSourceMssql(ctx, "sourceMssqlResource", &airbyte.SourceMssqlArgs{
	Configuration: &airbyte.SourceMssqlConfigurationArgs{
		Host:     pulumi.String("string"),
		Username: pulumi.String("string"),
		ReplicationMethod: &airbyte.SourceMssqlConfigurationReplicationMethodArgs{
			ReadChangesUsingChangeDataCaptureCdc: &airbyte.SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdcArgs{
				AdditionalProperties:             pulumi.String("string"),
				InitialLoadTimeoutHours:          pulumi.Float64(0),
				InitialWaitingSeconds:            pulumi.Float64(0),
				InvalidCdcCursorPositionBehavior: pulumi.String("string"),
				Method:                           pulumi.String("string"),
				PollIntervalMs:                   pulumi.Float64(0),
			},
			ScanChangesWithUserDefinedCursor: &airbyte.SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursorArgs{
				AdditionalProperties: pulumi.String("string"),
				ExcludeTodaysData:    pulumi.Bool(false),
				Method:               pulumi.String("string"),
			},
		},
		AdditionalProperties: pulumi.StringMapMap{
			"string": pulumi.StringMap{
				"string": pulumi.String("string"),
			},
		},
		Password:                        pulumi.String("string"),
		Database:                        pulumi.String("string"),
		CheckpointTargetIntervalSeconds: pulumi.Float64(0),
		JdbcUrlParams:                   pulumi.String("string"),
		Concurrency:                     pulumi.Float64(0),
		Port:                            pulumi.Float64(0),
		CheckPrivileges:                 pulumi.Bool(false),
		Schemas: pulumi.StringArray{
			pulumi.String("string"),
		},
		SslMode: &airbyte.SourceMssqlConfigurationSslModeArgs{
			EncryptedTrustServerCertificate: &airbyte.SourceMssqlConfigurationSslModeEncryptedTrustServerCertificateArgs{
				AdditionalProperties: pulumi.String("string"),
				Mode:                 pulumi.String("string"),
			},
			EncryptedVerifyCertificate: &airbyte.SourceMssqlConfigurationSslModeEncryptedVerifyCertificateArgs{
				AdditionalProperties:  pulumi.String("string"),
				Certificate:           pulumi.String("string"),
				HostNameInCertificate: pulumi.String("string"),
				Mode:                  pulumi.String("string"),
			},
			Unencrypted: &airbyte.SourceMssqlConfigurationSslModeUnencryptedArgs{
				AdditionalProperties: pulumi.String("string"),
				Mode:                 pulumi.String("string"),
			},
		},
		TunnelMethod: &airbyte.SourceMssqlConfigurationTunnelMethodArgs{
			NoTunnel: &airbyte.SourceMssqlConfigurationTunnelMethodNoTunnelArgs{
				AdditionalProperties: pulumi.String("string"),
				TunnelMethod:         pulumi.String("string"),
			},
			PasswordAuthentication: &airbyte.SourceMssqlConfigurationTunnelMethodPasswordAuthenticationArgs{
				TunnelHost:           pulumi.String("string"),
				TunnelUser:           pulumi.String("string"),
				TunnelUserPassword:   pulumi.String("string"),
				AdditionalProperties: pulumi.String("string"),
				TunnelMethod:         pulumi.String("string"),
				TunnelPort:           pulumi.Float64(0),
			},
			SshKeyAuthentication: &airbyte.SourceMssqlConfigurationTunnelMethodSshKeyAuthenticationArgs{
				SshKey:               pulumi.String("string"),
				TunnelHost:           pulumi.String("string"),
				TunnelUser:           pulumi.String("string"),
				AdditionalProperties: pulumi.String("string"),
				TunnelMethod:         pulumi.String("string"),
				TunnelPort:           pulumi.Float64(0),
			},
		},
		AdditionalProperties1: pulumi.String("string"),
	},
	WorkspaceId:  pulumi.String("string"),
	DefinitionId: pulumi.String("string"),
	Name:         pulumi.String("string"),
	SecretId:     pulumi.String("string"),
})

    var sourceMssqlResource = new SourceMssql("sourceMssqlResource", SourceMssqlArgs.builder()
    .configuration(SourceMssqlConfigurationArgs.builder()
        .host("string")
        .username("string")
        .replicationMethod(SourceMssqlConfigurationReplicationMethodArgs.builder()
            .readChangesUsingChangeDataCaptureCdc(SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdcArgs.builder()
                .additionalProperties("string")
                .initialLoadTimeoutHours(0.0)
                .initialWaitingSeconds(0.0)
                .invalidCdcCursorPositionBehavior("string")
                .method("string")
                .pollIntervalMs(0.0)
                .build())
            .scanChangesWithUserDefinedCursor(SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursorArgs.builder()
                .additionalProperties("string")
                .excludeTodaysData(false)
                .method("string")
                .build())
            .build())
        .additionalProperties(Map.of("string", Map.of("string", "string")))
        .password("string")
        .database("string")
        .checkpointTargetIntervalSeconds(0.0)
        .jdbcUrlParams("string")
        .concurrency(0.0)
        .port(0.0)
        .checkPrivileges(false)
        .schemas("string")
        .sslMode(SourceMssqlConfigurationSslModeArgs.builder()
            .encryptedTrustServerCertificate(SourceMssqlConfigurationSslModeEncryptedTrustServerCertificateArgs.builder()
                .additionalProperties("string")
                .mode("string")
                .build())
            .encryptedVerifyCertificate(SourceMssqlConfigurationSslModeEncryptedVerifyCertificateArgs.builder()
                .additionalProperties("string")
                .certificate("string")
                .hostNameInCertificate("string")
                .mode("string")
                .build())
            .unencrypted(SourceMssqlConfigurationSslModeUnencryptedArgs.builder()
                .additionalProperties("string")
                .mode("string")
                .build())
            .build())
        .tunnelMethod(SourceMssqlConfigurationTunnelMethodArgs.builder()
            .noTunnel(SourceMssqlConfigurationTunnelMethodNoTunnelArgs.builder()
                .additionalProperties("string")
                .tunnelMethod("string")
                .build())
            .passwordAuthentication(SourceMssqlConfigurationTunnelMethodPasswordAuthenticationArgs.builder()
                .tunnelHost("string")
                .tunnelUser("string")
                .tunnelUserPassword("string")
                .additionalProperties("string")
                .tunnelMethod("string")
                .tunnelPort(0.0)
                .build())
            .sshKeyAuthentication(SourceMssqlConfigurationTunnelMethodSshKeyAuthenticationArgs.builder()
                .sshKey("string")
                .tunnelHost("string")
                .tunnelUser("string")
                .additionalProperties("string")
                .tunnelMethod("string")
                .tunnelPort(0.0)
                .build())
            .build())
        .additionalProperties1("string")
        .build())
    .workspaceId("string")
    .definitionId("string")
    .name("string")
    .secretId("string")
    .build());

    source_mssql_resource = airbyte.SourceMssql("sourceMssqlResource",
    configuration={
        "host": "string",
        "username": "string",
        "replication_method": {
            "read_changes_using_change_data_capture_cdc": {
                "additional_properties": "string",
                "initial_load_timeout_hours": 0,
                "initial_waiting_seconds": 0,
                "invalid_cdc_cursor_position_behavior": "string",
                "method": "string",
                "poll_interval_ms": 0,
            },
            "scan_changes_with_user_defined_cursor": {
                "additional_properties": "string",
                "exclude_todays_data": False,
                "method": "string",
            },
        },
        "additional_properties": {
            "string": {
                "string": "string",
            },
        },
        "password": "string",
        "database": "string",
        "checkpoint_target_interval_seconds": 0,
        "jdbc_url_params": "string",
        "concurrency": 0,
        "port": 0,
        "check_privileges": False,
        "schemas": ["string"],
        "ssl_mode": {
            "encrypted_trust_server_certificate": {
                "additional_properties": "string",
                "mode": "string",
            },
            "encrypted_verify_certificate": {
                "additional_properties": "string",
                "certificate": "string",
                "host_name_in_certificate": "string",
                "mode": "string",
            },
            "unencrypted": {
                "additional_properties": "string",
                "mode": "string",
            },
        },
        "tunnel_method": {
            "no_tunnel": {
                "additional_properties": "string",
                "tunnel_method": "string",
            },
            "password_authentication": {
                "tunnel_host": "string",
                "tunnel_user": "string",
                "tunnel_user_password": "string",
                "additional_properties": "string",
                "tunnel_method": "string",
                "tunnel_port": 0,
            },
            "ssh_key_authentication": {
                "ssh_key": "string",
                "tunnel_host": "string",
                "tunnel_user": "string",
                "additional_properties": "string",
                "tunnel_method": "string",
                "tunnel_port": 0,
            },
        },
        "additional_properties1": "string",
    },
    workspace_id="string",
    definition_id="string",
    name="string",
    secret_id="string")

    const sourceMssqlResource = new airbyte.SourceMssql("sourceMssqlResource", {
    configuration: {
        host: "string",
        username: "string",
        replicationMethod: {
            readChangesUsingChangeDataCaptureCdc: {
                additionalProperties: "string",
                initialLoadTimeoutHours: 0,
                initialWaitingSeconds: 0,
                invalidCdcCursorPositionBehavior: "string",
                method: "string",
                pollIntervalMs: 0,
            },
            scanChangesWithUserDefinedCursor: {
                additionalProperties: "string",
                excludeTodaysData: false,
                method: "string",
            },
        },
        additionalProperties: {
            string: {
                string: "string",
            },
        },
        password: "string",
        database: "string",
        checkpointTargetIntervalSeconds: 0,
        jdbcUrlParams: "string",
        concurrency: 0,
        port: 0,
        checkPrivileges: false,
        schemas: ["string"],
        sslMode: {
            encryptedTrustServerCertificate: {
                additionalProperties: "string",
                mode: "string",
            },
            encryptedVerifyCertificate: {
                additionalProperties: "string",
                certificate: "string",
                hostNameInCertificate: "string",
                mode: "string",
            },
            unencrypted: {
                additionalProperties: "string",
                mode: "string",
            },
        },
        tunnelMethod: {
            noTunnel: {
                additionalProperties: "string",
                tunnelMethod: "string",
            },
            passwordAuthentication: {
                tunnelHost: "string",
                tunnelUser: "string",
                tunnelUserPassword: "string",
                additionalProperties: "string",
                tunnelMethod: "string",
                tunnelPort: 0,
            },
            sshKeyAuthentication: {
                sshKey: "string",
                tunnelHost: "string",
                tunnelUser: "string",
                additionalProperties: "string",
                tunnelMethod: "string",
                tunnelPort: 0,
            },
        },
        additionalProperties1: "string",
    },
    workspaceId: "string",
    definitionId: "string",
    name: "string",
    secretId: "string",
});

    type: airbyte:SourceMssql
properties:
    configuration:
        additionalProperties:
            string:
                string: string
        additionalProperties1: string
        checkPrivileges: false
        checkpointTargetIntervalSeconds: 0
        concurrency: 0
        database: string
        host: string
        jdbcUrlParams: string
        password: string
        port: 0
        replicationMethod:
            readChangesUsingChangeDataCaptureCdc:
                additionalProperties: string
                initialLoadTimeoutHours: 0
                initialWaitingSeconds: 0
                invalidCdcCursorPositionBehavior: string
                method: string
                pollIntervalMs: 0
            scanChangesWithUserDefinedCursor:
                additionalProperties: string
                excludeTodaysData: false
                method: string
        schemas:
            - string
        sslMode:
            encryptedTrustServerCertificate:
                additionalProperties: string
                mode: string
            encryptedVerifyCertificate:
                additionalProperties: string
                certificate: string
                hostNameInCertificate: string
                mode: string
            unencrypted:
                additionalProperties: string
                mode: string
        tunnelMethod:
            noTunnel:
                additionalProperties: string
                tunnelMethod: string
            passwordAuthentication:
                additionalProperties: string
                tunnelHost: string
                tunnelMethod: string
                tunnelPort: 0
                tunnelUser: string
                tunnelUserPassword: string
            sshKeyAuthentication:
                additionalProperties: string
                sshKey: string
                tunnelHost: string
                tunnelMethod: string
                tunnelPort: 0
                tunnelUser: string
        username: string
    definitionId: string
    name: string
    secretId: string
    workspaceId: string

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

    Configuration SourceMssqlConfiguration
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    WorkspaceId string
    DefinitionId string
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    Name string
    Name of the source e.g. dev-mysql-instance.
    SecretId string
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    Configuration SourceMssqlConfigurationArgs
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    WorkspaceId string
    DefinitionId string
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    Name string
    Name of the source e.g. dev-mysql-instance.
    SecretId string
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    configuration SourceMssqlConfiguration
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    workspaceId String
    definitionId String
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    name String
    Name of the source e.g. dev-mysql-instance.
    secretId String
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    configuration SourceMssqlConfiguration
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    workspaceId string
    definitionId string
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    name string
    Name of the source e.g. dev-mysql-instance.
    secretId string
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    configuration SourceMssqlConfigurationArgs
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    workspace_id str
    definition_id str
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    name str
    Name of the source e.g. dev-mysql-instance.
    secret_id str
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    configuration Property Map
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    workspaceId String
    definitionId String
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    name String
    Name of the source e.g. dev-mysql-instance.
    secretId String
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.

    Outputs

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

    CreatedAt double
    Id string
    The provider-assigned unique ID for this managed resource.
    ResourceAllocation SourceMssqlResourceAllocation
    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.
    SourceId string
    SourceType string
    CreatedAt float64
    Id string
    The provider-assigned unique ID for this managed resource.
    ResourceAllocation SourceMssqlResourceAllocation
    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.
    SourceId string
    SourceType string
    createdAt Double
    id String
    The provider-assigned unique ID for this managed resource.
    resourceAllocation SourceMssqlResourceAllocation
    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.
    sourceId String
    sourceType String
    createdAt number
    id string
    The provider-assigned unique ID for this managed resource.
    resourceAllocation SourceMssqlResourceAllocation
    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.
    sourceId string
    sourceType string
    created_at float
    id str
    The provider-assigned unique ID for this managed resource.
    resource_allocation SourceMssqlResourceAllocation
    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.
    source_id str
    source_type str
    createdAt Number
    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.
    sourceId String
    sourceType String

    Look up Existing SourceMssql Resource

    Get an existing SourceMssql 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?: SourceMssqlState, opts?: CustomResourceOptions): SourceMssql
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        configuration: Optional[SourceMssqlConfigurationArgs] = None,
        created_at: Optional[float] = None,
        definition_id: Optional[str] = None,
        name: Optional[str] = None,
        resource_allocation: Optional[SourceMssqlResourceAllocationArgs] = None,
        secret_id: Optional[str] = None,
        source_id: Optional[str] = None,
        source_type: Optional[str] = None,
        workspace_id: Optional[str] = None) -> SourceMssql
    func GetSourceMssql(ctx *Context, name string, id IDInput, state *SourceMssqlState, opts ...ResourceOption) (*SourceMssql, error)
    public static SourceMssql Get(string name, Input<string> id, SourceMssqlState? state, CustomResourceOptions? opts = null)
    public static SourceMssql get(String name, Output<String> id, SourceMssqlState state, CustomResourceOptions options)
    resources:  _:    type: airbyte:SourceMssql    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 SourceMssqlConfiguration
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    CreatedAt double
    DefinitionId string
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    Name string
    Name of the source e.g. dev-mysql-instance.
    ResourceAllocation SourceMssqlResourceAllocation
    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.
    SecretId string
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    SourceId string
    SourceType string
    WorkspaceId string
    Configuration SourceMssqlConfigurationArgs
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    CreatedAt float64
    DefinitionId string
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    Name string
    Name of the source e.g. dev-mysql-instance.
    ResourceAllocation SourceMssqlResourceAllocationArgs
    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.
    SecretId string
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    SourceId string
    SourceType string
    WorkspaceId string
    configuration SourceMssqlConfiguration
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    createdAt Double
    definitionId String
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    name String
    Name of the source e.g. dev-mysql-instance.
    resourceAllocation SourceMssqlResourceAllocation
    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.
    secretId String
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    sourceId String
    sourceType String
    workspaceId String
    configuration SourceMssqlConfiguration
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    createdAt number
    definitionId string
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    name string
    Name of the source e.g. dev-mysql-instance.
    resourceAllocation SourceMssqlResourceAllocation
    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.
    secretId string
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    sourceId string
    sourceType string
    workspaceId string
    configuration SourceMssqlConfigurationArgs
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    created_at float
    definition_id str
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    name str
    Name of the source e.g. dev-mysql-instance.
    resource_allocation SourceMssqlResourceAllocationArgs
    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.
    secret_id str
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    source_id str
    source_type str
    workspace_id str
    configuration Property Map
    The values required to configure the source. The schema for this must match the schema return by sourcedefinitionspecifications/get for the source.
    createdAt Number
    definitionId String
    The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Default: "b5ea17b1-f170-46dc-bc31-cc744ca984c1"; Requires replacement if changed.
    name String
    Name of the source 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.
    secretId String
    Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
    sourceId String
    sourceType String
    workspaceId String

    Supporting Types

    SourceMssqlConfiguration, SourceMssqlConfigurationArgs

    AdditionalProperties Dictionary<string, ImmutableDictionary<string, string>>
    Database string
    The name of the database.
    Host string
    The hostname of the database.
    Password string
    The password associated with the username.
    ReplicationMethod SourceMssqlConfigurationReplicationMethod
    Configures how data is extracted from the database.
    Username string
    The username which is used to access the database.
    AdditionalProperties1 string
    Parsed as JSON.
    CheckPrivileges bool
    When this feature is enabled, during schema discovery the connector will query each table or view individually to check access privileges and inaccessible tables, views, or columns therein will be removed. In large schemas, this might cause schema discovery to take too long, in which case it might be advisable to disable this feature. Default: true
    CheckpointTargetIntervalSeconds double
    How often (in seconds) a stream should checkpoint, when possible. Default: 300
    Concurrency double
    Maximum number of concurrent queries to 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).
    Port double
    The port of the database. Default: 1433
    Schemas List<string>
    The list of schemas to sync from. If not specified, all schemas will be discovered. Case sensitive.
    SslMode SourceMssqlConfigurationSslMode
    The encryption method which is used when communicating with the database.
    TunnelMethod SourceMssqlConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    AdditionalProperties map[string]map[string]string
    Database string
    The name of the database.
    Host string
    The hostname of the database.
    Password string
    The password associated with the username.
    ReplicationMethod SourceMssqlConfigurationReplicationMethod
    Configures how data is extracted from the database.
    Username string
    The username which is used to access the database.
    AdditionalProperties1 string
    Parsed as JSON.
    CheckPrivileges bool
    When this feature is enabled, during schema discovery the connector will query each table or view individually to check access privileges and inaccessible tables, views, or columns therein will be removed. In large schemas, this might cause schema discovery to take too long, in which case it might be advisable to disable this feature. Default: true
    CheckpointTargetIntervalSeconds float64
    How often (in seconds) a stream should checkpoint, when possible. Default: 300
    Concurrency float64
    Maximum number of concurrent queries to 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).
    Port float64
    The port of the database. Default: 1433
    Schemas []string
    The list of schemas to sync from. If not specified, all schemas will be discovered. Case sensitive.
    SslMode SourceMssqlConfigurationSslMode
    The encryption method which is used when communicating with the database.
    TunnelMethod SourceMssqlConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    additionalProperties Map<String,Map<String,String>>
    database String
    The name of the database.
    host String
    The hostname of the database.
    password String
    The password associated with the username.
    replicationMethod SourceMssqlConfigurationReplicationMethod
    Configures how data is extracted from the database.
    username String
    The username which is used to access the database.
    additionalProperties1 String
    Parsed as JSON.
    checkPrivileges Boolean
    When this feature is enabled, during schema discovery the connector will query each table or view individually to check access privileges and inaccessible tables, views, or columns therein will be removed. In large schemas, this might cause schema discovery to take too long, in which case it might be advisable to disable this feature. Default: true
    checkpointTargetIntervalSeconds Double
    How often (in seconds) a stream should checkpoint, when possible. Default: 300
    concurrency Double
    Maximum number of concurrent queries to 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).
    port Double
    The port of the database. Default: 1433
    schemas List<String>
    The list of schemas to sync from. If not specified, all schemas will be discovered. Case sensitive.
    sslMode SourceMssqlConfigurationSslMode
    The encryption method which is used when communicating with the database.
    tunnelMethod SourceMssqlConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    additionalProperties {[key: string]: {[key: string]: string}}
    database string
    The name of the database.
    host string
    The hostname of the database.
    password string
    The password associated with the username.
    replicationMethod SourceMssqlConfigurationReplicationMethod
    Configures how data is extracted from the database.
    username string
    The username which is used to access the database.
    additionalProperties1 string
    Parsed as JSON.
    checkPrivileges boolean
    When this feature is enabled, during schema discovery the connector will query each table or view individually to check access privileges and inaccessible tables, views, or columns therein will be removed. In large schemas, this might cause schema discovery to take too long, in which case it might be advisable to disable this feature. Default: true
    checkpointTargetIntervalSeconds number
    How often (in seconds) a stream should checkpoint, when possible. Default: 300
    concurrency number
    Maximum number of concurrent queries to 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).
    port number
    The port of the database. Default: 1433
    schemas string[]
    The list of schemas to sync from. If not specified, all schemas will be discovered. Case sensitive.
    sslMode SourceMssqlConfigurationSslMode
    The encryption method which is used when communicating with the database.
    tunnelMethod SourceMssqlConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    additional_properties Mapping[str, Mapping[str, str]]
    database str
    The name of the database.
    host str
    The hostname of the database.
    password str
    The password associated with the username.
    replication_method SourceMssqlConfigurationReplicationMethod
    Configures how data is extracted from the database.
    username str
    The username which is used to access the database.
    additional_properties1 str
    Parsed as JSON.
    check_privileges bool
    When this feature is enabled, during schema discovery the connector will query each table or view individually to check access privileges and inaccessible tables, views, or columns therein will be removed. In large schemas, this might cause schema discovery to take too long, in which case it might be advisable to disable this feature. Default: true
    checkpoint_target_interval_seconds float
    How often (in seconds) a stream should checkpoint, when possible. Default: 300
    concurrency float
    Maximum number of concurrent queries to 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).
    port float
    The port of the database. Default: 1433
    schemas Sequence[str]
    The list of schemas to sync from. If not specified, all schemas will be discovered. Case sensitive.
    ssl_mode SourceMssqlConfigurationSslMode
    The encryption method which is used when communicating with the database.
    tunnel_method SourceMssqlConfigurationTunnelMethod
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
    additionalProperties Map<Map<String>>
    database String
    The name of the database.
    host String
    The hostname of the database.
    password String
    The password associated with the username.
    replicationMethod Property Map
    Configures how data is extracted from the database.
    username String
    The username which is used to access the database.
    additionalProperties1 String
    Parsed as JSON.
    checkPrivileges Boolean
    When this feature is enabled, during schema discovery the connector will query each table or view individually to check access privileges and inaccessible tables, views, or columns therein will be removed. In large schemas, this might cause schema discovery to take too long, in which case it might be advisable to disable this feature. Default: true
    checkpointTargetIntervalSeconds Number
    How often (in seconds) a stream should checkpoint, when possible. Default: 300
    concurrency Number
    Maximum number of concurrent queries to 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).
    port Number
    The port of the database. Default: 1433
    schemas List<String>
    The list of schemas to sync from. If not specified, all schemas will be discovered. Case sensitive.
    sslMode Property Map
    The encryption method which is used when communicating with the database.
    tunnelMethod Property Map
    Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.

    SourceMssqlConfigurationReplicationMethod, SourceMssqlConfigurationReplicationMethodArgs

    ReadChangesUsingChangeDataCaptureCdc SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdc
    \n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using MSSQL's \n\n change data capture feature\n\n. This must be enabled on your database.
    ScanChangesWithUserDefinedCursor SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursor
    Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).
    ReadChangesUsingChangeDataCaptureCdc SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdc
    \n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using MSSQL's \n\n change data capture feature\n\n. This must be enabled on your database.
    ScanChangesWithUserDefinedCursor SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursor
    Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).
    readChangesUsingChangeDataCaptureCdc SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdc
    \n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using MSSQL's \n\n change data capture feature\n\n. This must be enabled on your database.
    scanChangesWithUserDefinedCursor SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursor
    Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).
    readChangesUsingChangeDataCaptureCdc SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdc
    \n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using MSSQL's \n\n change data capture feature\n\n. This must be enabled on your database.
    scanChangesWithUserDefinedCursor SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursor
    Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).
    read_changes_using_change_data_capture_cdc SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdc
    \n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using MSSQL's \n\n change data capture feature\n\n. This must be enabled on your database.
    scan_changes_with_user_defined_cursor SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursor
    Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).
    readChangesUsingChangeDataCaptureCdc Property Map
    \n\nRecommended\n\n - Incrementally reads new inserts, updates, and deletes using MSSQL's \n\n change data capture feature\n\n. This must be enabled on your database.
    scanChangesWithUserDefinedCursor Property Map
    Incrementally detects new inserts and updates using the \n\ncursor column\n\n chosen when configuring a connection (e.g. createdat, updatedat).

    SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdc, SourceMssqlConfigurationReplicationMethodReadChangesUsingChangeDataCaptureCdcArgs

    AdditionalProperties string
    Parsed as JSON.
    InitialLoadTimeoutHours double
    The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8
    InitialWaitingSeconds double
    The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 300 seconds. Valid range: 120 seconds to 3600 seconds. Read about \n\ninitial waiting time\n\n
    InvalidCdcCursorPositionBehavior string
    Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value in the mined logs. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]
    Method string
    Default: "CDC"; must be "CDC"
    PollIntervalMs double
    How often (in milliseconds) Debezium should poll for new data. Must be smaller than heartbeat interval (15000ms). Lower values provide more responsive data capture but may increase database load. Default: 500
    AdditionalProperties string
    Parsed as JSON.
    InitialLoadTimeoutHours float64
    The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8
    InitialWaitingSeconds float64
    The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 300 seconds. Valid range: 120 seconds to 3600 seconds. Read about \n\ninitial waiting time\n\n
    InvalidCdcCursorPositionBehavior string
    Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value in the mined logs. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]
    Method string
    Default: "CDC"; must be "CDC"
    PollIntervalMs float64
    How often (in milliseconds) Debezium should poll for new data. Must be smaller than heartbeat interval (15000ms). Lower values provide more responsive data capture but may increase database load. Default: 500
    additionalProperties String
    Parsed as JSON.
    initialLoadTimeoutHours Double
    The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8
    initialWaitingSeconds Double
    The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 300 seconds. Valid range: 120 seconds to 3600 seconds. Read about \n\ninitial waiting time\n\n
    invalidCdcCursorPositionBehavior String
    Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value in the mined logs. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]
    method String
    Default: "CDC"; must be "CDC"
    pollIntervalMs Double
    How often (in milliseconds) Debezium should poll for new data. Must be smaller than heartbeat interval (15000ms). Lower values provide more responsive data capture but may increase database load. Default: 500
    additionalProperties string
    Parsed as JSON.
    initialLoadTimeoutHours number
    The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8
    initialWaitingSeconds number
    The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 300 seconds. Valid range: 120 seconds to 3600 seconds. Read about \n\ninitial waiting time\n\n
    invalidCdcCursorPositionBehavior string
    Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value in the mined logs. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]
    method string
    Default: "CDC"; must be "CDC"
    pollIntervalMs number
    How often (in milliseconds) Debezium should poll for new data. Must be smaller than heartbeat interval (15000ms). Lower values provide more responsive data capture but may increase database load. Default: 500
    additional_properties str
    Parsed as JSON.
    initial_load_timeout_hours float
    The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8
    initial_waiting_seconds float
    The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 300 seconds. Valid range: 120 seconds to 3600 seconds. Read about \n\ninitial waiting time\n\n
    invalid_cdc_cursor_position_behavior str
    Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value in the mined logs. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]
    method str
    Default: "CDC"; must be "CDC"
    poll_interval_ms float
    How often (in milliseconds) Debezium should poll for new data. Must be smaller than heartbeat interval (15000ms). Lower values provide more responsive data capture but may increase database load. Default: 500
    additionalProperties String
    Parsed as JSON.
    initialLoadTimeoutHours Number
    The amount of time an initial load is allowed to continue for before catching up on CDC logs. Default: 8
    initialWaitingSeconds Number
    The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 300 seconds. Valid range: 120 seconds to 3600 seconds. Read about \n\ninitial waiting time\n\n
    invalidCdcCursorPositionBehavior String
    Determines whether Airbyte should fail or re-sync data in case of an stale/invalid cursor value in the mined logs. If 'Fail sync' is chosen, a user will have to manually reset the connection before being able to continue syncing data. If 'Re-sync data' is chosen, Airbyte will automatically trigger a refresh but could lead to higher cloud costs and data loss. Default: "Fail sync"; must be one of ["Fail sync", "Re-sync data"]
    method String
    Default: "CDC"; must be "CDC"
    pollIntervalMs Number
    How often (in milliseconds) Debezium should poll for new data. Must be smaller than heartbeat interval (15000ms). Lower values provide more responsive data capture but may increase database load. Default: 500

    SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursor, SourceMssqlConfigurationReplicationMethodScanChangesWithUserDefinedCursorArgs

    AdditionalProperties string
    Parsed as JSON.
    ExcludeTodaysData bool
    When enabled incremental syncs using a cursor of a temporal type (date or datetime) will include cursor values only up until the previous midnight UTC. Default: false
    Method string
    Default: "STANDARD"; must be "STANDARD"
    AdditionalProperties string
    Parsed as JSON.
    ExcludeTodaysData bool
    When enabled incremental syncs using a cursor of a temporal type (date or datetime) will include cursor values only up until the previous midnight UTC. Default: false
    Method string
    Default: "STANDARD"; must be "STANDARD"
    additionalProperties String
    Parsed as JSON.
    excludeTodaysData Boolean
    When enabled incremental syncs using a cursor of a temporal type (date or datetime) will include cursor values only up until the previous midnight UTC. Default: false
    method String
    Default: "STANDARD"; must be "STANDARD"
    additionalProperties string
    Parsed as JSON.
    excludeTodaysData boolean
    When enabled incremental syncs using a cursor of a temporal type (date or datetime) will include cursor values only up until the previous midnight UTC. Default: false
    method string
    Default: "STANDARD"; must be "STANDARD"
    additional_properties str
    Parsed as JSON.
    exclude_todays_data bool
    When enabled incremental syncs using a cursor of a temporal type (date or datetime) will include cursor values only up until the previous midnight UTC. Default: false
    method str
    Default: "STANDARD"; must be "STANDARD"
    additionalProperties String
    Parsed as JSON.
    excludeTodaysData Boolean
    When enabled incremental syncs using a cursor of a temporal type (date or datetime) will include cursor values only up until the previous midnight UTC. Default: false
    method String
    Default: "STANDARD"; must be "STANDARD"

    SourceMssqlConfigurationSslMode, SourceMssqlConfigurationSslModeArgs

    EncryptedTrustServerCertificate SourceMssqlConfigurationSslModeEncryptedTrustServerCertificate
    Use the certificate provided by the server without verification. (For testing purposes only!)
    EncryptedVerifyCertificate SourceMssqlConfigurationSslModeEncryptedVerifyCertificate
    Verify and use the certificate provided by the server.
    Unencrypted SourceMssqlConfigurationSslModeUnencrypted
    Data transfer will not be encrypted.
    EncryptedTrustServerCertificate SourceMssqlConfigurationSslModeEncryptedTrustServerCertificate
    Use the certificate provided by the server without verification. (For testing purposes only!)
    EncryptedVerifyCertificate SourceMssqlConfigurationSslModeEncryptedVerifyCertificate
    Verify and use the certificate provided by the server.
    Unencrypted SourceMssqlConfigurationSslModeUnencrypted
    Data transfer will not be encrypted.
    encryptedTrustServerCertificate SourceMssqlConfigurationSslModeEncryptedTrustServerCertificate
    Use the certificate provided by the server without verification. (For testing purposes only!)
    encryptedVerifyCertificate SourceMssqlConfigurationSslModeEncryptedVerifyCertificate
    Verify and use the certificate provided by the server.
    unencrypted SourceMssqlConfigurationSslModeUnencrypted
    Data transfer will not be encrypted.
    encryptedTrustServerCertificate SourceMssqlConfigurationSslModeEncryptedTrustServerCertificate
    Use the certificate provided by the server without verification. (For testing purposes only!)
    encryptedVerifyCertificate SourceMssqlConfigurationSslModeEncryptedVerifyCertificate
    Verify and use the certificate provided by the server.
    unencrypted SourceMssqlConfigurationSslModeUnencrypted
    Data transfer will not be encrypted.
    encrypted_trust_server_certificate SourceMssqlConfigurationSslModeEncryptedTrustServerCertificate
    Use the certificate provided by the server without verification. (For testing purposes only!)
    encrypted_verify_certificate SourceMssqlConfigurationSslModeEncryptedVerifyCertificate
    Verify and use the certificate provided by the server.
    unencrypted SourceMssqlConfigurationSslModeUnencrypted
    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
    Data transfer will not be encrypted.

    SourceMssqlConfigurationSslModeEncryptedTrustServerCertificate, SourceMssqlConfigurationSslModeEncryptedTrustServerCertificateArgs

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

    SourceMssqlConfigurationSslModeEncryptedVerifyCertificate, SourceMssqlConfigurationSslModeEncryptedVerifyCertificateArgs

    AdditionalProperties string
    Parsed as JSON.
    Certificate string
    certificate of the server, or of the CA that signed the server certificate
    HostNameInCertificate string
    Specifies the host name of the server. The value of this property must match the subject property of the certificate.
    Mode string
    Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
    AdditionalProperties string
    Parsed as JSON.
    Certificate string
    certificate of the server, or of the CA that signed the server certificate
    HostNameInCertificate string
    Specifies the host name of the server. The value of this property must match the subject property of the certificate.
    Mode string
    Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
    additionalProperties String
    Parsed as JSON.
    certificate String
    certificate of the server, or of the CA that signed the server certificate
    hostNameInCertificate String
    Specifies the host name of the server. The value of this property must match the subject property of the certificate.
    mode String
    Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
    additionalProperties string
    Parsed as JSON.
    certificate string
    certificate of the server, or of the CA that signed the server certificate
    hostNameInCertificate string
    Specifies the host name of the server. The value of this property must match the subject property of the certificate.
    mode string
    Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
    additional_properties str
    Parsed as JSON.
    certificate str
    certificate of the server, or of the CA that signed the server certificate
    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.
    mode str
    Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"
    additionalProperties String
    Parsed as JSON.
    certificate String
    certificate of the server, or of the CA that signed the server certificate
    hostNameInCertificate String
    Specifies the host name of the server. The value of this property must match the subject property of the certificate.
    mode String
    Default: "encryptedverifycertificate"; must be "encryptedverifycertificate"

    SourceMssqlConfigurationSslModeUnencrypted, SourceMssqlConfigurationSslModeUnencryptedArgs

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

    SourceMssqlConfigurationTunnelMethod, SourceMssqlConfigurationTunnelMethodArgs

    NoTunnel SourceMssqlConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    PasswordAuthentication SourceMssqlConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    SshKeyAuthentication SourceMssqlConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    NoTunnel SourceMssqlConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    PasswordAuthentication SourceMssqlConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    SshKeyAuthentication SourceMssqlConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    noTunnel SourceMssqlConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    passwordAuthentication SourceMssqlConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    sshKeyAuthentication SourceMssqlConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    noTunnel SourceMssqlConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    passwordAuthentication SourceMssqlConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    sshKeyAuthentication SourceMssqlConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    no_tunnel SourceMssqlConfigurationTunnelMethodNoTunnel
    No ssh tunnel needed to connect to database
    password_authentication SourceMssqlConfigurationTunnelMethodPasswordAuthentication
    Connect through a jump server tunnel host using username and password authentication
    ssh_key_authentication SourceMssqlConfigurationTunnelMethodSshKeyAuthentication
    Connect through a jump server tunnel host using username and ssh key
    noTunnel Property Map
    No ssh tunnel needed to connect to database
    passwordAuthentication Property Map
    Connect through a jump server tunnel host using username and password authentication
    sshKeyAuthentication Property Map
    Connect through a jump server tunnel host using username and ssh key

    SourceMssqlConfigurationTunnelMethodNoTunnel, SourceMssqlConfigurationTunnelMethodNoTunnelArgs

    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    additionalProperties string
    Parsed as JSON.
    tunnelMethod string
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    additional_properties str
    Parsed as JSON.
    tunnel_method str
    Default: "NOTUNNEL"; must be "NOTUNNEL"
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "NOTUNNEL"; must be "NOTUNNEL"

    SourceMssqlConfigurationTunnelMethodPasswordAuthentication, SourceMssqlConfigurationTunnelMethodPasswordAuthenticationArgs

    TunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    TunnelUser string
    OS-level username for logging into the jump server host
    TunnelUserPassword string
    OS-level password for logging into the jump server host
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    TunnelPort double
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    TunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    TunnelUser string
    OS-level username for logging into the jump server host
    TunnelUserPassword string
    OS-level password for logging into the jump server host
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    TunnelPort float64
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    tunnelHost String
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser String
    OS-level username for logging into the jump server host
    tunnelUserPassword String
    OS-level password for logging into the jump server host
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    tunnelPort Double
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    tunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser string
    OS-level username for logging into the jump server host
    tunnelUserPassword string
    OS-level password for logging into the jump server host
    additionalProperties string
    Parsed as JSON.
    tunnelMethod string
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    tunnelPort number
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    tunnel_host str
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnel_user str
    OS-level username for logging into the jump server host
    tunnel_user_password str
    OS-level password for logging into the jump server host
    additional_properties str
    Parsed as JSON.
    tunnel_method str
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    tunnel_port float
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    tunnelHost String
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser String
    OS-level username for logging into the jump server host
    tunnelUserPassword String
    OS-level password for logging into the jump server host
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "SSHPASSWORDAUTH"; must be "SSHPASSWORDAUTH"
    tunnelPort Number
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

    SourceMssqlConfigurationTunnelMethodSshKeyAuthentication, SourceMssqlConfigurationTunnelMethodSshKeyAuthenticationArgs

    SshKey string
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    TunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    TunnelUser string
    OS-level username for logging into the jump server host
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    TunnelPort double
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    SshKey string
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    TunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    TunnelUser string
    OS-level username for logging into the jump server host
    AdditionalProperties string
    Parsed as JSON.
    TunnelMethod string
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    TunnelPort float64
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    sshKey String
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    tunnelHost String
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser String
    OS-level username for logging into the jump server host
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    tunnelPort Double
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    sshKey string
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    tunnelHost string
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser string
    OS-level username for logging into the jump server host
    additionalProperties string
    Parsed as JSON.
    tunnelMethod string
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    tunnelPort number
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    ssh_key str
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    tunnel_host str
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnel_user str
    OS-level username for logging into the jump server host
    additional_properties str
    Parsed as JSON.
    tunnel_method str
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    tunnel_port float
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22
    sshKey String
    OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
    tunnelHost String
    Hostname of the jump server host that allows inbound ssh tunnel.
    tunnelUser String
    OS-level username for logging into the jump server host
    additionalProperties String
    Parsed as JSON.
    tunnelMethod String
    Default: "SSHKEYAUTH"; must be "SSHKEYAUTH"
    tunnelPort Number
    Port on the proxy/jump server that accepts inbound ssh connections. Default: 22

    SourceMssqlResourceAllocation, SourceMssqlResourceAllocationArgs

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

    SourceMssqlResourceAllocationDefault, SourceMssqlResourceAllocationDefaultArgs

    SourceMssqlResourceAllocationJobSpecific, SourceMssqlResourceAllocationJobSpecificArgs

    JobType string
    enum that describes the different types of jobs that the platform runs.
    ResourceRequirements SourceMssqlResourceAllocationJobSpecificResourceRequirements
    optional resource requirements to run workers (blank for unbounded allocations)
    JobType string
    enum that describes the different types of jobs that the platform runs.
    ResourceRequirements SourceMssqlResourceAllocationJobSpecificResourceRequirements
    optional resource requirements to run workers (blank for unbounded allocations)
    jobType String
    enum that describes the different types of jobs that the platform runs.
    resourceRequirements SourceMssqlResourceAllocationJobSpecificResourceRequirements
    optional resource requirements to run workers (blank for unbounded allocations)
    jobType string
    enum that describes the different types of jobs that the platform runs.
    resourceRequirements SourceMssqlResourceAllocationJobSpecificResourceRequirements
    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.
    resource_requirements SourceMssqlResourceAllocationJobSpecificResourceRequirements
    optional resource requirements to run workers (blank for unbounded allocations)
    jobType String
    enum that describes the different types of jobs that the platform runs.
    resourceRequirements Property Map
    optional resource requirements to run workers (blank for unbounded allocations)

    SourceMssqlResourceAllocationJobSpecificResourceRequirements, SourceMssqlResourceAllocationJobSpecificResourceRequirementsArgs

    Import

    In Terraform v1.5.0 and later, the import block can be used with the id attribute, for example:

    terraform

    import {

    to = airbyte_source_mssql.my_airbyte_source_mssql

    id = “…”

    }

    The pulumi import command can be used, for example:

    $ pulumi import airbyte:index/sourceMssql:SourceMssql my_airbyte_source_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 logo
    airbyte 1.0.0-rc6 published on Monday, Feb 16, 2026 by airbytehq
    Schema (JSON)
    airbytehq/terraform-provider-airbyte
      Meet Neo: Your AI Platform Teammate