1. Packages
  2. Fivetran Provider
  3. API Docs
  4. getDestination
fivetran 1.6.1 published on Monday, Mar 31, 2025 by fivetran

fivetran.getDestination

Explore with Pulumi AI

This data source returns a destination object.

Example Usage

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

const dest = fivetran.getDestination({
    id: "anonymous_mystery",
});
Copy
import pulumi
import pulumi_fivetran as fivetran

dest = fivetran.get_destination(id="anonymous_mystery")
Copy
package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := fivetran.LookupDestination(ctx, &fivetran.LookupDestinationArgs{
			Id: "anonymous_mystery",
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Fivetran = Pulumi.Fivetran;

return await Deployment.RunAsync(() => 
{
    var dest = Fivetran.GetDestination.Invoke(new()
    {
        Id = "anonymous_mystery",
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.fivetran.FivetranFunctions;
import com.pulumi.fivetran.inputs.GetDestinationArgs;
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) {
        final var dest = FivetranFunctions.getDestination(GetDestinationArgs.builder()
            .id("anonymous_mystery")
            .build());

    }
}
Copy
variables:
  dest:
    fn::invoke:
      function: fivetran:getDestination
      arguments:
        id: anonymous_mystery
Copy

Using getDestination

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getDestination(args: GetDestinationArgs, opts?: InvokeOptions): Promise<GetDestinationResult>
function getDestinationOutput(args: GetDestinationOutputArgs, opts?: InvokeOptions): Output<GetDestinationResult>
Copy
def get_destination(config: Optional[GetDestinationConfig] = None,
                    id: Optional[str] = None,
                    opts: Optional[InvokeOptions] = None) -> GetDestinationResult
def get_destination_output(config: Optional[pulumi.Input[GetDestinationConfigArgs]] = None,
                    id: Optional[pulumi.Input[str]] = None,
                    opts: Optional[InvokeOptions] = None) -> Output[GetDestinationResult]
Copy
func LookupDestination(ctx *Context, args *LookupDestinationArgs, opts ...InvokeOption) (*LookupDestinationResult, error)
func LookupDestinationOutput(ctx *Context, args *LookupDestinationOutputArgs, opts ...InvokeOption) LookupDestinationResultOutput
Copy

> Note: This function is named LookupDestination in the Go SDK.

public static class GetDestination 
{
    public static Task<GetDestinationResult> InvokeAsync(GetDestinationArgs args, InvokeOptions? opts = null)
    public static Output<GetDestinationResult> Invoke(GetDestinationInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetDestinationResult> getDestination(GetDestinationArgs args, InvokeOptions options)
public static Output<GetDestinationResult> getDestination(GetDestinationArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: fivetran:index/getDestination:getDestination
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

Id This property is required. string
Config GetDestinationConfig
Id This property is required. string
Config GetDestinationConfig
id This property is required. String
config GetDestinationConfig
id This property is required. string
config GetDestinationConfig
id This property is required. str
config GetDestinationConfig
id This property is required. String
config Property Map

getDestination Result

The following output properties are available:

Supporting Types

GetDestinationConfig

AlwaysEncrypted This property is required. bool
Field usage depends on service value: - Service aurora_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service panoply: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service redshift: Require TLS through Tunnel - Service sql_server_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel.
Auth This property is required. string
Field usage depends on service value: - Service snowflake: Password-based or key-based authentication type
AuthType This property is required. string
Field usage depends on service value: - Service adls: Authentication type - Service databricks: Authentication type - Service new_s3_datalake: Authentication type - Service onelake: Authentication type - Service redshift: Authentication type. Default value: PASSWORD.
AwsAccessKeyId This property is required. string
Field usage depends on service value: - Service new_s3_datalake: AWS access key to access the S3 bucket and AWS Glue
AwsSecretAccessKey This property is required. string
Field usage depends on service value: - Service new_s3_datalake: AWS secret access key to access the S3 bucket and AWS Glue
BootstrapServers This property is required. List<string>
Field usage depends on service value: - Service confluent_cloud_wh: Comma-separated list of Confluent Cloud servers in the server:port format.
Bucket This property is required. string
Field usage depends on service value: - Service big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service big_query_dts: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service managed_big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service new_s3_datalake: (Immutable) The name of the bucket to be used as destination
Catalog This property is required. string
Field usage depends on service value: - Service adls: Catalog name - Service databricks: Catalog name - Service new_s3_datalake: Catalog name - Service onelake: Catalog name
ClientId This property is required. string
Field usage depends on service value: - Service adls: Client id of service principal - Service onelake: Client ID of service principal
CloudProvider This property is required. string
Field usage depends on service value: - Service databricks: Databricks deployment cloud
ClusterId This property is required. string
Field usage depends on service value: - Service panoply: Cluster ID. - Service periscope_warehouse: Cluster ID. - Service redshift: Cluster ID. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
ClusterRegion This property is required. string
Field usage depends on service value: - Service panoply: Cluster region. - Service periscope_warehouse: Cluster region. - Service redshift: Cluster region. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
ConnectionMethod This property is required. string
ConnectionType This property is required. string
Field usage depends on service value: - Service adls: Connection method. Default value: Directly. - Service aurora_postgres_warehouse: Connection method. Default value: Directly. - Service aurora_warehouse: Connection method. Default value: Directly. - Service azure_postgres_warehouse: Connection method. Default value: Directly. - Service azure_sql_data_warehouse: Connection method. Default value: Directly. - Service azure_sql_database: Connection method. Default value: Directly. - Service azure_sql_managed_db_warehouse: Connection method. Default value: Directly. - Service databricks: Connection method. Default value: Directly. - Service maria_rds_warehouse: Connection method. Default value: Directly. - Service maria_warehouse: Connection method. Default value: Directly. - Service mysql_rds_warehouse: Connection method. Default value: Directly. - Service mysql_warehouse: Connection method. Default value: Directly. - Service panoply: Connection method. Default value: Directly. - Service periscope_warehouse: Connection method. Default value: Directly. - Service postgres_gcp_warehouse: Connection method. Default value: Directly. - Service postgres_rds_warehouse: Connection method. Default value: Directly. - Service postgres_warehouse: Connection method. Default value: Directly. - Service redshift: Connection method. Default value: Directly. - Service snowflake: Connection method. Default value: Directly. - Service sql_server_rds_warehouse: Connection method. Default value: Directly. - Service sql_server_warehouse: Connection method. Default value: Directly.
ContainerName This property is required. string
Field usage depends on service value: - Service adls: (Immutable) Container to store delta table files - Service onelake: Workspace name to store delta table files
ControllerId This property is required. string
CreateExternalTables This property is required. bool
Field usage depends on service value: - Service databricks: Whether to create external tables
DataFormat This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud message format.
DataSetLocation This property is required. string
Field usage depends on service value: - Service big_query: Data location. Datasets will reside in this location. - Service big_query_dts: Data location. Datasets will reside in this location. - Service managed_big_query: Data location. Datasets will reside in this location.
Database This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Database name - Service aurora_warehouse: Database name - Service azure_postgres_warehouse: Database name - Service azure_sql_data_warehouse: Database name - Service azure_sql_database: Database name - Service azure_sql_managed_db_warehouse: Database name - Service maria_rds_warehouse: Database name - Service maria_warehouse: Database name - Service mysql_rds_warehouse: Database name - Service mysql_warehouse: Database name - Service panoply: Database name - Service periscope_warehouse: Database name - Service postgres_gcp_warehouse: Database name - Service postgres_rds_warehouse: Database name - Service postgres_warehouse: Database name - Service redshift: Database name - Service snowflake: Database name - Service sql_server_rds_warehouse: Database name - Service sql_server_warehouse: Database name
DatabricksConnectionType This property is required. string
Field usage depends on service value: - Service adls: Databricks Connection method. Default value: Directly. - Service new_s3_datalake: Databricks Connection method. Default value: Directly. - Service onelake: Databricks Connection method. Default value: Directly.
EnableRemoteExecution This property is required. bool
ExternalId This property is required. string
Field usage depends on service value: - Service aws_msk_wh: Fivetran generated External ID - Service panoply: Fivetran generated External ID - Service periscope_warehouse: Fivetran generated External ID - Service redshift: Fivetran generated External ID
ExternalLocation This property is required. string
Field usage depends on service value: - Service databricks: External location to store Delta tables. Default value: "" (null). By default, the external tables will reside in the /{schema}/{table} path, and if you specify an external location in the {externalLocation}/{schema}/{table} path.
FivetranGlueRoleArn This property is required. string
FivetranMskRoleArn This property is required. string
FivetranRoleArn This property is required. string
Field usage depends on service value: - Service new_s3_datalake: ARN of the role which you created with different required policy mentioned in our setup guide
Host This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Server name - Service aurora_warehouse: Server name - Service azure_postgres_warehouse: Server name - Service azure_sql_data_warehouse: Server name - Service azure_sql_database: Server name - Service azure_sql_managed_db_warehouse: Server name - Service maria_rds_warehouse: Server name - Service maria_warehouse: Server name - Service mysql_rds_warehouse: Server name - Service mysql_warehouse: Server name - Service panoply: Server name - Service periscope_warehouse: Server name - Service postgres_gcp_warehouse: Server name - Service postgres_rds_warehouse: Server name - Service postgres_warehouse: Server name - Service redshift: Server name - Service snowflake: Server name - Service sql_server_rds_warehouse: Server name - Service sql_server_warehouse: Server name
HttpPath This property is required. string
Field usage depends on service value: - Service adls: HTTP path - Service databricks: HTTP path - Service new_s3_datalake: HTTP path - Service onelake: HTTP path
IsPrivateKeyEncrypted This property is required. bool
Field usage depends on service value: - Service snowflake: Indicates that a private key is encrypted. The default value: false. The field can be specified if authentication type is KEY_PAIR.
IsPrivateLinkRequired This property is required. bool
Field usage depends on service value: - Service new_s3_datalake: We use PrivateLink by default if your s3 bucket is in the same region as Fivetran. Turning on this toggle ensures that Fivetran always connects to s3 bucket over PrivateLink. Learn more in our PrivateLink documentation.
IsRedshiftServerless This property is required. bool
Field usage depends on service value: - Service redshift: Is your destination Redshift Serverless
LakehouseGuid This property is required. string
Field usage depends on service value: - Service onelake: (Immutable) OneLake lakehouse GUID
LakehouseName This property is required. string
Field usage depends on service value: - Service onelake: (Immutable) Name of your lakehouse
MskStsRegion This property is required. string
NumOfPartitions This property is required. double
Field usage depends on service value: - Service confluent_cloud_wh: Number of partitions per topic.
Oauth2ClientId This property is required. string
Field usage depends on service value: - Service adls: OAuth 2.0 client ID - Service databricks: OAuth 2.0 client ID - Service new_s3_datalake: OAuth 2.0 client ID - Service onelake: OAuth 2.0 client ID
Oauth2Secret This property is required. string
Field usage depends on service value: - Service adls: OAuth 2.0 secret - Service databricks: OAuth 2.0 secret - Service new_s3_datalake: OAuth 2.0 secret - Service onelake: OAuth 2.0 secret
Passphrase This property is required. string
Field usage depends on service value: - Service snowflake: In case private key is encrypted, you are required to enter passphrase that was used to encrypt the private key. The field can be specified if authentication type is KEY_PAIR.
Password This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user password - Service aurora_warehouse: Database user password - Service azure_postgres_warehouse: Database user password - Service azure_sql_data_warehouse: Database user password - Service azure_sql_database: Database user password - Service azure_sql_managed_db_warehouse: Database user password - Service maria_rds_warehouse: Database user password - Service maria_warehouse: Database user password - Service mysql_rds_warehouse: Database user password - Service mysql_warehouse: Database user password - Service panoply: Database user password - Service periscope_warehouse: Database user password - Service postgres_gcp_warehouse: Database user password - Service postgres_rds_warehouse: Database user password - Service postgres_warehouse: Database user password - Service redshift: Database user password. Required if authentication type is PASSWORD. - Service snowflake: Database user password. The field should be specified if authentication type is PASSWORD. - Service sql_server_rds_warehouse: Database user password - Service sql_server_warehouse: Database user password
PersonalAccessToken This property is required. string
Field usage depends on service value: - Service adls: Personal access token - Service databricks: Personal access token - Service new_s3_datalake: Personal access token - Service onelake: Personal access token
Port This property is required. double
Field usage depends on service value: - Service adls: Server port number - Service aurora_postgres_warehouse: Server port number - Service aurora_warehouse: Server port number - Service azure_postgres_warehouse: Server port number - Service azure_sql_data_warehouse: Server port number - Service azure_sql_database: Server port number - Service azure_sql_managed_db_warehouse: Server port number - Service databricks: Server port number - Service maria_rds_warehouse: Server port number - Service maria_warehouse: Server port number - Service mysql_rds_warehouse: Server port number - Service mysql_warehouse: Server port number - Service new_s3_datalake: Server port number - Service onelake: Server port number - Service panoply: Server port number - Service periscope_warehouse: Server port number - Service postgres_gcp_warehouse: Server port number - Service postgres_rds_warehouse: Server port number - Service postgres_warehouse: Server port number - Service redshift: Server port number - Service snowflake: Server port number - Service sql_server_rds_warehouse: Server port number - Service sql_server_warehouse: Server port number
PrefixPath This property is required. string
Field usage depends on service value: - Service adls: (Immutable) path/to/data within the container - Service new_s3_datalake: (Immutable) Prefix path of the bucket for which you have configured access policy. It is not required if access has been granted to entire Bucket in the access policy - Service onelake: (Immutable) path/to/data within your lakehouse inside the Files directory
PrivateKey This property is required. string
Field usage depends on service value: - Service snowflake: Private access key. The field should be specified if authentication type is KEY_PAIR.
ProjectId This property is required. string
Field usage depends on service value: - Service big_query: BigQuery project ID
PublicKey This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Public Key - Service aurora_warehouse: Public Key - Service azure_postgres_warehouse: Public Key - Service azure_sql_data_warehouse: Public Key - Service azure_sql_database: Public Key - Service azure_sql_managed_db_warehouse: Public Key - Service maria_rds_warehouse: Public Key - Service maria_warehouse: Public Key - Service mysql_rds_warehouse: Public Key - Service mysql_warehouse: Public Key - Service panoply: Public Key - Service periscope_warehouse: Public Key - Service postgres_gcp_warehouse: Public Key - Service postgres_rds_warehouse: Public Key - Service postgres_warehouse: Public Key - Service redshift: Public Key - Service sql_server_rds_warehouse: Public Key - Service sql_server_warehouse: Public Key
Region This property is required. string
Field usage depends on service value: - Service new_s3_datalake: Region of your AWS S3 bucket
RegistryName This property is required. string
RegistryStsRegion This property is required. string
ReplicationFactor This property is required. double
Field usage depends on service value: - Service confluent_cloud_wh: Replication factor.
ResourceId This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service aurora_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_data_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_database: Field to test Self serve Private Link - Service azure_sql_managed_db_warehouse: Field to test Self serve Private Link - Service databricks: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service panoply: This field is currently being introduced to test the Self-serve Private Link functionality - Service periscope_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_gcp_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service redshift: This field is currently being introduced to test the Self-serve Private Link functionality - Service snowflake: This field is currently being introduced to test the Self-serve Private Link functionality - Service sql_server_rds_warehouse: Field to test Self serve Private Link - Service sql_server_warehouse: Field to test Self serve Private Link
Role This property is required. string
Field usage depends on service value: - Service snowflake: If not specified, Fivetran will use the user's default role
RoleArn This property is required. string
Field usage depends on service value: - Service redshift: Role ARN with Redshift permissions. Required if authentication type is IAM.
SaslMechanism This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
SaslPlainKey This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL key.
SaslPlainSecret This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL secret.
SchemaCompatibility This property is required. string
SchemaRegistry This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema Registry
SchemaRegistryApiKey This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API key.
SchemaRegistryApiSecret This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API secret.
SchemaRegistryUrl This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry URL.
SecretKey This property is required. string
Field usage depends on service value: - Service big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service big_query_dts: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service managed_big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account.
SecretValue This property is required. string
Field usage depends on service value: - Service adls: Secret value for service principal - Service onelake: Secret value for service principal
SecurityProtocol This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
ServerHostName This property is required. string
Field usage depends on service value: - Service adls: Server Host name - Service databricks: Server name - Service new_s3_datalake: Server host name - Service onelake: Server Host name
ShouldMaintainTablesInDatabricks This property is required. bool
Field usage depends on service value: - Service adls: Should maintain tables in Databricks - Service new_s3_datalake: Should maintain tables in Databricks - Service onelake: Should maintain tables in Databricks
SnapshotRetentionPeriod This property is required. string
Field usage depends on service value: - Service adls: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service new_s3_datalake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service onelake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK.
SnowflakeCloud This property is required. string
SnowflakeRegion This property is required. string
StorageAccountName This property is required. string
Field usage depends on service value: - Service adls: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Service onelake: (Immutable) Storage account for Azure Data Lake Storage Gen2 name
TableFormat This property is required. string
Field usage depends on service value: - Service new_s3_datalake: (Immutable) The table format in which you want to sync your tables. Valid values are ICEBERG and DELTA_LAKE
TenantId This property is required. string
Field usage depends on service value: - Service adls: Tenant id of service principal - Service onelake: Tenant ID of service principal
TunnelHost This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel.
TunnelPort This property is required. double
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel.
TunnelUser This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel.
User This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user name - Service aurora_warehouse: Database user name - Service azure_postgres_warehouse: Database user name - Service azure_sql_data_warehouse: Database user name - Service azure_sql_database: Database user name - Service azure_sql_managed_db_warehouse: Database user name - Service maria_rds_warehouse: Database user name - Service maria_warehouse: Database user name - Service mysql_rds_warehouse: Database user name - Service mysql_warehouse: Database user name - Service panoply: Database user name - Service periscope_warehouse: Database user name - Service postgres_gcp_warehouse: Database user name - Service postgres_rds_warehouse: Database user name - Service postgres_warehouse: Database user name - Service redshift: Database user name - Service snowflake: Database user name - Service sql_server_rds_warehouse: Database user name - Service sql_server_warehouse: Database user name
WorkspaceGuid This property is required. string
Field usage depends on service value: - Service onelake: (Immutable) OneLake workspace GUID
WorkspaceName This property is required. string
Field usage depends on service value: - Service onelake: OneLake workspace name
AlwaysEncrypted This property is required. bool
Field usage depends on service value: - Service aurora_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service panoply: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service redshift: Require TLS through Tunnel - Service sql_server_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel.
Auth This property is required. string
Field usage depends on service value: - Service snowflake: Password-based or key-based authentication type
AuthType This property is required. string
Field usage depends on service value: - Service adls: Authentication type - Service databricks: Authentication type - Service new_s3_datalake: Authentication type - Service onelake: Authentication type - Service redshift: Authentication type. Default value: PASSWORD.
AwsAccessKeyId This property is required. string
Field usage depends on service value: - Service new_s3_datalake: AWS access key to access the S3 bucket and AWS Glue
AwsSecretAccessKey This property is required. string
Field usage depends on service value: - Service new_s3_datalake: AWS secret access key to access the S3 bucket and AWS Glue
BootstrapServers This property is required. []string
Field usage depends on service value: - Service confluent_cloud_wh: Comma-separated list of Confluent Cloud servers in the server:port format.
Bucket This property is required. string
Field usage depends on service value: - Service big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service big_query_dts: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service managed_big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service new_s3_datalake: (Immutable) The name of the bucket to be used as destination
Catalog This property is required. string
Field usage depends on service value: - Service adls: Catalog name - Service databricks: Catalog name - Service new_s3_datalake: Catalog name - Service onelake: Catalog name
ClientId This property is required. string
Field usage depends on service value: - Service adls: Client id of service principal - Service onelake: Client ID of service principal
CloudProvider This property is required. string
Field usage depends on service value: - Service databricks: Databricks deployment cloud
ClusterId This property is required. string
Field usage depends on service value: - Service panoply: Cluster ID. - Service periscope_warehouse: Cluster ID. - Service redshift: Cluster ID. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
ClusterRegion This property is required. string
Field usage depends on service value: - Service panoply: Cluster region. - Service periscope_warehouse: Cluster region. - Service redshift: Cluster region. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
ConnectionMethod This property is required. string
ConnectionType This property is required. string
Field usage depends on service value: - Service adls: Connection method. Default value: Directly. - Service aurora_postgres_warehouse: Connection method. Default value: Directly. - Service aurora_warehouse: Connection method. Default value: Directly. - Service azure_postgres_warehouse: Connection method. Default value: Directly. - Service azure_sql_data_warehouse: Connection method. Default value: Directly. - Service azure_sql_database: Connection method. Default value: Directly. - Service azure_sql_managed_db_warehouse: Connection method. Default value: Directly. - Service databricks: Connection method. Default value: Directly. - Service maria_rds_warehouse: Connection method. Default value: Directly. - Service maria_warehouse: Connection method. Default value: Directly. - Service mysql_rds_warehouse: Connection method. Default value: Directly. - Service mysql_warehouse: Connection method. Default value: Directly. - Service panoply: Connection method. Default value: Directly. - Service periscope_warehouse: Connection method. Default value: Directly. - Service postgres_gcp_warehouse: Connection method. Default value: Directly. - Service postgres_rds_warehouse: Connection method. Default value: Directly. - Service postgres_warehouse: Connection method. Default value: Directly. - Service redshift: Connection method. Default value: Directly. - Service snowflake: Connection method. Default value: Directly. - Service sql_server_rds_warehouse: Connection method. Default value: Directly. - Service sql_server_warehouse: Connection method. Default value: Directly.
ContainerName This property is required. string
Field usage depends on service value: - Service adls: (Immutable) Container to store delta table files - Service onelake: Workspace name to store delta table files
ControllerId This property is required. string
CreateExternalTables This property is required. bool
Field usage depends on service value: - Service databricks: Whether to create external tables
DataFormat This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud message format.
DataSetLocation This property is required. string
Field usage depends on service value: - Service big_query: Data location. Datasets will reside in this location. - Service big_query_dts: Data location. Datasets will reside in this location. - Service managed_big_query: Data location. Datasets will reside in this location.
Database This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Database name - Service aurora_warehouse: Database name - Service azure_postgres_warehouse: Database name - Service azure_sql_data_warehouse: Database name - Service azure_sql_database: Database name - Service azure_sql_managed_db_warehouse: Database name - Service maria_rds_warehouse: Database name - Service maria_warehouse: Database name - Service mysql_rds_warehouse: Database name - Service mysql_warehouse: Database name - Service panoply: Database name - Service periscope_warehouse: Database name - Service postgres_gcp_warehouse: Database name - Service postgres_rds_warehouse: Database name - Service postgres_warehouse: Database name - Service redshift: Database name - Service snowflake: Database name - Service sql_server_rds_warehouse: Database name - Service sql_server_warehouse: Database name
DatabricksConnectionType This property is required. string
Field usage depends on service value: - Service adls: Databricks Connection method. Default value: Directly. - Service new_s3_datalake: Databricks Connection method. Default value: Directly. - Service onelake: Databricks Connection method. Default value: Directly.
EnableRemoteExecution This property is required. bool
ExternalId This property is required. string
Field usage depends on service value: - Service aws_msk_wh: Fivetran generated External ID - Service panoply: Fivetran generated External ID - Service periscope_warehouse: Fivetran generated External ID - Service redshift: Fivetran generated External ID
ExternalLocation This property is required. string
Field usage depends on service value: - Service databricks: External location to store Delta tables. Default value: "" (null). By default, the external tables will reside in the /{schema}/{table} path, and if you specify an external location in the {externalLocation}/{schema}/{table} path.
FivetranGlueRoleArn This property is required. string
FivetranMskRoleArn This property is required. string
FivetranRoleArn This property is required. string
Field usage depends on service value: - Service new_s3_datalake: ARN of the role which you created with different required policy mentioned in our setup guide
Host This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Server name - Service aurora_warehouse: Server name - Service azure_postgres_warehouse: Server name - Service azure_sql_data_warehouse: Server name - Service azure_sql_database: Server name - Service azure_sql_managed_db_warehouse: Server name - Service maria_rds_warehouse: Server name - Service maria_warehouse: Server name - Service mysql_rds_warehouse: Server name - Service mysql_warehouse: Server name - Service panoply: Server name - Service periscope_warehouse: Server name - Service postgres_gcp_warehouse: Server name - Service postgres_rds_warehouse: Server name - Service postgres_warehouse: Server name - Service redshift: Server name - Service snowflake: Server name - Service sql_server_rds_warehouse: Server name - Service sql_server_warehouse: Server name
HttpPath This property is required. string
Field usage depends on service value: - Service adls: HTTP path - Service databricks: HTTP path - Service new_s3_datalake: HTTP path - Service onelake: HTTP path
IsPrivateKeyEncrypted This property is required. bool
Field usage depends on service value: - Service snowflake: Indicates that a private key is encrypted. The default value: false. The field can be specified if authentication type is KEY_PAIR.
IsPrivateLinkRequired This property is required. bool
Field usage depends on service value: - Service new_s3_datalake: We use PrivateLink by default if your s3 bucket is in the same region as Fivetran. Turning on this toggle ensures that Fivetran always connects to s3 bucket over PrivateLink. Learn more in our PrivateLink documentation.
IsRedshiftServerless This property is required. bool
Field usage depends on service value: - Service redshift: Is your destination Redshift Serverless
LakehouseGuid This property is required. string
Field usage depends on service value: - Service onelake: (Immutable) OneLake lakehouse GUID
LakehouseName This property is required. string
Field usage depends on service value: - Service onelake: (Immutable) Name of your lakehouse
MskStsRegion This property is required. string
NumOfPartitions This property is required. float64
Field usage depends on service value: - Service confluent_cloud_wh: Number of partitions per topic.
Oauth2ClientId This property is required. string
Field usage depends on service value: - Service adls: OAuth 2.0 client ID - Service databricks: OAuth 2.0 client ID - Service new_s3_datalake: OAuth 2.0 client ID - Service onelake: OAuth 2.0 client ID
Oauth2Secret This property is required. string
Field usage depends on service value: - Service adls: OAuth 2.0 secret - Service databricks: OAuth 2.0 secret - Service new_s3_datalake: OAuth 2.0 secret - Service onelake: OAuth 2.0 secret
Passphrase This property is required. string
Field usage depends on service value: - Service snowflake: In case private key is encrypted, you are required to enter passphrase that was used to encrypt the private key. The field can be specified if authentication type is KEY_PAIR.
Password This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user password - Service aurora_warehouse: Database user password - Service azure_postgres_warehouse: Database user password - Service azure_sql_data_warehouse: Database user password - Service azure_sql_database: Database user password - Service azure_sql_managed_db_warehouse: Database user password - Service maria_rds_warehouse: Database user password - Service maria_warehouse: Database user password - Service mysql_rds_warehouse: Database user password - Service mysql_warehouse: Database user password - Service panoply: Database user password - Service periscope_warehouse: Database user password - Service postgres_gcp_warehouse: Database user password - Service postgres_rds_warehouse: Database user password - Service postgres_warehouse: Database user password - Service redshift: Database user password. Required if authentication type is PASSWORD. - Service snowflake: Database user password. The field should be specified if authentication type is PASSWORD. - Service sql_server_rds_warehouse: Database user password - Service sql_server_warehouse: Database user password
PersonalAccessToken This property is required. string
Field usage depends on service value: - Service adls: Personal access token - Service databricks: Personal access token - Service new_s3_datalake: Personal access token - Service onelake: Personal access token
Port This property is required. float64
Field usage depends on service value: - Service adls: Server port number - Service aurora_postgres_warehouse: Server port number - Service aurora_warehouse: Server port number - Service azure_postgres_warehouse: Server port number - Service azure_sql_data_warehouse: Server port number - Service azure_sql_database: Server port number - Service azure_sql_managed_db_warehouse: Server port number - Service databricks: Server port number - Service maria_rds_warehouse: Server port number - Service maria_warehouse: Server port number - Service mysql_rds_warehouse: Server port number - Service mysql_warehouse: Server port number - Service new_s3_datalake: Server port number - Service onelake: Server port number - Service panoply: Server port number - Service periscope_warehouse: Server port number - Service postgres_gcp_warehouse: Server port number - Service postgres_rds_warehouse: Server port number - Service postgres_warehouse: Server port number - Service redshift: Server port number - Service snowflake: Server port number - Service sql_server_rds_warehouse: Server port number - Service sql_server_warehouse: Server port number
PrefixPath This property is required. string
Field usage depends on service value: - Service adls: (Immutable) path/to/data within the container - Service new_s3_datalake: (Immutable) Prefix path of the bucket for which you have configured access policy. It is not required if access has been granted to entire Bucket in the access policy - Service onelake: (Immutable) path/to/data within your lakehouse inside the Files directory
PrivateKey This property is required. string
Field usage depends on service value: - Service snowflake: Private access key. The field should be specified if authentication type is KEY_PAIR.
ProjectId This property is required. string
Field usage depends on service value: - Service big_query: BigQuery project ID
PublicKey This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Public Key - Service aurora_warehouse: Public Key - Service azure_postgres_warehouse: Public Key - Service azure_sql_data_warehouse: Public Key - Service azure_sql_database: Public Key - Service azure_sql_managed_db_warehouse: Public Key - Service maria_rds_warehouse: Public Key - Service maria_warehouse: Public Key - Service mysql_rds_warehouse: Public Key - Service mysql_warehouse: Public Key - Service panoply: Public Key - Service periscope_warehouse: Public Key - Service postgres_gcp_warehouse: Public Key - Service postgres_rds_warehouse: Public Key - Service postgres_warehouse: Public Key - Service redshift: Public Key - Service sql_server_rds_warehouse: Public Key - Service sql_server_warehouse: Public Key
Region This property is required. string
Field usage depends on service value: - Service new_s3_datalake: Region of your AWS S3 bucket
RegistryName This property is required. string
RegistryStsRegion This property is required. string
ReplicationFactor This property is required. float64
Field usage depends on service value: - Service confluent_cloud_wh: Replication factor.
ResourceId This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service aurora_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_data_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_database: Field to test Self serve Private Link - Service azure_sql_managed_db_warehouse: Field to test Self serve Private Link - Service databricks: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service panoply: This field is currently being introduced to test the Self-serve Private Link functionality - Service periscope_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_gcp_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service redshift: This field is currently being introduced to test the Self-serve Private Link functionality - Service snowflake: This field is currently being introduced to test the Self-serve Private Link functionality - Service sql_server_rds_warehouse: Field to test Self serve Private Link - Service sql_server_warehouse: Field to test Self serve Private Link
Role This property is required. string
Field usage depends on service value: - Service snowflake: If not specified, Fivetran will use the user's default role
RoleArn This property is required. string
Field usage depends on service value: - Service redshift: Role ARN with Redshift permissions. Required if authentication type is IAM.
SaslMechanism This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
SaslPlainKey This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL key.
SaslPlainSecret This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL secret.
SchemaCompatibility This property is required. string
SchemaRegistry This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema Registry
SchemaRegistryApiKey This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API key.
SchemaRegistryApiSecret This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API secret.
SchemaRegistryUrl This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry URL.
SecretKey This property is required. string
Field usage depends on service value: - Service big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service big_query_dts: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service managed_big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account.
SecretValue This property is required. string
Field usage depends on service value: - Service adls: Secret value for service principal - Service onelake: Secret value for service principal
SecurityProtocol This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
ServerHostName This property is required. string
Field usage depends on service value: - Service adls: Server Host name - Service databricks: Server name - Service new_s3_datalake: Server host name - Service onelake: Server Host name
ShouldMaintainTablesInDatabricks This property is required. bool
Field usage depends on service value: - Service adls: Should maintain tables in Databricks - Service new_s3_datalake: Should maintain tables in Databricks - Service onelake: Should maintain tables in Databricks
SnapshotRetentionPeriod This property is required. string
Field usage depends on service value: - Service adls: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service new_s3_datalake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service onelake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK.
SnowflakeCloud This property is required. string
SnowflakeRegion This property is required. string
StorageAccountName This property is required. string
Field usage depends on service value: - Service adls: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Service onelake: (Immutable) Storage account for Azure Data Lake Storage Gen2 name
TableFormat This property is required. string
Field usage depends on service value: - Service new_s3_datalake: (Immutable) The table format in which you want to sync your tables. Valid values are ICEBERG and DELTA_LAKE
TenantId This property is required. string
Field usage depends on service value: - Service adls: Tenant id of service principal - Service onelake: Tenant ID of service principal
TunnelHost This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel.
TunnelPort This property is required. float64
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel.
TunnelUser This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel.
User This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user name - Service aurora_warehouse: Database user name - Service azure_postgres_warehouse: Database user name - Service azure_sql_data_warehouse: Database user name - Service azure_sql_database: Database user name - Service azure_sql_managed_db_warehouse: Database user name - Service maria_rds_warehouse: Database user name - Service maria_warehouse: Database user name - Service mysql_rds_warehouse: Database user name - Service mysql_warehouse: Database user name - Service panoply: Database user name - Service periscope_warehouse: Database user name - Service postgres_gcp_warehouse: Database user name - Service postgres_rds_warehouse: Database user name - Service postgres_warehouse: Database user name - Service redshift: Database user name - Service snowflake: Database user name - Service sql_server_rds_warehouse: Database user name - Service sql_server_warehouse: Database user name
WorkspaceGuid This property is required. string
Field usage depends on service value: - Service onelake: (Immutable) OneLake workspace GUID
WorkspaceName This property is required. string
Field usage depends on service value: - Service onelake: OneLake workspace name
alwaysEncrypted This property is required. Boolean
Field usage depends on service value: - Service aurora_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service panoply: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service redshift: Require TLS through Tunnel - Service sql_server_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel.
auth This property is required. String
Field usage depends on service value: - Service snowflake: Password-based or key-based authentication type
authType This property is required. String
Field usage depends on service value: - Service adls: Authentication type - Service databricks: Authentication type - Service new_s3_datalake: Authentication type - Service onelake: Authentication type - Service redshift: Authentication type. Default value: PASSWORD.
awsAccessKeyId This property is required. String
Field usage depends on service value: - Service new_s3_datalake: AWS access key to access the S3 bucket and AWS Glue
awsSecretAccessKey This property is required. String
Field usage depends on service value: - Service new_s3_datalake: AWS secret access key to access the S3 bucket and AWS Glue
bootstrapServers This property is required. List<String>
Field usage depends on service value: - Service confluent_cloud_wh: Comma-separated list of Confluent Cloud servers in the server:port format.
bucket This property is required. String
Field usage depends on service value: - Service big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service big_query_dts: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service managed_big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service new_s3_datalake: (Immutable) The name of the bucket to be used as destination
catalog This property is required. String
Field usage depends on service value: - Service adls: Catalog name - Service databricks: Catalog name - Service new_s3_datalake: Catalog name - Service onelake: Catalog name
clientId This property is required. String
Field usage depends on service value: - Service adls: Client id of service principal - Service onelake: Client ID of service principal
cloudProvider This property is required. String
Field usage depends on service value: - Service databricks: Databricks deployment cloud
clusterId This property is required. String
Field usage depends on service value: - Service panoply: Cluster ID. - Service periscope_warehouse: Cluster ID. - Service redshift: Cluster ID. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
clusterRegion This property is required. String
Field usage depends on service value: - Service panoply: Cluster region. - Service periscope_warehouse: Cluster region. - Service redshift: Cluster region. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
connectionMethod This property is required. String
connectionType This property is required. String
Field usage depends on service value: - Service adls: Connection method. Default value: Directly. - Service aurora_postgres_warehouse: Connection method. Default value: Directly. - Service aurora_warehouse: Connection method. Default value: Directly. - Service azure_postgres_warehouse: Connection method. Default value: Directly. - Service azure_sql_data_warehouse: Connection method. Default value: Directly. - Service azure_sql_database: Connection method. Default value: Directly. - Service azure_sql_managed_db_warehouse: Connection method. Default value: Directly. - Service databricks: Connection method. Default value: Directly. - Service maria_rds_warehouse: Connection method. Default value: Directly. - Service maria_warehouse: Connection method. Default value: Directly. - Service mysql_rds_warehouse: Connection method. Default value: Directly. - Service mysql_warehouse: Connection method. Default value: Directly. - Service panoply: Connection method. Default value: Directly. - Service periscope_warehouse: Connection method. Default value: Directly. - Service postgres_gcp_warehouse: Connection method. Default value: Directly. - Service postgres_rds_warehouse: Connection method. Default value: Directly. - Service postgres_warehouse: Connection method. Default value: Directly. - Service redshift: Connection method. Default value: Directly. - Service snowflake: Connection method. Default value: Directly. - Service sql_server_rds_warehouse: Connection method. Default value: Directly. - Service sql_server_warehouse: Connection method. Default value: Directly.
containerName This property is required. String
Field usage depends on service value: - Service adls: (Immutable) Container to store delta table files - Service onelake: Workspace name to store delta table files
controllerId This property is required. String
createExternalTables This property is required. Boolean
Field usage depends on service value: - Service databricks: Whether to create external tables
dataFormat This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud message format.
dataSetLocation This property is required. String
Field usage depends on service value: - Service big_query: Data location. Datasets will reside in this location. - Service big_query_dts: Data location. Datasets will reside in this location. - Service managed_big_query: Data location. Datasets will reside in this location.
database This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Database name - Service aurora_warehouse: Database name - Service azure_postgres_warehouse: Database name - Service azure_sql_data_warehouse: Database name - Service azure_sql_database: Database name - Service azure_sql_managed_db_warehouse: Database name - Service maria_rds_warehouse: Database name - Service maria_warehouse: Database name - Service mysql_rds_warehouse: Database name - Service mysql_warehouse: Database name - Service panoply: Database name - Service periscope_warehouse: Database name - Service postgres_gcp_warehouse: Database name - Service postgres_rds_warehouse: Database name - Service postgres_warehouse: Database name - Service redshift: Database name - Service snowflake: Database name - Service sql_server_rds_warehouse: Database name - Service sql_server_warehouse: Database name
databricksConnectionType This property is required. String
Field usage depends on service value: - Service adls: Databricks Connection method. Default value: Directly. - Service new_s3_datalake: Databricks Connection method. Default value: Directly. - Service onelake: Databricks Connection method. Default value: Directly.
enableRemoteExecution This property is required. Boolean
externalId This property is required. String
Field usage depends on service value: - Service aws_msk_wh: Fivetran generated External ID - Service panoply: Fivetran generated External ID - Service periscope_warehouse: Fivetran generated External ID - Service redshift: Fivetran generated External ID
externalLocation This property is required. String
Field usage depends on service value: - Service databricks: External location to store Delta tables. Default value: "" (null). By default, the external tables will reside in the /{schema}/{table} path, and if you specify an external location in the {externalLocation}/{schema}/{table} path.
fivetranGlueRoleArn This property is required. String
fivetranMskRoleArn This property is required. String
fivetranRoleArn This property is required. String
Field usage depends on service value: - Service new_s3_datalake: ARN of the role which you created with different required policy mentioned in our setup guide
host This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Server name - Service aurora_warehouse: Server name - Service azure_postgres_warehouse: Server name - Service azure_sql_data_warehouse: Server name - Service azure_sql_database: Server name - Service azure_sql_managed_db_warehouse: Server name - Service maria_rds_warehouse: Server name - Service maria_warehouse: Server name - Service mysql_rds_warehouse: Server name - Service mysql_warehouse: Server name - Service panoply: Server name - Service periscope_warehouse: Server name - Service postgres_gcp_warehouse: Server name - Service postgres_rds_warehouse: Server name - Service postgres_warehouse: Server name - Service redshift: Server name - Service snowflake: Server name - Service sql_server_rds_warehouse: Server name - Service sql_server_warehouse: Server name
httpPath This property is required. String
Field usage depends on service value: - Service adls: HTTP path - Service databricks: HTTP path - Service new_s3_datalake: HTTP path - Service onelake: HTTP path
isPrivateKeyEncrypted This property is required. Boolean
Field usage depends on service value: - Service snowflake: Indicates that a private key is encrypted. The default value: false. The field can be specified if authentication type is KEY_PAIR.
isPrivateLinkRequired This property is required. Boolean
Field usage depends on service value: - Service new_s3_datalake: We use PrivateLink by default if your s3 bucket is in the same region as Fivetran. Turning on this toggle ensures that Fivetran always connects to s3 bucket over PrivateLink. Learn more in our PrivateLink documentation.
isRedshiftServerless This property is required. Boolean
Field usage depends on service value: - Service redshift: Is your destination Redshift Serverless
lakehouseGuid This property is required. String
Field usage depends on service value: - Service onelake: (Immutable) OneLake lakehouse GUID
lakehouseName This property is required. String
Field usage depends on service value: - Service onelake: (Immutable) Name of your lakehouse
mskStsRegion This property is required. String
numOfPartitions This property is required. Double
Field usage depends on service value: - Service confluent_cloud_wh: Number of partitions per topic.
oauth2ClientId This property is required. String
Field usage depends on service value: - Service adls: OAuth 2.0 client ID - Service databricks: OAuth 2.0 client ID - Service new_s3_datalake: OAuth 2.0 client ID - Service onelake: OAuth 2.0 client ID
oauth2Secret This property is required. String
Field usage depends on service value: - Service adls: OAuth 2.0 secret - Service databricks: OAuth 2.0 secret - Service new_s3_datalake: OAuth 2.0 secret - Service onelake: OAuth 2.0 secret
passphrase This property is required. String
Field usage depends on service value: - Service snowflake: In case private key is encrypted, you are required to enter passphrase that was used to encrypt the private key. The field can be specified if authentication type is KEY_PAIR.
password This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user password - Service aurora_warehouse: Database user password - Service azure_postgres_warehouse: Database user password - Service azure_sql_data_warehouse: Database user password - Service azure_sql_database: Database user password - Service azure_sql_managed_db_warehouse: Database user password - Service maria_rds_warehouse: Database user password - Service maria_warehouse: Database user password - Service mysql_rds_warehouse: Database user password - Service mysql_warehouse: Database user password - Service panoply: Database user password - Service periscope_warehouse: Database user password - Service postgres_gcp_warehouse: Database user password - Service postgres_rds_warehouse: Database user password - Service postgres_warehouse: Database user password - Service redshift: Database user password. Required if authentication type is PASSWORD. - Service snowflake: Database user password. The field should be specified if authentication type is PASSWORD. - Service sql_server_rds_warehouse: Database user password - Service sql_server_warehouse: Database user password
personalAccessToken This property is required. String
Field usage depends on service value: - Service adls: Personal access token - Service databricks: Personal access token - Service new_s3_datalake: Personal access token - Service onelake: Personal access token
port This property is required. Double
Field usage depends on service value: - Service adls: Server port number - Service aurora_postgres_warehouse: Server port number - Service aurora_warehouse: Server port number - Service azure_postgres_warehouse: Server port number - Service azure_sql_data_warehouse: Server port number - Service azure_sql_database: Server port number - Service azure_sql_managed_db_warehouse: Server port number - Service databricks: Server port number - Service maria_rds_warehouse: Server port number - Service maria_warehouse: Server port number - Service mysql_rds_warehouse: Server port number - Service mysql_warehouse: Server port number - Service new_s3_datalake: Server port number - Service onelake: Server port number - Service panoply: Server port number - Service periscope_warehouse: Server port number - Service postgres_gcp_warehouse: Server port number - Service postgres_rds_warehouse: Server port number - Service postgres_warehouse: Server port number - Service redshift: Server port number - Service snowflake: Server port number - Service sql_server_rds_warehouse: Server port number - Service sql_server_warehouse: Server port number
prefixPath This property is required. String
Field usage depends on service value: - Service adls: (Immutable) path/to/data within the container - Service new_s3_datalake: (Immutable) Prefix path of the bucket for which you have configured access policy. It is not required if access has been granted to entire Bucket in the access policy - Service onelake: (Immutable) path/to/data within your lakehouse inside the Files directory
privateKey This property is required. String
Field usage depends on service value: - Service snowflake: Private access key. The field should be specified if authentication type is KEY_PAIR.
projectId This property is required. String
Field usage depends on service value: - Service big_query: BigQuery project ID
publicKey This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Public Key - Service aurora_warehouse: Public Key - Service azure_postgres_warehouse: Public Key - Service azure_sql_data_warehouse: Public Key - Service azure_sql_database: Public Key - Service azure_sql_managed_db_warehouse: Public Key - Service maria_rds_warehouse: Public Key - Service maria_warehouse: Public Key - Service mysql_rds_warehouse: Public Key - Service mysql_warehouse: Public Key - Service panoply: Public Key - Service periscope_warehouse: Public Key - Service postgres_gcp_warehouse: Public Key - Service postgres_rds_warehouse: Public Key - Service postgres_warehouse: Public Key - Service redshift: Public Key - Service sql_server_rds_warehouse: Public Key - Service sql_server_warehouse: Public Key
region This property is required. String
Field usage depends on service value: - Service new_s3_datalake: Region of your AWS S3 bucket
registryName This property is required. String
registryStsRegion This property is required. String
replicationFactor This property is required. Double
Field usage depends on service value: - Service confluent_cloud_wh: Replication factor.
resourceId This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service aurora_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_data_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_database: Field to test Self serve Private Link - Service azure_sql_managed_db_warehouse: Field to test Self serve Private Link - Service databricks: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service panoply: This field is currently being introduced to test the Self-serve Private Link functionality - Service periscope_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_gcp_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service redshift: This field is currently being introduced to test the Self-serve Private Link functionality - Service snowflake: This field is currently being introduced to test the Self-serve Private Link functionality - Service sql_server_rds_warehouse: Field to test Self serve Private Link - Service sql_server_warehouse: Field to test Self serve Private Link
role This property is required. String
Field usage depends on service value: - Service snowflake: If not specified, Fivetran will use the user's default role
roleArn This property is required. String
Field usage depends on service value: - Service redshift: Role ARN with Redshift permissions. Required if authentication type is IAM.
saslMechanism This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
saslPlainKey This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL key.
saslPlainSecret This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL secret.
schemaCompatibility This property is required. String
schemaRegistry This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Schema Registry
schemaRegistryApiKey This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API key.
schemaRegistryApiSecret This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API secret.
schemaRegistryUrl This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry URL.
secretKey This property is required. String
Field usage depends on service value: - Service big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service big_query_dts: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service managed_big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account.
secretValue This property is required. String
Field usage depends on service value: - Service adls: Secret value for service principal - Service onelake: Secret value for service principal
securityProtocol This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
serverHostName This property is required. String
Field usage depends on service value: - Service adls: Server Host name - Service databricks: Server name - Service new_s3_datalake: Server host name - Service onelake: Server Host name
shouldMaintainTablesInDatabricks This property is required. Boolean
Field usage depends on service value: - Service adls: Should maintain tables in Databricks - Service new_s3_datalake: Should maintain tables in Databricks - Service onelake: Should maintain tables in Databricks
snapshotRetentionPeriod This property is required. String
Field usage depends on service value: - Service adls: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service new_s3_datalake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service onelake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK.
snowflakeCloud This property is required. String
snowflakeRegion This property is required. String
storageAccountName This property is required. String
Field usage depends on service value: - Service adls: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Service onelake: (Immutable) Storage account for Azure Data Lake Storage Gen2 name
tableFormat This property is required. String
Field usage depends on service value: - Service new_s3_datalake: (Immutable) The table format in which you want to sync your tables. Valid values are ICEBERG and DELTA_LAKE
tenantId This property is required. String
Field usage depends on service value: - Service adls: Tenant id of service principal - Service onelake: Tenant ID of service principal
tunnelHost This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel.
tunnelPort This property is required. Double
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel.
tunnelUser This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel.
user This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user name - Service aurora_warehouse: Database user name - Service azure_postgres_warehouse: Database user name - Service azure_sql_data_warehouse: Database user name - Service azure_sql_database: Database user name - Service azure_sql_managed_db_warehouse: Database user name - Service maria_rds_warehouse: Database user name - Service maria_warehouse: Database user name - Service mysql_rds_warehouse: Database user name - Service mysql_warehouse: Database user name - Service panoply: Database user name - Service periscope_warehouse: Database user name - Service postgres_gcp_warehouse: Database user name - Service postgres_rds_warehouse: Database user name - Service postgres_warehouse: Database user name - Service redshift: Database user name - Service snowflake: Database user name - Service sql_server_rds_warehouse: Database user name - Service sql_server_warehouse: Database user name
workspaceGuid This property is required. String
Field usage depends on service value: - Service onelake: (Immutable) OneLake workspace GUID
workspaceName This property is required. String
Field usage depends on service value: - Service onelake: OneLake workspace name
alwaysEncrypted This property is required. boolean
Field usage depends on service value: - Service aurora_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service panoply: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service redshift: Require TLS through Tunnel - Service sql_server_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel.
auth This property is required. string
Field usage depends on service value: - Service snowflake: Password-based or key-based authentication type
authType This property is required. string
Field usage depends on service value: - Service adls: Authentication type - Service databricks: Authentication type - Service new_s3_datalake: Authentication type - Service onelake: Authentication type - Service redshift: Authentication type. Default value: PASSWORD.
awsAccessKeyId This property is required. string
Field usage depends on service value: - Service new_s3_datalake: AWS access key to access the S3 bucket and AWS Glue
awsSecretAccessKey This property is required. string
Field usage depends on service value: - Service new_s3_datalake: AWS secret access key to access the S3 bucket and AWS Glue
bootstrapServers This property is required. string[]
Field usage depends on service value: - Service confluent_cloud_wh: Comma-separated list of Confluent Cloud servers in the server:port format.
bucket This property is required. string
Field usage depends on service value: - Service big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service big_query_dts: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service managed_big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service new_s3_datalake: (Immutable) The name of the bucket to be used as destination
catalog This property is required. string
Field usage depends on service value: - Service adls: Catalog name - Service databricks: Catalog name - Service new_s3_datalake: Catalog name - Service onelake: Catalog name
clientId This property is required. string
Field usage depends on service value: - Service adls: Client id of service principal - Service onelake: Client ID of service principal
cloudProvider This property is required. string
Field usage depends on service value: - Service databricks: Databricks deployment cloud
clusterId This property is required. string
Field usage depends on service value: - Service panoply: Cluster ID. - Service periscope_warehouse: Cluster ID. - Service redshift: Cluster ID. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
clusterRegion This property is required. string
Field usage depends on service value: - Service panoply: Cluster region. - Service periscope_warehouse: Cluster region. - Service redshift: Cluster region. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
connectionMethod This property is required. string
connectionType This property is required. string
Field usage depends on service value: - Service adls: Connection method. Default value: Directly. - Service aurora_postgres_warehouse: Connection method. Default value: Directly. - Service aurora_warehouse: Connection method. Default value: Directly. - Service azure_postgres_warehouse: Connection method. Default value: Directly. - Service azure_sql_data_warehouse: Connection method. Default value: Directly. - Service azure_sql_database: Connection method. Default value: Directly. - Service azure_sql_managed_db_warehouse: Connection method. Default value: Directly. - Service databricks: Connection method. Default value: Directly. - Service maria_rds_warehouse: Connection method. Default value: Directly. - Service maria_warehouse: Connection method. Default value: Directly. - Service mysql_rds_warehouse: Connection method. Default value: Directly. - Service mysql_warehouse: Connection method. Default value: Directly. - Service panoply: Connection method. Default value: Directly. - Service periscope_warehouse: Connection method. Default value: Directly. - Service postgres_gcp_warehouse: Connection method. Default value: Directly. - Service postgres_rds_warehouse: Connection method. Default value: Directly. - Service postgres_warehouse: Connection method. Default value: Directly. - Service redshift: Connection method. Default value: Directly. - Service snowflake: Connection method. Default value: Directly. - Service sql_server_rds_warehouse: Connection method. Default value: Directly. - Service sql_server_warehouse: Connection method. Default value: Directly.
containerName This property is required. string
Field usage depends on service value: - Service adls: (Immutable) Container to store delta table files - Service onelake: Workspace name to store delta table files
controllerId This property is required. string
createExternalTables This property is required. boolean
Field usage depends on service value: - Service databricks: Whether to create external tables
dataFormat This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud message format.
dataSetLocation This property is required. string
Field usage depends on service value: - Service big_query: Data location. Datasets will reside in this location. - Service big_query_dts: Data location. Datasets will reside in this location. - Service managed_big_query: Data location. Datasets will reside in this location.
database This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Database name - Service aurora_warehouse: Database name - Service azure_postgres_warehouse: Database name - Service azure_sql_data_warehouse: Database name - Service azure_sql_database: Database name - Service azure_sql_managed_db_warehouse: Database name - Service maria_rds_warehouse: Database name - Service maria_warehouse: Database name - Service mysql_rds_warehouse: Database name - Service mysql_warehouse: Database name - Service panoply: Database name - Service periscope_warehouse: Database name - Service postgres_gcp_warehouse: Database name - Service postgres_rds_warehouse: Database name - Service postgres_warehouse: Database name - Service redshift: Database name - Service snowflake: Database name - Service sql_server_rds_warehouse: Database name - Service sql_server_warehouse: Database name
databricksConnectionType This property is required. string
Field usage depends on service value: - Service adls: Databricks Connection method. Default value: Directly. - Service new_s3_datalake: Databricks Connection method. Default value: Directly. - Service onelake: Databricks Connection method. Default value: Directly.
enableRemoteExecution This property is required. boolean
externalId This property is required. string
Field usage depends on service value: - Service aws_msk_wh: Fivetran generated External ID - Service panoply: Fivetran generated External ID - Service periscope_warehouse: Fivetran generated External ID - Service redshift: Fivetran generated External ID
externalLocation This property is required. string
Field usage depends on service value: - Service databricks: External location to store Delta tables. Default value: "" (null). By default, the external tables will reside in the /{schema}/{table} path, and if you specify an external location in the {externalLocation}/{schema}/{table} path.
fivetranGlueRoleArn This property is required. string
fivetranMskRoleArn This property is required. string
fivetranRoleArn This property is required. string
Field usage depends on service value: - Service new_s3_datalake: ARN of the role which you created with different required policy mentioned in our setup guide
host This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Server name - Service aurora_warehouse: Server name - Service azure_postgres_warehouse: Server name - Service azure_sql_data_warehouse: Server name - Service azure_sql_database: Server name - Service azure_sql_managed_db_warehouse: Server name - Service maria_rds_warehouse: Server name - Service maria_warehouse: Server name - Service mysql_rds_warehouse: Server name - Service mysql_warehouse: Server name - Service panoply: Server name - Service periscope_warehouse: Server name - Service postgres_gcp_warehouse: Server name - Service postgres_rds_warehouse: Server name - Service postgres_warehouse: Server name - Service redshift: Server name - Service snowflake: Server name - Service sql_server_rds_warehouse: Server name - Service sql_server_warehouse: Server name
httpPath This property is required. string
Field usage depends on service value: - Service adls: HTTP path - Service databricks: HTTP path - Service new_s3_datalake: HTTP path - Service onelake: HTTP path
isPrivateKeyEncrypted This property is required. boolean
Field usage depends on service value: - Service snowflake: Indicates that a private key is encrypted. The default value: false. The field can be specified if authentication type is KEY_PAIR.
isPrivateLinkRequired This property is required. boolean
Field usage depends on service value: - Service new_s3_datalake: We use PrivateLink by default if your s3 bucket is in the same region as Fivetran. Turning on this toggle ensures that Fivetran always connects to s3 bucket over PrivateLink. Learn more in our PrivateLink documentation.
isRedshiftServerless This property is required. boolean
Field usage depends on service value: - Service redshift: Is your destination Redshift Serverless
lakehouseGuid This property is required. string
Field usage depends on service value: - Service onelake: (Immutable) OneLake lakehouse GUID
lakehouseName This property is required. string
Field usage depends on service value: - Service onelake: (Immutable) Name of your lakehouse
mskStsRegion This property is required. string
numOfPartitions This property is required. number
Field usage depends on service value: - Service confluent_cloud_wh: Number of partitions per topic.
oauth2ClientId This property is required. string
Field usage depends on service value: - Service adls: OAuth 2.0 client ID - Service databricks: OAuth 2.0 client ID - Service new_s3_datalake: OAuth 2.0 client ID - Service onelake: OAuth 2.0 client ID
oauth2Secret This property is required. string
Field usage depends on service value: - Service adls: OAuth 2.0 secret - Service databricks: OAuth 2.0 secret - Service new_s3_datalake: OAuth 2.0 secret - Service onelake: OAuth 2.0 secret
passphrase This property is required. string
Field usage depends on service value: - Service snowflake: In case private key is encrypted, you are required to enter passphrase that was used to encrypt the private key. The field can be specified if authentication type is KEY_PAIR.
password This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user password - Service aurora_warehouse: Database user password - Service azure_postgres_warehouse: Database user password - Service azure_sql_data_warehouse: Database user password - Service azure_sql_database: Database user password - Service azure_sql_managed_db_warehouse: Database user password - Service maria_rds_warehouse: Database user password - Service maria_warehouse: Database user password - Service mysql_rds_warehouse: Database user password - Service mysql_warehouse: Database user password - Service panoply: Database user password - Service periscope_warehouse: Database user password - Service postgres_gcp_warehouse: Database user password - Service postgres_rds_warehouse: Database user password - Service postgres_warehouse: Database user password - Service redshift: Database user password. Required if authentication type is PASSWORD. - Service snowflake: Database user password. The field should be specified if authentication type is PASSWORD. - Service sql_server_rds_warehouse: Database user password - Service sql_server_warehouse: Database user password
personalAccessToken This property is required. string
Field usage depends on service value: - Service adls: Personal access token - Service databricks: Personal access token - Service new_s3_datalake: Personal access token - Service onelake: Personal access token
port This property is required. number
Field usage depends on service value: - Service adls: Server port number - Service aurora_postgres_warehouse: Server port number - Service aurora_warehouse: Server port number - Service azure_postgres_warehouse: Server port number - Service azure_sql_data_warehouse: Server port number - Service azure_sql_database: Server port number - Service azure_sql_managed_db_warehouse: Server port number - Service databricks: Server port number - Service maria_rds_warehouse: Server port number - Service maria_warehouse: Server port number - Service mysql_rds_warehouse: Server port number - Service mysql_warehouse: Server port number - Service new_s3_datalake: Server port number - Service onelake: Server port number - Service panoply: Server port number - Service periscope_warehouse: Server port number - Service postgres_gcp_warehouse: Server port number - Service postgres_rds_warehouse: Server port number - Service postgres_warehouse: Server port number - Service redshift: Server port number - Service snowflake: Server port number - Service sql_server_rds_warehouse: Server port number - Service sql_server_warehouse: Server port number
prefixPath This property is required. string
Field usage depends on service value: - Service adls: (Immutable) path/to/data within the container - Service new_s3_datalake: (Immutable) Prefix path of the bucket for which you have configured access policy. It is not required if access has been granted to entire Bucket in the access policy - Service onelake: (Immutable) path/to/data within your lakehouse inside the Files directory
privateKey This property is required. string
Field usage depends on service value: - Service snowflake: Private access key. The field should be specified if authentication type is KEY_PAIR.
projectId This property is required. string
Field usage depends on service value: - Service big_query: BigQuery project ID
publicKey This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Public Key - Service aurora_warehouse: Public Key - Service azure_postgres_warehouse: Public Key - Service azure_sql_data_warehouse: Public Key - Service azure_sql_database: Public Key - Service azure_sql_managed_db_warehouse: Public Key - Service maria_rds_warehouse: Public Key - Service maria_warehouse: Public Key - Service mysql_rds_warehouse: Public Key - Service mysql_warehouse: Public Key - Service panoply: Public Key - Service periscope_warehouse: Public Key - Service postgres_gcp_warehouse: Public Key - Service postgres_rds_warehouse: Public Key - Service postgres_warehouse: Public Key - Service redshift: Public Key - Service sql_server_rds_warehouse: Public Key - Service sql_server_warehouse: Public Key
region This property is required. string
Field usage depends on service value: - Service new_s3_datalake: Region of your AWS S3 bucket
registryName This property is required. string
registryStsRegion This property is required. string
replicationFactor This property is required. number
Field usage depends on service value: - Service confluent_cloud_wh: Replication factor.
resourceId This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service aurora_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_data_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_database: Field to test Self serve Private Link - Service azure_sql_managed_db_warehouse: Field to test Self serve Private Link - Service databricks: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service panoply: This field is currently being introduced to test the Self-serve Private Link functionality - Service periscope_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_gcp_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service redshift: This field is currently being introduced to test the Self-serve Private Link functionality - Service snowflake: This field is currently being introduced to test the Self-serve Private Link functionality - Service sql_server_rds_warehouse: Field to test Self serve Private Link - Service sql_server_warehouse: Field to test Self serve Private Link
role This property is required. string
Field usage depends on service value: - Service snowflake: If not specified, Fivetran will use the user's default role
roleArn This property is required. string
Field usage depends on service value: - Service redshift: Role ARN with Redshift permissions. Required if authentication type is IAM.
saslMechanism This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
saslPlainKey This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL key.
saslPlainSecret This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL secret.
schemaCompatibility This property is required. string
schemaRegistry This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema Registry
schemaRegistryApiKey This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API key.
schemaRegistryApiSecret This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API secret.
schemaRegistryUrl This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry URL.
secretKey This property is required. string
Field usage depends on service value: - Service big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service big_query_dts: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service managed_big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account.
secretValue This property is required. string
Field usage depends on service value: - Service adls: Secret value for service principal - Service onelake: Secret value for service principal
securityProtocol This property is required. string
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
serverHostName This property is required. string
Field usage depends on service value: - Service adls: Server Host name - Service databricks: Server name - Service new_s3_datalake: Server host name - Service onelake: Server Host name
shouldMaintainTablesInDatabricks This property is required. boolean
Field usage depends on service value: - Service adls: Should maintain tables in Databricks - Service new_s3_datalake: Should maintain tables in Databricks - Service onelake: Should maintain tables in Databricks
snapshotRetentionPeriod This property is required. string
Field usage depends on service value: - Service adls: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service new_s3_datalake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service onelake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK.
snowflakeCloud This property is required. string
snowflakeRegion This property is required. string
storageAccountName This property is required. string
Field usage depends on service value: - Service adls: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Service onelake: (Immutable) Storage account for Azure Data Lake Storage Gen2 name
tableFormat This property is required. string
Field usage depends on service value: - Service new_s3_datalake: (Immutable) The table format in which you want to sync your tables. Valid values are ICEBERG and DELTA_LAKE
tenantId This property is required. string
Field usage depends on service value: - Service adls: Tenant id of service principal - Service onelake: Tenant ID of service principal
tunnelHost This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel.
tunnelPort This property is required. number
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel.
tunnelUser This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel.
user This property is required. string
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user name - Service aurora_warehouse: Database user name - Service azure_postgres_warehouse: Database user name - Service azure_sql_data_warehouse: Database user name - Service azure_sql_database: Database user name - Service azure_sql_managed_db_warehouse: Database user name - Service maria_rds_warehouse: Database user name - Service maria_warehouse: Database user name - Service mysql_rds_warehouse: Database user name - Service mysql_warehouse: Database user name - Service panoply: Database user name - Service periscope_warehouse: Database user name - Service postgres_gcp_warehouse: Database user name - Service postgres_rds_warehouse: Database user name - Service postgres_warehouse: Database user name - Service redshift: Database user name - Service snowflake: Database user name - Service sql_server_rds_warehouse: Database user name - Service sql_server_warehouse: Database user name
workspaceGuid This property is required. string
Field usage depends on service value: - Service onelake: (Immutable) OneLake workspace GUID
workspaceName This property is required. string
Field usage depends on service value: - Service onelake: OneLake workspace name
always_encrypted This property is required. bool
Field usage depends on service value: - Service aurora_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service panoply: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service redshift: Require TLS through Tunnel - Service sql_server_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel.
auth This property is required. str
Field usage depends on service value: - Service snowflake: Password-based or key-based authentication type
auth_type This property is required. str
Field usage depends on service value: - Service adls: Authentication type - Service databricks: Authentication type - Service new_s3_datalake: Authentication type - Service onelake: Authentication type - Service redshift: Authentication type. Default value: PASSWORD.
aws_access_key_id This property is required. str
Field usage depends on service value: - Service new_s3_datalake: AWS access key to access the S3 bucket and AWS Glue
aws_secret_access_key This property is required. str
Field usage depends on service value: - Service new_s3_datalake: AWS secret access key to access the S3 bucket and AWS Glue
bootstrap_servers This property is required. Sequence[str]
Field usage depends on service value: - Service confluent_cloud_wh: Comma-separated list of Confluent Cloud servers in the server:port format.
bucket This property is required. str
Field usage depends on service value: - Service big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service big_query_dts: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service managed_big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service new_s3_datalake: (Immutable) The name of the bucket to be used as destination
catalog This property is required. str
Field usage depends on service value: - Service adls: Catalog name - Service databricks: Catalog name - Service new_s3_datalake: Catalog name - Service onelake: Catalog name
client_id This property is required. str
Field usage depends on service value: - Service adls: Client id of service principal - Service onelake: Client ID of service principal
cloud_provider This property is required. str
Field usage depends on service value: - Service databricks: Databricks deployment cloud
cluster_id This property is required. str
Field usage depends on service value: - Service panoply: Cluster ID. - Service periscope_warehouse: Cluster ID. - Service redshift: Cluster ID. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
cluster_region This property is required. str
Field usage depends on service value: - Service panoply: Cluster region. - Service periscope_warehouse: Cluster region. - Service redshift: Cluster region. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
connection_method This property is required. str
connection_type This property is required. str
Field usage depends on service value: - Service adls: Connection method. Default value: Directly. - Service aurora_postgres_warehouse: Connection method. Default value: Directly. - Service aurora_warehouse: Connection method. Default value: Directly. - Service azure_postgres_warehouse: Connection method. Default value: Directly. - Service azure_sql_data_warehouse: Connection method. Default value: Directly. - Service azure_sql_database: Connection method. Default value: Directly. - Service azure_sql_managed_db_warehouse: Connection method. Default value: Directly. - Service databricks: Connection method. Default value: Directly. - Service maria_rds_warehouse: Connection method. Default value: Directly. - Service maria_warehouse: Connection method. Default value: Directly. - Service mysql_rds_warehouse: Connection method. Default value: Directly. - Service mysql_warehouse: Connection method. Default value: Directly. - Service panoply: Connection method. Default value: Directly. - Service periscope_warehouse: Connection method. Default value: Directly. - Service postgres_gcp_warehouse: Connection method. Default value: Directly. - Service postgres_rds_warehouse: Connection method. Default value: Directly. - Service postgres_warehouse: Connection method. Default value: Directly. - Service redshift: Connection method. Default value: Directly. - Service snowflake: Connection method. Default value: Directly. - Service sql_server_rds_warehouse: Connection method. Default value: Directly. - Service sql_server_warehouse: Connection method. Default value: Directly.
container_name This property is required. str
Field usage depends on service value: - Service adls: (Immutable) Container to store delta table files - Service onelake: Workspace name to store delta table files
controller_id This property is required. str
create_external_tables This property is required. bool
Field usage depends on service value: - Service databricks: Whether to create external tables
data_format This property is required. str
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud message format.
data_set_location This property is required. str
Field usage depends on service value: - Service big_query: Data location. Datasets will reside in this location. - Service big_query_dts: Data location. Datasets will reside in this location. - Service managed_big_query: Data location. Datasets will reside in this location.
database This property is required. str
Field usage depends on service value: - Service aurora_postgres_warehouse: Database name - Service aurora_warehouse: Database name - Service azure_postgres_warehouse: Database name - Service azure_sql_data_warehouse: Database name - Service azure_sql_database: Database name - Service azure_sql_managed_db_warehouse: Database name - Service maria_rds_warehouse: Database name - Service maria_warehouse: Database name - Service mysql_rds_warehouse: Database name - Service mysql_warehouse: Database name - Service panoply: Database name - Service periscope_warehouse: Database name - Service postgres_gcp_warehouse: Database name - Service postgres_rds_warehouse: Database name - Service postgres_warehouse: Database name - Service redshift: Database name - Service snowflake: Database name - Service sql_server_rds_warehouse: Database name - Service sql_server_warehouse: Database name
databricks_connection_type This property is required. str
Field usage depends on service value: - Service adls: Databricks Connection method. Default value: Directly. - Service new_s3_datalake: Databricks Connection method. Default value: Directly. - Service onelake: Databricks Connection method. Default value: Directly.
enable_remote_execution This property is required. bool
external_id This property is required. str
Field usage depends on service value: - Service aws_msk_wh: Fivetran generated External ID - Service panoply: Fivetran generated External ID - Service periscope_warehouse: Fivetran generated External ID - Service redshift: Fivetran generated External ID
external_location This property is required. str
Field usage depends on service value: - Service databricks: External location to store Delta tables. Default value: "" (null). By default, the external tables will reside in the /{schema}/{table} path, and if you specify an external location in the {externalLocation}/{schema}/{table} path.
fivetran_glue_role_arn This property is required. str
fivetran_msk_role_arn This property is required. str
fivetran_role_arn This property is required. str
Field usage depends on service value: - Service new_s3_datalake: ARN of the role which you created with different required policy mentioned in our setup guide
host This property is required. str
Field usage depends on service value: - Service aurora_postgres_warehouse: Server name - Service aurora_warehouse: Server name - Service azure_postgres_warehouse: Server name - Service azure_sql_data_warehouse: Server name - Service azure_sql_database: Server name - Service azure_sql_managed_db_warehouse: Server name - Service maria_rds_warehouse: Server name - Service maria_warehouse: Server name - Service mysql_rds_warehouse: Server name - Service mysql_warehouse: Server name - Service panoply: Server name - Service periscope_warehouse: Server name - Service postgres_gcp_warehouse: Server name - Service postgres_rds_warehouse: Server name - Service postgres_warehouse: Server name - Service redshift: Server name - Service snowflake: Server name - Service sql_server_rds_warehouse: Server name - Service sql_server_warehouse: Server name
http_path This property is required. str
Field usage depends on service value: - Service adls: HTTP path - Service databricks: HTTP path - Service new_s3_datalake: HTTP path - Service onelake: HTTP path
is_private_key_encrypted This property is required. bool
Field usage depends on service value: - Service snowflake: Indicates that a private key is encrypted. The default value: false. The field can be specified if authentication type is KEY_PAIR.
is_private_link_required This property is required. bool
Field usage depends on service value: - Service new_s3_datalake: We use PrivateLink by default if your s3 bucket is in the same region as Fivetran. Turning on this toggle ensures that Fivetran always connects to s3 bucket over PrivateLink. Learn more in our PrivateLink documentation.
is_redshift_serverless This property is required. bool
Field usage depends on service value: - Service redshift: Is your destination Redshift Serverless
lakehouse_guid This property is required. str
Field usage depends on service value: - Service onelake: (Immutable) OneLake lakehouse GUID
lakehouse_name This property is required. str
Field usage depends on service value: - Service onelake: (Immutable) Name of your lakehouse
msk_sts_region This property is required. str
num_of_partitions This property is required. float
Field usage depends on service value: - Service confluent_cloud_wh: Number of partitions per topic.
oauth2_client_id This property is required. str
Field usage depends on service value: - Service adls: OAuth 2.0 client ID - Service databricks: OAuth 2.0 client ID - Service new_s3_datalake: OAuth 2.0 client ID - Service onelake: OAuth 2.0 client ID
oauth2_secret This property is required. str
Field usage depends on service value: - Service adls: OAuth 2.0 secret - Service databricks: OAuth 2.0 secret - Service new_s3_datalake: OAuth 2.0 secret - Service onelake: OAuth 2.0 secret
passphrase This property is required. str
Field usage depends on service value: - Service snowflake: In case private key is encrypted, you are required to enter passphrase that was used to encrypt the private key. The field can be specified if authentication type is KEY_PAIR.
password This property is required. str
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user password - Service aurora_warehouse: Database user password - Service azure_postgres_warehouse: Database user password - Service azure_sql_data_warehouse: Database user password - Service azure_sql_database: Database user password - Service azure_sql_managed_db_warehouse: Database user password - Service maria_rds_warehouse: Database user password - Service maria_warehouse: Database user password - Service mysql_rds_warehouse: Database user password - Service mysql_warehouse: Database user password - Service panoply: Database user password - Service periscope_warehouse: Database user password - Service postgres_gcp_warehouse: Database user password - Service postgres_rds_warehouse: Database user password - Service postgres_warehouse: Database user password - Service redshift: Database user password. Required if authentication type is PASSWORD. - Service snowflake: Database user password. The field should be specified if authentication type is PASSWORD. - Service sql_server_rds_warehouse: Database user password - Service sql_server_warehouse: Database user password
personal_access_token This property is required. str
Field usage depends on service value: - Service adls: Personal access token - Service databricks: Personal access token - Service new_s3_datalake: Personal access token - Service onelake: Personal access token
port This property is required. float
Field usage depends on service value: - Service adls: Server port number - Service aurora_postgres_warehouse: Server port number - Service aurora_warehouse: Server port number - Service azure_postgres_warehouse: Server port number - Service azure_sql_data_warehouse: Server port number - Service azure_sql_database: Server port number - Service azure_sql_managed_db_warehouse: Server port number - Service databricks: Server port number - Service maria_rds_warehouse: Server port number - Service maria_warehouse: Server port number - Service mysql_rds_warehouse: Server port number - Service mysql_warehouse: Server port number - Service new_s3_datalake: Server port number - Service onelake: Server port number - Service panoply: Server port number - Service periscope_warehouse: Server port number - Service postgres_gcp_warehouse: Server port number - Service postgres_rds_warehouse: Server port number - Service postgres_warehouse: Server port number - Service redshift: Server port number - Service snowflake: Server port number - Service sql_server_rds_warehouse: Server port number - Service sql_server_warehouse: Server port number
prefix_path This property is required. str
Field usage depends on service value: - Service adls: (Immutable) path/to/data within the container - Service new_s3_datalake: (Immutable) Prefix path of the bucket for which you have configured access policy. It is not required if access has been granted to entire Bucket in the access policy - Service onelake: (Immutable) path/to/data within your lakehouse inside the Files directory
private_key This property is required. str
Field usage depends on service value: - Service snowflake: Private access key. The field should be specified if authentication type is KEY_PAIR.
project_id This property is required. str
Field usage depends on service value: - Service big_query: BigQuery project ID
public_key This property is required. str
Field usage depends on service value: - Service aurora_postgres_warehouse: Public Key - Service aurora_warehouse: Public Key - Service azure_postgres_warehouse: Public Key - Service azure_sql_data_warehouse: Public Key - Service azure_sql_database: Public Key - Service azure_sql_managed_db_warehouse: Public Key - Service maria_rds_warehouse: Public Key - Service maria_warehouse: Public Key - Service mysql_rds_warehouse: Public Key - Service mysql_warehouse: Public Key - Service panoply: Public Key - Service periscope_warehouse: Public Key - Service postgres_gcp_warehouse: Public Key - Service postgres_rds_warehouse: Public Key - Service postgres_warehouse: Public Key - Service redshift: Public Key - Service sql_server_rds_warehouse: Public Key - Service sql_server_warehouse: Public Key
region This property is required. str
Field usage depends on service value: - Service new_s3_datalake: Region of your AWS S3 bucket
registry_name This property is required. str
registry_sts_region This property is required. str
replication_factor This property is required. float
Field usage depends on service value: - Service confluent_cloud_wh: Replication factor.
resource_id This property is required. str
Field usage depends on service value: - Service aurora_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service aurora_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_data_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_database: Field to test Self serve Private Link - Service azure_sql_managed_db_warehouse: Field to test Self serve Private Link - Service databricks: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service panoply: This field is currently being introduced to test the Self-serve Private Link functionality - Service periscope_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_gcp_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service redshift: This field is currently being introduced to test the Self-serve Private Link functionality - Service snowflake: This field is currently being introduced to test the Self-serve Private Link functionality - Service sql_server_rds_warehouse: Field to test Self serve Private Link - Service sql_server_warehouse: Field to test Self serve Private Link
role This property is required. str
Field usage depends on service value: - Service snowflake: If not specified, Fivetran will use the user's default role
role_arn This property is required. str
Field usage depends on service value: - Service redshift: Role ARN with Redshift permissions. Required if authentication type is IAM.
sasl_mechanism This property is required. str
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
sasl_plain_key This property is required. str
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL key.
sasl_plain_secret This property is required. str
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL secret.
schema_compatibility This property is required. str
schema_registry This property is required. str
Field usage depends on service value: - Service confluent_cloud_wh: Schema Registry
schema_registry_api_key This property is required. str
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API key.
schema_registry_api_secret This property is required. str
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API secret.
schema_registry_url This property is required. str
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry URL.
secret_key This property is required. str
Field usage depends on service value: - Service big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service big_query_dts: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service managed_big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account.
secret_value This property is required. str
Field usage depends on service value: - Service adls: Secret value for service principal - Service onelake: Secret value for service principal
security_protocol This property is required. str
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
server_host_name This property is required. str
Field usage depends on service value: - Service adls: Server Host name - Service databricks: Server name - Service new_s3_datalake: Server host name - Service onelake: Server Host name
should_maintain_tables_in_databricks This property is required. bool
Field usage depends on service value: - Service adls: Should maintain tables in Databricks - Service new_s3_datalake: Should maintain tables in Databricks - Service onelake: Should maintain tables in Databricks
snapshot_retention_period This property is required. str
Field usage depends on service value: - Service adls: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service new_s3_datalake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service onelake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK.
snowflake_cloud This property is required. str
snowflake_region This property is required. str
storage_account_name This property is required. str
Field usage depends on service value: - Service adls: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Service onelake: (Immutable) Storage account for Azure Data Lake Storage Gen2 name
table_format This property is required. str
Field usage depends on service value: - Service new_s3_datalake: (Immutable) The table format in which you want to sync your tables. Valid values are ICEBERG and DELTA_LAKE
tenant_id This property is required. str
Field usage depends on service value: - Service adls: Tenant id of service principal - Service onelake: Tenant ID of service principal
tunnel_host This property is required. str
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel.
tunnel_port This property is required. float
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel.
tunnel_user This property is required. str
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel.
user This property is required. str
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user name - Service aurora_warehouse: Database user name - Service azure_postgres_warehouse: Database user name - Service azure_sql_data_warehouse: Database user name - Service azure_sql_database: Database user name - Service azure_sql_managed_db_warehouse: Database user name - Service maria_rds_warehouse: Database user name - Service maria_warehouse: Database user name - Service mysql_rds_warehouse: Database user name - Service mysql_warehouse: Database user name - Service panoply: Database user name - Service periscope_warehouse: Database user name - Service postgres_gcp_warehouse: Database user name - Service postgres_rds_warehouse: Database user name - Service postgres_warehouse: Database user name - Service redshift: Database user name - Service snowflake: Database user name - Service sql_server_rds_warehouse: Database user name - Service sql_server_warehouse: Database user name
workspace_guid This property is required. str
Field usage depends on service value: - Service onelake: (Immutable) OneLake workspace GUID
workspace_name This property is required. str
Field usage depends on service value: - Service onelake: OneLake workspace name
alwaysEncrypted This property is required. Boolean
Field usage depends on service value: - Service aurora_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service panoply: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service redshift: Require TLS through Tunnel - Service sql_server_rds_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: Specifies whether TLS is required. Must be populated if connection_type is set to SshTunnel.
auth This property is required. String
Field usage depends on service value: - Service snowflake: Password-based or key-based authentication type
authType This property is required. String
Field usage depends on service value: - Service adls: Authentication type - Service databricks: Authentication type - Service new_s3_datalake: Authentication type - Service onelake: Authentication type - Service redshift: Authentication type. Default value: PASSWORD.
awsAccessKeyId This property is required. String
Field usage depends on service value: - Service new_s3_datalake: AWS access key to access the S3 bucket and AWS Glue
awsSecretAccessKey This property is required. String
Field usage depends on service value: - Service new_s3_datalake: AWS secret access key to access the S3 bucket and AWS Glue
bootstrapServers This property is required. List<String>
Field usage depends on service value: - Service confluent_cloud_wh: Comma-separated list of Confluent Cloud servers in the server:port format.
bucket This property is required. String
Field usage depends on service value: - Service big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service big_query_dts: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service managed_big_query: Customer bucket. If specified, your GCS bucket will be used to process the data instead of a Fivetran-managed bucket. The bucket must be present in the same location as the dataset location. - Service new_s3_datalake: (Immutable) The name of the bucket to be used as destination
catalog This property is required. String
Field usage depends on service value: - Service adls: Catalog name - Service databricks: Catalog name - Service new_s3_datalake: Catalog name - Service onelake: Catalog name
clientId This property is required. String
Field usage depends on service value: - Service adls: Client id of service principal - Service onelake: Client ID of service principal
cloudProvider This property is required. String
Field usage depends on service value: - Service databricks: Databricks deployment cloud
clusterId This property is required. String
Field usage depends on service value: - Service panoply: Cluster ID. - Service periscope_warehouse: Cluster ID. - Service redshift: Cluster ID. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
clusterRegion This property is required. String
Field usage depends on service value: - Service panoply: Cluster region. - Service periscope_warehouse: Cluster region. - Service redshift: Cluster region. Must be populated if connection_type is set to SshTunnel and auth_type is set to IAM.
connectionMethod This property is required. String
connectionType This property is required. String
Field usage depends on service value: - Service adls: Connection method. Default value: Directly. - Service aurora_postgres_warehouse: Connection method. Default value: Directly. - Service aurora_warehouse: Connection method. Default value: Directly. - Service azure_postgres_warehouse: Connection method. Default value: Directly. - Service azure_sql_data_warehouse: Connection method. Default value: Directly. - Service azure_sql_database: Connection method. Default value: Directly. - Service azure_sql_managed_db_warehouse: Connection method. Default value: Directly. - Service databricks: Connection method. Default value: Directly. - Service maria_rds_warehouse: Connection method. Default value: Directly. - Service maria_warehouse: Connection method. Default value: Directly. - Service mysql_rds_warehouse: Connection method. Default value: Directly. - Service mysql_warehouse: Connection method. Default value: Directly. - Service panoply: Connection method. Default value: Directly. - Service periscope_warehouse: Connection method. Default value: Directly. - Service postgres_gcp_warehouse: Connection method. Default value: Directly. - Service postgres_rds_warehouse: Connection method. Default value: Directly. - Service postgres_warehouse: Connection method. Default value: Directly. - Service redshift: Connection method. Default value: Directly. - Service snowflake: Connection method. Default value: Directly. - Service sql_server_rds_warehouse: Connection method. Default value: Directly. - Service sql_server_warehouse: Connection method. Default value: Directly.
containerName This property is required. String
Field usage depends on service value: - Service adls: (Immutable) Container to store delta table files - Service onelake: Workspace name to store delta table files
controllerId This property is required. String
createExternalTables This property is required. Boolean
Field usage depends on service value: - Service databricks: Whether to create external tables
dataFormat This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud message format.
dataSetLocation This property is required. String
Field usage depends on service value: - Service big_query: Data location. Datasets will reside in this location. - Service big_query_dts: Data location. Datasets will reside in this location. - Service managed_big_query: Data location. Datasets will reside in this location.
database This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Database name - Service aurora_warehouse: Database name - Service azure_postgres_warehouse: Database name - Service azure_sql_data_warehouse: Database name - Service azure_sql_database: Database name - Service azure_sql_managed_db_warehouse: Database name - Service maria_rds_warehouse: Database name - Service maria_warehouse: Database name - Service mysql_rds_warehouse: Database name - Service mysql_warehouse: Database name - Service panoply: Database name - Service periscope_warehouse: Database name - Service postgres_gcp_warehouse: Database name - Service postgres_rds_warehouse: Database name - Service postgres_warehouse: Database name - Service redshift: Database name - Service snowflake: Database name - Service sql_server_rds_warehouse: Database name - Service sql_server_warehouse: Database name
databricksConnectionType This property is required. String
Field usage depends on service value: - Service adls: Databricks Connection method. Default value: Directly. - Service new_s3_datalake: Databricks Connection method. Default value: Directly. - Service onelake: Databricks Connection method. Default value: Directly.
enableRemoteExecution This property is required. Boolean
externalId This property is required. String
Field usage depends on service value: - Service aws_msk_wh: Fivetran generated External ID - Service panoply: Fivetran generated External ID - Service periscope_warehouse: Fivetran generated External ID - Service redshift: Fivetran generated External ID
externalLocation This property is required. String
Field usage depends on service value: - Service databricks: External location to store Delta tables. Default value: "" (null). By default, the external tables will reside in the /{schema}/{table} path, and if you specify an external location in the {externalLocation}/{schema}/{table} path.
fivetranGlueRoleArn This property is required. String
fivetranMskRoleArn This property is required. String
fivetranRoleArn This property is required. String
Field usage depends on service value: - Service new_s3_datalake: ARN of the role which you created with different required policy mentioned in our setup guide
host This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Server name - Service aurora_warehouse: Server name - Service azure_postgres_warehouse: Server name - Service azure_sql_data_warehouse: Server name - Service azure_sql_database: Server name - Service azure_sql_managed_db_warehouse: Server name - Service maria_rds_warehouse: Server name - Service maria_warehouse: Server name - Service mysql_rds_warehouse: Server name - Service mysql_warehouse: Server name - Service panoply: Server name - Service periscope_warehouse: Server name - Service postgres_gcp_warehouse: Server name - Service postgres_rds_warehouse: Server name - Service postgres_warehouse: Server name - Service redshift: Server name - Service snowflake: Server name - Service sql_server_rds_warehouse: Server name - Service sql_server_warehouse: Server name
httpPath This property is required. String
Field usage depends on service value: - Service adls: HTTP path - Service databricks: HTTP path - Service new_s3_datalake: HTTP path - Service onelake: HTTP path
isPrivateKeyEncrypted This property is required. Boolean
Field usage depends on service value: - Service snowflake: Indicates that a private key is encrypted. The default value: false. The field can be specified if authentication type is KEY_PAIR.
isPrivateLinkRequired This property is required. Boolean
Field usage depends on service value: - Service new_s3_datalake: We use PrivateLink by default if your s3 bucket is in the same region as Fivetran. Turning on this toggle ensures that Fivetran always connects to s3 bucket over PrivateLink. Learn more in our PrivateLink documentation.
isRedshiftServerless This property is required. Boolean
Field usage depends on service value: - Service redshift: Is your destination Redshift Serverless
lakehouseGuid This property is required. String
Field usage depends on service value: - Service onelake: (Immutable) OneLake lakehouse GUID
lakehouseName This property is required. String
Field usage depends on service value: - Service onelake: (Immutable) Name of your lakehouse
mskStsRegion This property is required. String
numOfPartitions This property is required. Number
Field usage depends on service value: - Service confluent_cloud_wh: Number of partitions per topic.
oauth2ClientId This property is required. String
Field usage depends on service value: - Service adls: OAuth 2.0 client ID - Service databricks: OAuth 2.0 client ID - Service new_s3_datalake: OAuth 2.0 client ID - Service onelake: OAuth 2.0 client ID
oauth2Secret This property is required. String
Field usage depends on service value: - Service adls: OAuth 2.0 secret - Service databricks: OAuth 2.0 secret - Service new_s3_datalake: OAuth 2.0 secret - Service onelake: OAuth 2.0 secret
passphrase This property is required. String
Field usage depends on service value: - Service snowflake: In case private key is encrypted, you are required to enter passphrase that was used to encrypt the private key. The field can be specified if authentication type is KEY_PAIR.
password This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user password - Service aurora_warehouse: Database user password - Service azure_postgres_warehouse: Database user password - Service azure_sql_data_warehouse: Database user password - Service azure_sql_database: Database user password - Service azure_sql_managed_db_warehouse: Database user password - Service maria_rds_warehouse: Database user password - Service maria_warehouse: Database user password - Service mysql_rds_warehouse: Database user password - Service mysql_warehouse: Database user password - Service panoply: Database user password - Service periscope_warehouse: Database user password - Service postgres_gcp_warehouse: Database user password - Service postgres_rds_warehouse: Database user password - Service postgres_warehouse: Database user password - Service redshift: Database user password. Required if authentication type is PASSWORD. - Service snowflake: Database user password. The field should be specified if authentication type is PASSWORD. - Service sql_server_rds_warehouse: Database user password - Service sql_server_warehouse: Database user password
personalAccessToken This property is required. String
Field usage depends on service value: - Service adls: Personal access token - Service databricks: Personal access token - Service new_s3_datalake: Personal access token - Service onelake: Personal access token
port This property is required. Number
Field usage depends on service value: - Service adls: Server port number - Service aurora_postgres_warehouse: Server port number - Service aurora_warehouse: Server port number - Service azure_postgres_warehouse: Server port number - Service azure_sql_data_warehouse: Server port number - Service azure_sql_database: Server port number - Service azure_sql_managed_db_warehouse: Server port number - Service databricks: Server port number - Service maria_rds_warehouse: Server port number - Service maria_warehouse: Server port number - Service mysql_rds_warehouse: Server port number - Service mysql_warehouse: Server port number - Service new_s3_datalake: Server port number - Service onelake: Server port number - Service panoply: Server port number - Service periscope_warehouse: Server port number - Service postgres_gcp_warehouse: Server port number - Service postgres_rds_warehouse: Server port number - Service postgres_warehouse: Server port number - Service redshift: Server port number - Service snowflake: Server port number - Service sql_server_rds_warehouse: Server port number - Service sql_server_warehouse: Server port number
prefixPath This property is required. String
Field usage depends on service value: - Service adls: (Immutable) path/to/data within the container - Service new_s3_datalake: (Immutable) Prefix path of the bucket for which you have configured access policy. It is not required if access has been granted to entire Bucket in the access policy - Service onelake: (Immutable) path/to/data within your lakehouse inside the Files directory
privateKey This property is required. String
Field usage depends on service value: - Service snowflake: Private access key. The field should be specified if authentication type is KEY_PAIR.
projectId This property is required. String
Field usage depends on service value: - Service big_query: BigQuery project ID
publicKey This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Public Key - Service aurora_warehouse: Public Key - Service azure_postgres_warehouse: Public Key - Service azure_sql_data_warehouse: Public Key - Service azure_sql_database: Public Key - Service azure_sql_managed_db_warehouse: Public Key - Service maria_rds_warehouse: Public Key - Service maria_warehouse: Public Key - Service mysql_rds_warehouse: Public Key - Service mysql_warehouse: Public Key - Service panoply: Public Key - Service periscope_warehouse: Public Key - Service postgres_gcp_warehouse: Public Key - Service postgres_rds_warehouse: Public Key - Service postgres_warehouse: Public Key - Service redshift: Public Key - Service sql_server_rds_warehouse: Public Key - Service sql_server_warehouse: Public Key
region This property is required. String
Field usage depends on service value: - Service new_s3_datalake: Region of your AWS S3 bucket
registryName This property is required. String
registryStsRegion This property is required. String
replicationFactor This property is required. Number
Field usage depends on service value: - Service confluent_cloud_wh: Replication factor.
resourceId This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service aurora_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_data_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service azure_sql_database: Field to test Self serve Private Link - Service azure_sql_managed_db_warehouse: Field to test Self serve Private Link - Service databricks: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service maria_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service mysql_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service panoply: This field is currently being introduced to test the Self-serve Private Link functionality - Service periscope_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_gcp_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_rds_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service postgres_warehouse: This field is currently being introduced to test the Self-serve Private Link functionality - Service redshift: This field is currently being introduced to test the Self-serve Private Link functionality - Service snowflake: This field is currently being introduced to test the Self-serve Private Link functionality - Service sql_server_rds_warehouse: Field to test Self serve Private Link - Service sql_server_warehouse: Field to test Self serve Private Link
role This property is required. String
Field usage depends on service value: - Service snowflake: If not specified, Fivetran will use the user's default role
roleArn This property is required. String
Field usage depends on service value: - Service redshift: Role ARN with Redshift permissions. Required if authentication type is IAM.
saslMechanism This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
saslPlainKey This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL key.
saslPlainSecret This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Confluent Cloud SASL secret.
schemaCompatibility This property is required. String
schemaRegistry This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Schema Registry
schemaRegistryApiKey This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API key.
schemaRegistryApiSecret This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry API secret.
schemaRegistryUrl This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Schema registry URL.
secretKey This property is required. String
Field usage depends on service value: - Service big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service big_query_dts: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account. - Service managed_big_query: Private key of the customer service account. If specified, your service account will be used to process the data instead of the Fivetran-managed service account.
secretValue This property is required. String
Field usage depends on service value: - Service adls: Secret value for service principal - Service onelake: Secret value for service principal
securityProtocol This property is required. String
Field usage depends on service value: - Service confluent_cloud_wh: Security protocol for Confluent Cloud interaction.
serverHostName This property is required. String
Field usage depends on service value: - Service adls: Server Host name - Service databricks: Server name - Service new_s3_datalake: Server host name - Service onelake: Server Host name
shouldMaintainTablesInDatabricks This property is required. Boolean
Field usage depends on service value: - Service adls: Should maintain tables in Databricks - Service new_s3_datalake: Should maintain tables in Databricks - Service onelake: Should maintain tables in Databricks
snapshotRetentionPeriod This property is required. String
Field usage depends on service value: - Service adls: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service new_s3_datalake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK. - Service onelake: Snapshots older than the retention period are deleted every week. Default value: ONE_WEEK.
snowflakeCloud This property is required. String
snowflakeRegion This property is required. String
storageAccountName This property is required. String
Field usage depends on service value: - Service adls: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Service onelake: (Immutable) Storage account for Azure Data Lake Storage Gen2 name
tableFormat This property is required. String
Field usage depends on service value: - Service new_s3_datalake: (Immutable) The table format in which you want to sync your tables. Valid values are ICEBERG and DELTA_LAKE
tenantId This property is required. String
Field usage depends on service value: - Service adls: Tenant id of service principal - Service onelake: Tenant ID of service principal
tunnelHost This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server name. Must be populated if connection_type is set to SshTunnel.
tunnelPort This property is required. Number
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH server port name. Must be populated if connection_type is set to SshTunnel.
tunnelUser This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service aurora_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_data_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_database: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service azure_sql_managed_db_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service maria_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service mysql_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service panoply: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service periscope_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_gcp_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service postgres_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service redshift: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_rds_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel. - Service sql_server_warehouse: SSH user name. Must be populated if connection_type is set to SshTunnel.
user This property is required. String
Field usage depends on service value: - Service aurora_postgres_warehouse: Database user name - Service aurora_warehouse: Database user name - Service azure_postgres_warehouse: Database user name - Service azure_sql_data_warehouse: Database user name - Service azure_sql_database: Database user name - Service azure_sql_managed_db_warehouse: Database user name - Service maria_rds_warehouse: Database user name - Service maria_warehouse: Database user name - Service mysql_rds_warehouse: Database user name - Service mysql_warehouse: Database user name - Service panoply: Database user name - Service periscope_warehouse: Database user name - Service postgres_gcp_warehouse: Database user name - Service postgres_rds_warehouse: Database user name - Service postgres_warehouse: Database user name - Service redshift: Database user name - Service snowflake: Database user name - Service sql_server_rds_warehouse: Database user name - Service sql_server_warehouse: Database user name
workspaceGuid This property is required. String
Field usage depends on service value: - Service onelake: (Immutable) OneLake workspace GUID
workspaceName This property is required. String
Field usage depends on service value: - Service onelake: OneLake workspace name

Package Details

Repository
fivetran fivetran/terraform-provider-fivetran
License
Notes
This Pulumi package is based on the fivetran Terraform Provider.