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",
});
import pulumi
import pulumi_fivetran as fivetran
dest = fivetran.get_destination(id="anonymous_mystery")
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
})
}
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",
});
});
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());
}
}
variables:
dest:
fn::invoke:
function: fivetran:getDestination
arguments:
id: anonymous_mystery
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>
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]
func LookupDestination(ctx *Context, args *LookupDestinationArgs, opts ...InvokeOption) (*LookupDestinationResult, error)
func LookupDestinationOutput(ctx *Context, args *LookupDestinationOutputArgs, opts ...InvokeOption) LookupDestinationResultOutput
> 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)
}
public static CompletableFuture<GetDestinationResult> getDestination(GetDestinationArgs args, InvokeOptions options)
public static Output<GetDestinationResult> getDestination(GetDestinationArgs args, InvokeOptions options)
fn::invoke:
function: fivetran:index/getDestination:getDestination
arguments:
# arguments dictionary
The following arguments are supported:
- Id
This property is required. string - Config
Get
Destination Config
- Id
This property is required. string - Config
Get
Destination Config
- id
This property is required. String - config
Get
Destination Config
- id
This property is required. string - config
Get
Destination Config
- id
This property is required. str - config
Get
Destination Config
- id
This property is required. String - config Property Map
getDestination Result
The following output properties are available:
- Daylight
Saving boolTime Enabled - Group
Id string - Hybrid
Deployment stringAgent Id - Id string
- Networking
Method string - Private
Link stringId - Region string
- Service string
- Setup
Status string - Time
Zone stringOffset - Config
Get
Destination Config
- Daylight
Saving boolTime Enabled - Group
Id string - Hybrid
Deployment stringAgent Id - Id string
- Networking
Method string - Private
Link stringId - Region string
- Service string
- Setup
Status string - Time
Zone stringOffset - Config
Get
Destination Config
- daylight
Saving BooleanTime Enabled - group
Id String - hybrid
Deployment StringAgent Id - id String
- networking
Method String - private
Link StringId - region String
- service String
- setup
Status String - time
Zone StringOffset - config
Get
Destination Config
- daylight
Saving booleanTime Enabled - group
Id string - hybrid
Deployment stringAgent Id - id string
- networking
Method string - private
Link stringId - region string
- service string
- setup
Status string - time
Zone stringOffset - config
Get
Destination Config
- daylight_
saving_ booltime_ enabled - group_
id str - hybrid_
deployment_ stragent_ id - id str
- networking_
method str - private_
link_ strid - region str
- service str
- setup_
status str - time_
zone_ stroffset - config
Get
Destination Config
- daylight
Saving BooleanTime Enabled - group
Id String - hybrid
Deployment StringAgent Id - id String
- networking
Method String - private
Link StringId - region String
- service String
- setup
Status String - time
Zone StringOffset - config Property Map
Supporting Types
GetDestinationConfig
- Always
Encrypted This property is required. bool - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: Require TLS through Tunnel - Servicesql_server_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Auth
This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: Password-based or key-based authentication type - Auth
Type This property is required. string - Field usage depends on
service
value: - Serviceadls
: Authentication type - Servicedatabricks
: Authentication type - Servicenew_s3_datalake
: Authentication type - Serviceonelake
: Authentication type - Serviceredshift
: Authentication type. Default value:PASSWORD
. - Aws
Access Key Id This property is required. string - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS access key to access the S3 bucket and AWS Glue - Aws
Secret Access Key This property is required. string - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS secret access key to access the S3 bucket and AWS Glue - Bootstrap
Servers This property is required. List<string> - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Comma-separated list of Confluent Cloud servers in theserver:port
format. - Bucket
This property is required. string - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. - Servicenew_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: - Serviceadls
: Catalog name - Servicedatabricks
: Catalog name - Servicenew_s3_datalake
: Catalog name - Serviceonelake
: Catalog name - Client
Id This property is required. string - Field usage depends on
service
value: - Serviceadls
: Client id of service principal - Serviceonelake
: Client ID of service principal - Cloud
Provider This property is required. string - Field usage depends on
service
value: - Servicedatabricks
: Databricks deployment cloud - Cluster
Id This property is required. string - Field usage depends on
service
value: - Servicepanoply
: Cluster ID. - Serviceperiscope_warehouse
: Cluster ID. - Serviceredshift
: Cluster ID. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - Cluster
Region This property is required. string - Field usage depends on
service
value: - Servicepanoply
: Cluster region. - Serviceperiscope_warehouse
: Cluster region. - Serviceredshift
: Cluster region. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - Connection
Method This property is required. string - Connection
Type This property is required. string - Field usage depends on
service
value: - Serviceadls
: Connection method. Default value:Directly
. - Serviceaurora_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceaurora_warehouse
: Connection method. Default value:Directly
. - Serviceazure_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_data_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_database
: Connection method. Default value:Directly
. - Serviceazure_sql_managed_db_warehouse
: Connection method. Default value:Directly
. - Servicedatabricks
: Connection method. Default value:Directly
. - Servicemaria_rds_warehouse
: Connection method. Default value:Directly
. - Servicemaria_warehouse
: Connection method. Default value:Directly
. - Servicemysql_rds_warehouse
: Connection method. Default value:Directly
. - Servicemysql_warehouse
: Connection method. Default value:Directly
. - Servicepanoply
: Connection method. Default value:Directly
. - Serviceperiscope_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_gcp_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_rds_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_warehouse
: Connection method. Default value:Directly
. - Serviceredshift
: Connection method. Default value:Directly
. - Servicesnowflake
: Connection method. Default value:Directly
. - Servicesql_server_rds_warehouse
: Connection method. Default value:Directly
. - Servicesql_server_warehouse
: Connection method. Default value:Directly
. - Container
Name This property is required. string - Field usage depends on
service
value: - Serviceadls
: (Immutable) Container to store delta table files - Serviceonelake
: Workspace name to store delta table files - Controller
Id This property is required. string - Create
External Tables This property is required. bool - Field usage depends on
service
value: - Servicedatabricks
: Whether to create external tables - Data
Format This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud message format. - Data
Set Location This property is required. string - Field usage depends on
service
value: - Servicebig_query
: Data location. Datasets will reside in this location. - Servicebig_query_dts
: Data location. Datasets will reside in this location. - Servicemanaged_big_query
: Data location. Datasets will reside in this location. - Database
This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database name - Serviceaurora_warehouse
: Database name - Serviceazure_postgres_warehouse
: Database name - Serviceazure_sql_data_warehouse
: Database name - Serviceazure_sql_database
: Database name - Serviceazure_sql_managed_db_warehouse
: Database name - Servicemaria_rds_warehouse
: Database name - Servicemaria_warehouse
: Database name - Servicemysql_rds_warehouse
: Database name - Servicemysql_warehouse
: Database name - Servicepanoply
: Database name - Serviceperiscope_warehouse
: Database name - Servicepostgres_gcp_warehouse
: Database name - Servicepostgres_rds_warehouse
: Database name - Servicepostgres_warehouse
: Database name - Serviceredshift
: Database name - Servicesnowflake
: Database name - Servicesql_server_rds_warehouse
: Database name - Servicesql_server_warehouse
: Database name - Databricks
Connection Type This property is required. string - Field usage depends on
service
value: - Serviceadls
: Databricks Connection method. Default value:Directly
. - Servicenew_s3_datalake
: Databricks Connection method. Default value:Directly
. - Serviceonelake
: Databricks Connection method. Default value:Directly
. - Enable
Remote Execution This property is required. bool - External
Id This property is required. string - Field usage depends on
service
value: - Serviceaws_msk_wh
: Fivetran generated External ID - Servicepanoply
: Fivetran generated External ID - Serviceperiscope_warehouse
: Fivetran generated External ID - Serviceredshift
: Fivetran generated External ID - External
Location This property is required. string - Field usage depends on
service
value: - Servicedatabricks
: 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. string - Fivetran
Msk Role Arn This property is required. string - Fivetran
Role Arn This property is required. string - Field usage depends on
service
value: - Servicenew_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: - Serviceaurora_postgres_warehouse
: Server name - Serviceaurora_warehouse
: Server name - Serviceazure_postgres_warehouse
: Server name - Serviceazure_sql_data_warehouse
: Server name - Serviceazure_sql_database
: Server name - Serviceazure_sql_managed_db_warehouse
: Server name - Servicemaria_rds_warehouse
: Server name - Servicemaria_warehouse
: Server name - Servicemysql_rds_warehouse
: Server name - Servicemysql_warehouse
: Server name - Servicepanoply
: Server name - Serviceperiscope_warehouse
: Server name - Servicepostgres_gcp_warehouse
: Server name - Servicepostgres_rds_warehouse
: Server name - Servicepostgres_warehouse
: Server name - Serviceredshift
: Server name - Servicesnowflake
: Server name - Servicesql_server_rds_warehouse
: Server name - Servicesql_server_warehouse
: Server name - Http
Path This property is required. string - Field usage depends on
service
value: - Serviceadls
: HTTP path - Servicedatabricks
: HTTP path - Servicenew_s3_datalake
: HTTP path - Serviceonelake
: HTTP path - Is
Private Key Encrypted This property is required. bool - Field usage depends on
service
value: - Servicesnowflake
: Indicates that a private key is encrypted. The default value:false
. The field can be specified if authentication type isKEY_PAIR
. - Is
Private Link Required This property is required. bool - Field usage depends on
service
value: - Servicenew_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: - Serviceredshift
: Is your destination Redshift Serverless - Lakehouse
Guid This property is required. string - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake lakehouse GUID - Lakehouse
Name This property is required. string - Field usage depends on
service
value: - Serviceonelake
: (Immutable) Name of your lakehouse - Msk
Sts Region This property is required. string - Num
Of Partitions This property is required. double - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Number of partitions per topic. - Oauth2Client
Id This property is required. string - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 client ID - Servicedatabricks
: OAuth 2.0 client ID - Servicenew_s3_datalake
: OAuth 2.0 client ID - Serviceonelake
: OAuth 2.0 client ID - Oauth2Secret
This property is required. string - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 secret - Servicedatabricks
: OAuth 2.0 secret - Servicenew_s3_datalake
: OAuth 2.0 secret - Serviceonelake
: OAuth 2.0 secret - Passphrase
This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: 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 isKEY_PAIR
. - Password
This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user password - Serviceaurora_warehouse
: Database user password - Serviceazure_postgres_warehouse
: Database user password - Serviceazure_sql_data_warehouse
: Database user password - Serviceazure_sql_database
: Database user password - Serviceazure_sql_managed_db_warehouse
: Database user password - Servicemaria_rds_warehouse
: Database user password - Servicemaria_warehouse
: Database user password - Servicemysql_rds_warehouse
: Database user password - Servicemysql_warehouse
: Database user password - Servicepanoply
: Database user password - Serviceperiscope_warehouse
: Database user password - Servicepostgres_gcp_warehouse
: Database user password - Servicepostgres_rds_warehouse
: Database user password - Servicepostgres_warehouse
: Database user password - Serviceredshift
: Database user password. Required if authentication type isPASSWORD
. - Servicesnowflake
: Database user password. The field should be specified if authentication type isPASSWORD
. - Servicesql_server_rds_warehouse
: Database user password - Servicesql_server_warehouse
: Database user password - Personal
Access Token This property is required. string - Field usage depends on
service
value: - Serviceadls
: Personal access token - Servicedatabricks
: Personal access token - Servicenew_s3_datalake
: Personal access token - Serviceonelake
: Personal access token - Port
This property is required. double - Field usage depends on
service
value: - Serviceadls
: Server port number - Serviceaurora_postgres_warehouse
: Server port number - Serviceaurora_warehouse
: Server port number - Serviceazure_postgres_warehouse
: Server port number - Serviceazure_sql_data_warehouse
: Server port number - Serviceazure_sql_database
: Server port number - Serviceazure_sql_managed_db_warehouse
: Server port number - Servicedatabricks
: Server port number - Servicemaria_rds_warehouse
: Server port number - Servicemaria_warehouse
: Server port number - Servicemysql_rds_warehouse
: Server port number - Servicemysql_warehouse
: Server port number - Servicenew_s3_datalake
: Server port number - Serviceonelake
: Server port number - Servicepanoply
: Server port number - Serviceperiscope_warehouse
: Server port number - Servicepostgres_gcp_warehouse
: Server port number - Servicepostgres_rds_warehouse
: Server port number - Servicepostgres_warehouse
: Server port number - Serviceredshift
: Server port number - Servicesnowflake
: Server port number - Servicesql_server_rds_warehouse
: Server port number - Servicesql_server_warehouse
: Server port number - Prefix
Path This property is required. string - Field usage depends on
service
value: - Serviceadls
: (Immutable) path/to/data within the container - Servicenew_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 - Serviceonelake
: (Immutable) path/to/data within your lakehouse inside the Files directory - Private
Key This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: Private access key. The field should be specified if authentication type isKEY_PAIR
. - Project
Id This property is required. string - Field usage depends on
service
value: - Servicebig_query
: BigQuery project ID - Public
Key This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Public Key - Serviceaurora_warehouse
: Public Key - Serviceazure_postgres_warehouse
: Public Key - Serviceazure_sql_data_warehouse
: Public Key - Serviceazure_sql_database
: Public Key - Serviceazure_sql_managed_db_warehouse
: Public Key - Servicemaria_rds_warehouse
: Public Key - Servicemaria_warehouse
: Public Key - Servicemysql_rds_warehouse
: Public Key - Servicemysql_warehouse
: Public Key - Servicepanoply
: Public Key - Serviceperiscope_warehouse
: Public Key - Servicepostgres_gcp_warehouse
: Public Key - Servicepostgres_rds_warehouse
: Public Key - Servicepostgres_warehouse
: Public Key - Serviceredshift
: Public Key - Servicesql_server_rds_warehouse
: Public Key - Servicesql_server_warehouse
: Public Key - Region
This property is required. string - Field usage depends on
service
value: - Servicenew_s3_datalake
: Region of your AWS S3 bucket - Registry
Name This property is required. string - Registry
Sts Region This property is required. string - Replication
Factor This property is required. double - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Replication factor. - Resource
Id This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceaurora_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_data_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_database
: Field to test Self serve Private Link - Serviceazure_sql_managed_db_warehouse
: Field to test Self serve Private Link - Servicedatabricks
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepanoply
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceperiscope_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_gcp_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceredshift
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesnowflake
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesql_server_rds_warehouse
: Field to test Self serve Private Link - Servicesql_server_warehouse
: Field to test Self serve Private Link - Role
This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: If not specified, Fivetran will use the user's default role - Role
Arn This property is required. string - Field usage depends on
service
value: - Serviceredshift
: Role ARN with Redshift permissions. Required if authentication type isIAM
. - Sasl
Mechanism This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - Sasl
Plain Key This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL key. - Sasl
Plain Secret This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL secret. - Schema
Compatibility This property is required. string - Schema
Registry This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema Registry - Schema
Registry Api Key This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API key. - Schema
Registry Api Secret This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API secret. - Schema
Registry Url This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry URL. - Secret
Key This property is required. string - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. string - Field usage depends on
service
value: - Serviceadls
: Secret value for service principal - Serviceonelake
: Secret value for service principal - Security
Protocol This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - Server
Host Name This property is required. string - Field usage depends on
service
value: - Serviceadls
: Server Host name - Servicedatabricks
: Server name - Servicenew_s3_datalake
: Server host name - Serviceonelake
: Server Host name - Should
Maintain Tables In Databricks This property is required. bool - Field usage depends on
service
value: - Serviceadls
: Should maintain tables in Databricks - Servicenew_s3_datalake
: Should maintain tables in Databricks - Serviceonelake
: Should maintain tables in Databricks - Snapshot
Retention Period This property is required. string - Field usage depends on
service
value: - Serviceadls
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Servicenew_s3_datalake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Serviceonelake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Snowflake
Cloud This property is required. string - Snowflake
Region This property is required. string - Storage
Account Name This property is required. string - Field usage depends on
service
value: - Serviceadls
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Serviceonelake
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Table
Format This property is required. string - Field usage depends on
service
value: - Servicenew_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. string - Field usage depends on
service
value: - Serviceadls
: Tenant id of service principal - Serviceonelake
: Tenant ID of service principal - Tunnel
Host This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Tunnel
Port This property is required. double - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Tunnel
User This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - User
This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user name - Serviceaurora_warehouse
: Database user name - Serviceazure_postgres_warehouse
: Database user name - Serviceazure_sql_data_warehouse
: Database user name - Serviceazure_sql_database
: Database user name - Serviceazure_sql_managed_db_warehouse
: Database user name - Servicemaria_rds_warehouse
: Database user name - Servicemaria_warehouse
: Database user name - Servicemysql_rds_warehouse
: Database user name - Servicemysql_warehouse
: Database user name - Servicepanoply
: Database user name - Serviceperiscope_warehouse
: Database user name - Servicepostgres_gcp_warehouse
: Database user name - Servicepostgres_rds_warehouse
: Database user name - Servicepostgres_warehouse
: Database user name - Serviceredshift
: Database user name - Servicesnowflake
: Database user name - Servicesql_server_rds_warehouse
: Database user name - Servicesql_server_warehouse
: Database user name - Workspace
Guid This property is required. string - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake workspace GUID - Workspace
Name This property is required. string - Field usage depends on
service
value: - Serviceonelake
: OneLake workspace name
- Always
Encrypted This property is required. bool - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: Require TLS through Tunnel - Servicesql_server_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Auth
This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: Password-based or key-based authentication type - Auth
Type This property is required. string - Field usage depends on
service
value: - Serviceadls
: Authentication type - Servicedatabricks
: Authentication type - Servicenew_s3_datalake
: Authentication type - Serviceonelake
: Authentication type - Serviceredshift
: Authentication type. Default value:PASSWORD
. - Aws
Access Key Id This property is required. string - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS access key to access the S3 bucket and AWS Glue - Aws
Secret Access Key This property is required. string - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS secret access key to access the S3 bucket and AWS Glue - Bootstrap
Servers This property is required. []string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Comma-separated list of Confluent Cloud servers in theserver:port
format. - Bucket
This property is required. string - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. - Servicenew_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: - Serviceadls
: Catalog name - Servicedatabricks
: Catalog name - Servicenew_s3_datalake
: Catalog name - Serviceonelake
: Catalog name - Client
Id This property is required. string - Field usage depends on
service
value: - Serviceadls
: Client id of service principal - Serviceonelake
: Client ID of service principal - Cloud
Provider This property is required. string - Field usage depends on
service
value: - Servicedatabricks
: Databricks deployment cloud - Cluster
Id This property is required. string - Field usage depends on
service
value: - Servicepanoply
: Cluster ID. - Serviceperiscope_warehouse
: Cluster ID. - Serviceredshift
: Cluster ID. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - Cluster
Region This property is required. string - Field usage depends on
service
value: - Servicepanoply
: Cluster region. - Serviceperiscope_warehouse
: Cluster region. - Serviceredshift
: Cluster region. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - Connection
Method This property is required. string - Connection
Type This property is required. string - Field usage depends on
service
value: - Serviceadls
: Connection method. Default value:Directly
. - Serviceaurora_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceaurora_warehouse
: Connection method. Default value:Directly
. - Serviceazure_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_data_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_database
: Connection method. Default value:Directly
. - Serviceazure_sql_managed_db_warehouse
: Connection method. Default value:Directly
. - Servicedatabricks
: Connection method. Default value:Directly
. - Servicemaria_rds_warehouse
: Connection method. Default value:Directly
. - Servicemaria_warehouse
: Connection method. Default value:Directly
. - Servicemysql_rds_warehouse
: Connection method. Default value:Directly
. - Servicemysql_warehouse
: Connection method. Default value:Directly
. - Servicepanoply
: Connection method. Default value:Directly
. - Serviceperiscope_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_gcp_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_rds_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_warehouse
: Connection method. Default value:Directly
. - Serviceredshift
: Connection method. Default value:Directly
. - Servicesnowflake
: Connection method. Default value:Directly
. - Servicesql_server_rds_warehouse
: Connection method. Default value:Directly
. - Servicesql_server_warehouse
: Connection method. Default value:Directly
. - Container
Name This property is required. string - Field usage depends on
service
value: - Serviceadls
: (Immutable) Container to store delta table files - Serviceonelake
: Workspace name to store delta table files - Controller
Id This property is required. string - Create
External Tables This property is required. bool - Field usage depends on
service
value: - Servicedatabricks
: Whether to create external tables - Data
Format This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud message format. - Data
Set Location This property is required. string - Field usage depends on
service
value: - Servicebig_query
: Data location. Datasets will reside in this location. - Servicebig_query_dts
: Data location. Datasets will reside in this location. - Servicemanaged_big_query
: Data location. Datasets will reside in this location. - Database
This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database name - Serviceaurora_warehouse
: Database name - Serviceazure_postgres_warehouse
: Database name - Serviceazure_sql_data_warehouse
: Database name - Serviceazure_sql_database
: Database name - Serviceazure_sql_managed_db_warehouse
: Database name - Servicemaria_rds_warehouse
: Database name - Servicemaria_warehouse
: Database name - Servicemysql_rds_warehouse
: Database name - Servicemysql_warehouse
: Database name - Servicepanoply
: Database name - Serviceperiscope_warehouse
: Database name - Servicepostgres_gcp_warehouse
: Database name - Servicepostgres_rds_warehouse
: Database name - Servicepostgres_warehouse
: Database name - Serviceredshift
: Database name - Servicesnowflake
: Database name - Servicesql_server_rds_warehouse
: Database name - Servicesql_server_warehouse
: Database name - Databricks
Connection Type This property is required. string - Field usage depends on
service
value: - Serviceadls
: Databricks Connection method. Default value:Directly
. - Servicenew_s3_datalake
: Databricks Connection method. Default value:Directly
. - Serviceonelake
: Databricks Connection method. Default value:Directly
. - Enable
Remote Execution This property is required. bool - External
Id This property is required. string - Field usage depends on
service
value: - Serviceaws_msk_wh
: Fivetran generated External ID - Servicepanoply
: Fivetran generated External ID - Serviceperiscope_warehouse
: Fivetran generated External ID - Serviceredshift
: Fivetran generated External ID - External
Location This property is required. string - Field usage depends on
service
value: - Servicedatabricks
: 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. string - Fivetran
Msk Role Arn This property is required. string - Fivetran
Role Arn This property is required. string - Field usage depends on
service
value: - Servicenew_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: - Serviceaurora_postgres_warehouse
: Server name - Serviceaurora_warehouse
: Server name - Serviceazure_postgres_warehouse
: Server name - Serviceazure_sql_data_warehouse
: Server name - Serviceazure_sql_database
: Server name - Serviceazure_sql_managed_db_warehouse
: Server name - Servicemaria_rds_warehouse
: Server name - Servicemaria_warehouse
: Server name - Servicemysql_rds_warehouse
: Server name - Servicemysql_warehouse
: Server name - Servicepanoply
: Server name - Serviceperiscope_warehouse
: Server name - Servicepostgres_gcp_warehouse
: Server name - Servicepostgres_rds_warehouse
: Server name - Servicepostgres_warehouse
: Server name - Serviceredshift
: Server name - Servicesnowflake
: Server name - Servicesql_server_rds_warehouse
: Server name - Servicesql_server_warehouse
: Server name - Http
Path This property is required. string - Field usage depends on
service
value: - Serviceadls
: HTTP path - Servicedatabricks
: HTTP path - Servicenew_s3_datalake
: HTTP path - Serviceonelake
: HTTP path - Is
Private Key Encrypted This property is required. bool - Field usage depends on
service
value: - Servicesnowflake
: Indicates that a private key is encrypted. The default value:false
. The field can be specified if authentication type isKEY_PAIR
. - Is
Private Link Required This property is required. bool - Field usage depends on
service
value: - Servicenew_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: - Serviceredshift
: Is your destination Redshift Serverless - Lakehouse
Guid This property is required. string - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake lakehouse GUID - Lakehouse
Name This property is required. string - Field usage depends on
service
value: - Serviceonelake
: (Immutable) Name of your lakehouse - Msk
Sts Region This property is required. string - Num
Of Partitions This property is required. float64 - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Number of partitions per topic. - Oauth2Client
Id This property is required. string - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 client ID - Servicedatabricks
: OAuth 2.0 client ID - Servicenew_s3_datalake
: OAuth 2.0 client ID - Serviceonelake
: OAuth 2.0 client ID - Oauth2Secret
This property is required. string - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 secret - Servicedatabricks
: OAuth 2.0 secret - Servicenew_s3_datalake
: OAuth 2.0 secret - Serviceonelake
: OAuth 2.0 secret - Passphrase
This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: 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 isKEY_PAIR
. - Password
This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user password - Serviceaurora_warehouse
: Database user password - Serviceazure_postgres_warehouse
: Database user password - Serviceazure_sql_data_warehouse
: Database user password - Serviceazure_sql_database
: Database user password - Serviceazure_sql_managed_db_warehouse
: Database user password - Servicemaria_rds_warehouse
: Database user password - Servicemaria_warehouse
: Database user password - Servicemysql_rds_warehouse
: Database user password - Servicemysql_warehouse
: Database user password - Servicepanoply
: Database user password - Serviceperiscope_warehouse
: Database user password - Servicepostgres_gcp_warehouse
: Database user password - Servicepostgres_rds_warehouse
: Database user password - Servicepostgres_warehouse
: Database user password - Serviceredshift
: Database user password. Required if authentication type isPASSWORD
. - Servicesnowflake
: Database user password. The field should be specified if authentication type isPASSWORD
. - Servicesql_server_rds_warehouse
: Database user password - Servicesql_server_warehouse
: Database user password - Personal
Access Token This property is required. string - Field usage depends on
service
value: - Serviceadls
: Personal access token - Servicedatabricks
: Personal access token - Servicenew_s3_datalake
: Personal access token - Serviceonelake
: Personal access token - Port
This property is required. float64 - Field usage depends on
service
value: - Serviceadls
: Server port number - Serviceaurora_postgres_warehouse
: Server port number - Serviceaurora_warehouse
: Server port number - Serviceazure_postgres_warehouse
: Server port number - Serviceazure_sql_data_warehouse
: Server port number - Serviceazure_sql_database
: Server port number - Serviceazure_sql_managed_db_warehouse
: Server port number - Servicedatabricks
: Server port number - Servicemaria_rds_warehouse
: Server port number - Servicemaria_warehouse
: Server port number - Servicemysql_rds_warehouse
: Server port number - Servicemysql_warehouse
: Server port number - Servicenew_s3_datalake
: Server port number - Serviceonelake
: Server port number - Servicepanoply
: Server port number - Serviceperiscope_warehouse
: Server port number - Servicepostgres_gcp_warehouse
: Server port number - Servicepostgres_rds_warehouse
: Server port number - Servicepostgres_warehouse
: Server port number - Serviceredshift
: Server port number - Servicesnowflake
: Server port number - Servicesql_server_rds_warehouse
: Server port number - Servicesql_server_warehouse
: Server port number - Prefix
Path This property is required. string - Field usage depends on
service
value: - Serviceadls
: (Immutable) path/to/data within the container - Servicenew_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 - Serviceonelake
: (Immutable) path/to/data within your lakehouse inside the Files directory - Private
Key This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: Private access key. The field should be specified if authentication type isKEY_PAIR
. - Project
Id This property is required. string - Field usage depends on
service
value: - Servicebig_query
: BigQuery project ID - Public
Key This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Public Key - Serviceaurora_warehouse
: Public Key - Serviceazure_postgres_warehouse
: Public Key - Serviceazure_sql_data_warehouse
: Public Key - Serviceazure_sql_database
: Public Key - Serviceazure_sql_managed_db_warehouse
: Public Key - Servicemaria_rds_warehouse
: Public Key - Servicemaria_warehouse
: Public Key - Servicemysql_rds_warehouse
: Public Key - Servicemysql_warehouse
: Public Key - Servicepanoply
: Public Key - Serviceperiscope_warehouse
: Public Key - Servicepostgres_gcp_warehouse
: Public Key - Servicepostgres_rds_warehouse
: Public Key - Servicepostgres_warehouse
: Public Key - Serviceredshift
: Public Key - Servicesql_server_rds_warehouse
: Public Key - Servicesql_server_warehouse
: Public Key - Region
This property is required. string - Field usage depends on
service
value: - Servicenew_s3_datalake
: Region of your AWS S3 bucket - Registry
Name This property is required. string - Registry
Sts Region This property is required. string - Replication
Factor This property is required. float64 - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Replication factor. - Resource
Id This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceaurora_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_data_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_database
: Field to test Self serve Private Link - Serviceazure_sql_managed_db_warehouse
: Field to test Self serve Private Link - Servicedatabricks
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepanoply
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceperiscope_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_gcp_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceredshift
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesnowflake
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesql_server_rds_warehouse
: Field to test Self serve Private Link - Servicesql_server_warehouse
: Field to test Self serve Private Link - Role
This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: If not specified, Fivetran will use the user's default role - Role
Arn This property is required. string - Field usage depends on
service
value: - Serviceredshift
: Role ARN with Redshift permissions. Required if authentication type isIAM
. - Sasl
Mechanism This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - Sasl
Plain Key This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL key. - Sasl
Plain Secret This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL secret. - Schema
Compatibility This property is required. string - Schema
Registry This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema Registry - Schema
Registry Api Key This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API key. - Schema
Registry Api Secret This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API secret. - Schema
Registry Url This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry URL. - Secret
Key This property is required. string - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. string - Field usage depends on
service
value: - Serviceadls
: Secret value for service principal - Serviceonelake
: Secret value for service principal - Security
Protocol This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - Server
Host Name This property is required. string - Field usage depends on
service
value: - Serviceadls
: Server Host name - Servicedatabricks
: Server name - Servicenew_s3_datalake
: Server host name - Serviceonelake
: Server Host name - Should
Maintain Tables In Databricks This property is required. bool - Field usage depends on
service
value: - Serviceadls
: Should maintain tables in Databricks - Servicenew_s3_datalake
: Should maintain tables in Databricks - Serviceonelake
: Should maintain tables in Databricks - Snapshot
Retention Period This property is required. string - Field usage depends on
service
value: - Serviceadls
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Servicenew_s3_datalake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Serviceonelake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Snowflake
Cloud This property is required. string - Snowflake
Region This property is required. string - Storage
Account Name This property is required. string - Field usage depends on
service
value: - Serviceadls
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Serviceonelake
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Table
Format This property is required. string - Field usage depends on
service
value: - Servicenew_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. string - Field usage depends on
service
value: - Serviceadls
: Tenant id of service principal - Serviceonelake
: Tenant ID of service principal - Tunnel
Host This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Tunnel
Port This property is required. float64 - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Tunnel
User This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - User
This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user name - Serviceaurora_warehouse
: Database user name - Serviceazure_postgres_warehouse
: Database user name - Serviceazure_sql_data_warehouse
: Database user name - Serviceazure_sql_database
: Database user name - Serviceazure_sql_managed_db_warehouse
: Database user name - Servicemaria_rds_warehouse
: Database user name - Servicemaria_warehouse
: Database user name - Servicemysql_rds_warehouse
: Database user name - Servicemysql_warehouse
: Database user name - Servicepanoply
: Database user name - Serviceperiscope_warehouse
: Database user name - Servicepostgres_gcp_warehouse
: Database user name - Servicepostgres_rds_warehouse
: Database user name - Servicepostgres_warehouse
: Database user name - Serviceredshift
: Database user name - Servicesnowflake
: Database user name - Servicesql_server_rds_warehouse
: Database user name - Servicesql_server_warehouse
: Database user name - Workspace
Guid This property is required. string - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake workspace GUID - Workspace
Name This property is required. string - Field usage depends on
service
value: - Serviceonelake
: OneLake workspace name
- always
Encrypted This property is required. Boolean - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: Require TLS through Tunnel - Servicesql_server_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - auth
This property is required. String - Field usage depends on
service
value: - Servicesnowflake
: Password-based or key-based authentication type - auth
Type This property is required. String - Field usage depends on
service
value: - Serviceadls
: Authentication type - Servicedatabricks
: Authentication type - Servicenew_s3_datalake
: Authentication type - Serviceonelake
: Authentication type - Serviceredshift
: Authentication type. Default value:PASSWORD
. - aws
Access Key Id This property is required. String - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS access key to access the S3 bucket and AWS Glue - aws
Secret Access Key This property is required. String - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS secret access key to access the S3 bucket and AWS Glue - bootstrap
Servers This property is required. List<String> - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Comma-separated list of Confluent Cloud servers in theserver:port
format. - bucket
This property is required. String - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. - Servicenew_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: - Serviceadls
: Catalog name - Servicedatabricks
: Catalog name - Servicenew_s3_datalake
: Catalog name - Serviceonelake
: Catalog name - client
Id This property is required. String - Field usage depends on
service
value: - Serviceadls
: Client id of service principal - Serviceonelake
: Client ID of service principal - cloud
Provider This property is required. String - Field usage depends on
service
value: - Servicedatabricks
: Databricks deployment cloud - cluster
Id This property is required. String - Field usage depends on
service
value: - Servicepanoply
: Cluster ID. - Serviceperiscope_warehouse
: Cluster ID. - Serviceredshift
: Cluster ID. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - cluster
Region This property is required. String - Field usage depends on
service
value: - Servicepanoply
: Cluster region. - Serviceperiscope_warehouse
: Cluster region. - Serviceredshift
: Cluster region. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - connection
Method This property is required. String - connection
Type This property is required. String - Field usage depends on
service
value: - Serviceadls
: Connection method. Default value:Directly
. - Serviceaurora_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceaurora_warehouse
: Connection method. Default value:Directly
. - Serviceazure_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_data_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_database
: Connection method. Default value:Directly
. - Serviceazure_sql_managed_db_warehouse
: Connection method. Default value:Directly
. - Servicedatabricks
: Connection method. Default value:Directly
. - Servicemaria_rds_warehouse
: Connection method. Default value:Directly
. - Servicemaria_warehouse
: Connection method. Default value:Directly
. - Servicemysql_rds_warehouse
: Connection method. Default value:Directly
. - Servicemysql_warehouse
: Connection method. Default value:Directly
. - Servicepanoply
: Connection method. Default value:Directly
. - Serviceperiscope_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_gcp_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_rds_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_warehouse
: Connection method. Default value:Directly
. - Serviceredshift
: Connection method. Default value:Directly
. - Servicesnowflake
: Connection method. Default value:Directly
. - Servicesql_server_rds_warehouse
: Connection method. Default value:Directly
. - Servicesql_server_warehouse
: Connection method. Default value:Directly
. - container
Name This property is required. String - Field usage depends on
service
value: - Serviceadls
: (Immutable) Container to store delta table files - Serviceonelake
: Workspace name to store delta table files - controller
Id This property is required. String - create
External Tables This property is required. Boolean - Field usage depends on
service
value: - Servicedatabricks
: Whether to create external tables - data
Format This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud message format. - data
Set Location This property is required. String - Field usage depends on
service
value: - Servicebig_query
: Data location. Datasets will reside in this location. - Servicebig_query_dts
: Data location. Datasets will reside in this location. - Servicemanaged_big_query
: Data location. Datasets will reside in this location. - database
This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database name - Serviceaurora_warehouse
: Database name - Serviceazure_postgres_warehouse
: Database name - Serviceazure_sql_data_warehouse
: Database name - Serviceazure_sql_database
: Database name - Serviceazure_sql_managed_db_warehouse
: Database name - Servicemaria_rds_warehouse
: Database name - Servicemaria_warehouse
: Database name - Servicemysql_rds_warehouse
: Database name - Servicemysql_warehouse
: Database name - Servicepanoply
: Database name - Serviceperiscope_warehouse
: Database name - Servicepostgres_gcp_warehouse
: Database name - Servicepostgres_rds_warehouse
: Database name - Servicepostgres_warehouse
: Database name - Serviceredshift
: Database name - Servicesnowflake
: Database name - Servicesql_server_rds_warehouse
: Database name - Servicesql_server_warehouse
: Database name - databricks
Connection Type This property is required. String - Field usage depends on
service
value: - Serviceadls
: Databricks Connection method. Default value:Directly
. - Servicenew_s3_datalake
: Databricks Connection method. Default value:Directly
. - Serviceonelake
: Databricks Connection method. Default value:Directly
. - enable
Remote Execution This property is required. Boolean - external
Id This property is required. String - Field usage depends on
service
value: - Serviceaws_msk_wh
: Fivetran generated External ID - Servicepanoply
: Fivetran generated External ID - Serviceperiscope_warehouse
: Fivetran generated External ID - Serviceredshift
: Fivetran generated External ID - external
Location This property is required. String - Field usage depends on
service
value: - Servicedatabricks
: 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. String - fivetran
Msk Role Arn This property is required. String - fivetran
Role Arn This property is required. String - Field usage depends on
service
value: - Servicenew_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: - Serviceaurora_postgres_warehouse
: Server name - Serviceaurora_warehouse
: Server name - Serviceazure_postgres_warehouse
: Server name - Serviceazure_sql_data_warehouse
: Server name - Serviceazure_sql_database
: Server name - Serviceazure_sql_managed_db_warehouse
: Server name - Servicemaria_rds_warehouse
: Server name - Servicemaria_warehouse
: Server name - Servicemysql_rds_warehouse
: Server name - Servicemysql_warehouse
: Server name - Servicepanoply
: Server name - Serviceperiscope_warehouse
: Server name - Servicepostgres_gcp_warehouse
: Server name - Servicepostgres_rds_warehouse
: Server name - Servicepostgres_warehouse
: Server name - Serviceredshift
: Server name - Servicesnowflake
: Server name - Servicesql_server_rds_warehouse
: Server name - Servicesql_server_warehouse
: Server name - http
Path This property is required. String - Field usage depends on
service
value: - Serviceadls
: HTTP path - Servicedatabricks
: HTTP path - Servicenew_s3_datalake
: HTTP path - Serviceonelake
: HTTP path - is
Private Key Encrypted This property is required. Boolean - Field usage depends on
service
value: - Servicesnowflake
: Indicates that a private key is encrypted. The default value:false
. The field can be specified if authentication type isKEY_PAIR
. - is
Private Link Required This property is required. Boolean - Field usage depends on
service
value: - Servicenew_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. Boolean - Field usage depends on
service
value: - Serviceredshift
: Is your destination Redshift Serverless - lakehouse
Guid This property is required. String - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake lakehouse GUID - lakehouse
Name This property is required. String - Field usage depends on
service
value: - Serviceonelake
: (Immutable) Name of your lakehouse - msk
Sts Region This property is required. String - num
Of Partitions This property is required. Double - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Number of partitions per topic. - oauth2Client
Id This property is required. String - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 client ID - Servicedatabricks
: OAuth 2.0 client ID - Servicenew_s3_datalake
: OAuth 2.0 client ID - Serviceonelake
: OAuth 2.0 client ID - oauth2Secret
This property is required. String - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 secret - Servicedatabricks
: OAuth 2.0 secret - Servicenew_s3_datalake
: OAuth 2.0 secret - Serviceonelake
: OAuth 2.0 secret - passphrase
This property is required. String - Field usage depends on
service
value: - Servicesnowflake
: 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 isKEY_PAIR
. - password
This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user password - Serviceaurora_warehouse
: Database user password - Serviceazure_postgres_warehouse
: Database user password - Serviceazure_sql_data_warehouse
: Database user password - Serviceazure_sql_database
: Database user password - Serviceazure_sql_managed_db_warehouse
: Database user password - Servicemaria_rds_warehouse
: Database user password - Servicemaria_warehouse
: Database user password - Servicemysql_rds_warehouse
: Database user password - Servicemysql_warehouse
: Database user password - Servicepanoply
: Database user password - Serviceperiscope_warehouse
: Database user password - Servicepostgres_gcp_warehouse
: Database user password - Servicepostgres_rds_warehouse
: Database user password - Servicepostgres_warehouse
: Database user password - Serviceredshift
: Database user password. Required if authentication type isPASSWORD
. - Servicesnowflake
: Database user password. The field should be specified if authentication type isPASSWORD
. - Servicesql_server_rds_warehouse
: Database user password - Servicesql_server_warehouse
: Database user password - personal
Access Token This property is required. String - Field usage depends on
service
value: - Serviceadls
: Personal access token - Servicedatabricks
: Personal access token - Servicenew_s3_datalake
: Personal access token - Serviceonelake
: Personal access token - port
This property is required. Double - Field usage depends on
service
value: - Serviceadls
: Server port number - Serviceaurora_postgres_warehouse
: Server port number - Serviceaurora_warehouse
: Server port number - Serviceazure_postgres_warehouse
: Server port number - Serviceazure_sql_data_warehouse
: Server port number - Serviceazure_sql_database
: Server port number - Serviceazure_sql_managed_db_warehouse
: Server port number - Servicedatabricks
: Server port number - Servicemaria_rds_warehouse
: Server port number - Servicemaria_warehouse
: Server port number - Servicemysql_rds_warehouse
: Server port number - Servicemysql_warehouse
: Server port number - Servicenew_s3_datalake
: Server port number - Serviceonelake
: Server port number - Servicepanoply
: Server port number - Serviceperiscope_warehouse
: Server port number - Servicepostgres_gcp_warehouse
: Server port number - Servicepostgres_rds_warehouse
: Server port number - Servicepostgres_warehouse
: Server port number - Serviceredshift
: Server port number - Servicesnowflake
: Server port number - Servicesql_server_rds_warehouse
: Server port number - Servicesql_server_warehouse
: Server port number - prefix
Path This property is required. String - Field usage depends on
service
value: - Serviceadls
: (Immutable) path/to/data within the container - Servicenew_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 - Serviceonelake
: (Immutable) path/to/data within your lakehouse inside the Files directory - private
Key This property is required. String - Field usage depends on
service
value: - Servicesnowflake
: Private access key. The field should be specified if authentication type isKEY_PAIR
. - project
Id This property is required. String - Field usage depends on
service
value: - Servicebig_query
: BigQuery project ID - public
Key This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Public Key - Serviceaurora_warehouse
: Public Key - Serviceazure_postgres_warehouse
: Public Key - Serviceazure_sql_data_warehouse
: Public Key - Serviceazure_sql_database
: Public Key - Serviceazure_sql_managed_db_warehouse
: Public Key - Servicemaria_rds_warehouse
: Public Key - Servicemaria_warehouse
: Public Key - Servicemysql_rds_warehouse
: Public Key - Servicemysql_warehouse
: Public Key - Servicepanoply
: Public Key - Serviceperiscope_warehouse
: Public Key - Servicepostgres_gcp_warehouse
: Public Key - Servicepostgres_rds_warehouse
: Public Key - Servicepostgres_warehouse
: Public Key - Serviceredshift
: Public Key - Servicesql_server_rds_warehouse
: Public Key - Servicesql_server_warehouse
: Public Key - region
This property is required. String - Field usage depends on
service
value: - Servicenew_s3_datalake
: Region of your AWS S3 bucket - registry
Name This property is required. String - registry
Sts Region This property is required. String - replication
Factor This property is required. Double - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Replication factor. - resource
Id This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceaurora_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_data_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_database
: Field to test Self serve Private Link - Serviceazure_sql_managed_db_warehouse
: Field to test Self serve Private Link - Servicedatabricks
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepanoply
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceperiscope_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_gcp_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceredshift
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesnowflake
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesql_server_rds_warehouse
: Field to test Self serve Private Link - Servicesql_server_warehouse
: Field to test Self serve Private Link - role
This property is required. String - Field usage depends on
service
value: - Servicesnowflake
: If not specified, Fivetran will use the user's default role - role
Arn This property is required. String - Field usage depends on
service
value: - Serviceredshift
: Role ARN with Redshift permissions. Required if authentication type isIAM
. - sasl
Mechanism This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - sasl
Plain Key This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL key. - sasl
Plain Secret This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL secret. - schema
Compatibility This property is required. String - schema
Registry This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema Registry - schema
Registry Api Key This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API key. - schema
Registry Api Secret This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API secret. - schema
Registry Url This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry URL. - secret
Key This property is required. String - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. String - Field usage depends on
service
value: - Serviceadls
: Secret value for service principal - Serviceonelake
: Secret value for service principal - security
Protocol This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - server
Host Name This property is required. String - Field usage depends on
service
value: - Serviceadls
: Server Host name - Servicedatabricks
: Server name - Servicenew_s3_datalake
: Server host name - Serviceonelake
: Server Host name - should
Maintain Tables In Databricks This property is required. Boolean - Field usage depends on
service
value: - Serviceadls
: Should maintain tables in Databricks - Servicenew_s3_datalake
: Should maintain tables in Databricks - Serviceonelake
: Should maintain tables in Databricks - snapshot
Retention Period This property is required. String - Field usage depends on
service
value: - Serviceadls
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Servicenew_s3_datalake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Serviceonelake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - snowflake
Cloud This property is required. String - snowflake
Region This property is required. String - storage
Account Name This property is required. String - Field usage depends on
service
value: - Serviceadls
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Serviceonelake
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - table
Format This property is required. String - Field usage depends on
service
value: - Servicenew_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. String - Field usage depends on
service
value: - Serviceadls
: Tenant id of service principal - Serviceonelake
: Tenant ID of service principal - tunnel
Host This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - tunnel
Port This property is required. Double - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - tunnel
User This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - user
This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user name - Serviceaurora_warehouse
: Database user name - Serviceazure_postgres_warehouse
: Database user name - Serviceazure_sql_data_warehouse
: Database user name - Serviceazure_sql_database
: Database user name - Serviceazure_sql_managed_db_warehouse
: Database user name - Servicemaria_rds_warehouse
: Database user name - Servicemaria_warehouse
: Database user name - Servicemysql_rds_warehouse
: Database user name - Servicemysql_warehouse
: Database user name - Servicepanoply
: Database user name - Serviceperiscope_warehouse
: Database user name - Servicepostgres_gcp_warehouse
: Database user name - Servicepostgres_rds_warehouse
: Database user name - Servicepostgres_warehouse
: Database user name - Serviceredshift
: Database user name - Servicesnowflake
: Database user name - Servicesql_server_rds_warehouse
: Database user name - Servicesql_server_warehouse
: Database user name - workspace
Guid This property is required. String - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake workspace GUID - workspace
Name This property is required. String - Field usage depends on
service
value: - Serviceonelake
: OneLake workspace name
- always
Encrypted This property is required. boolean - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: Require TLS through Tunnel - Servicesql_server_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - auth
This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: Password-based or key-based authentication type - auth
Type This property is required. string - Field usage depends on
service
value: - Serviceadls
: Authentication type - Servicedatabricks
: Authentication type - Servicenew_s3_datalake
: Authentication type - Serviceonelake
: Authentication type - Serviceredshift
: Authentication type. Default value:PASSWORD
. - aws
Access Key Id This property is required. string - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS access key to access the S3 bucket and AWS Glue - aws
Secret Access Key This property is required. string - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS secret access key to access the S3 bucket and AWS Glue - bootstrap
Servers This property is required. string[] - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Comma-separated list of Confluent Cloud servers in theserver:port
format. - bucket
This property is required. string - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. - Servicenew_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: - Serviceadls
: Catalog name - Servicedatabricks
: Catalog name - Servicenew_s3_datalake
: Catalog name - Serviceonelake
: Catalog name - client
Id This property is required. string - Field usage depends on
service
value: - Serviceadls
: Client id of service principal - Serviceonelake
: Client ID of service principal - cloud
Provider This property is required. string - Field usage depends on
service
value: - Servicedatabricks
: Databricks deployment cloud - cluster
Id This property is required. string - Field usage depends on
service
value: - Servicepanoply
: Cluster ID. - Serviceperiscope_warehouse
: Cluster ID. - Serviceredshift
: Cluster ID. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - cluster
Region This property is required. string - Field usage depends on
service
value: - Servicepanoply
: Cluster region. - Serviceperiscope_warehouse
: Cluster region. - Serviceredshift
: Cluster region. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - connection
Method This property is required. string - connection
Type This property is required. string - Field usage depends on
service
value: - Serviceadls
: Connection method. Default value:Directly
. - Serviceaurora_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceaurora_warehouse
: Connection method. Default value:Directly
. - Serviceazure_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_data_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_database
: Connection method. Default value:Directly
. - Serviceazure_sql_managed_db_warehouse
: Connection method. Default value:Directly
. - Servicedatabricks
: Connection method. Default value:Directly
. - Servicemaria_rds_warehouse
: Connection method. Default value:Directly
. - Servicemaria_warehouse
: Connection method. Default value:Directly
. - Servicemysql_rds_warehouse
: Connection method. Default value:Directly
. - Servicemysql_warehouse
: Connection method. Default value:Directly
. - Servicepanoply
: Connection method. Default value:Directly
. - Serviceperiscope_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_gcp_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_rds_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_warehouse
: Connection method. Default value:Directly
. - Serviceredshift
: Connection method. Default value:Directly
. - Servicesnowflake
: Connection method. Default value:Directly
. - Servicesql_server_rds_warehouse
: Connection method. Default value:Directly
. - Servicesql_server_warehouse
: Connection method. Default value:Directly
. - container
Name This property is required. string - Field usage depends on
service
value: - Serviceadls
: (Immutable) Container to store delta table files - Serviceonelake
: Workspace name to store delta table files - controller
Id This property is required. string - create
External Tables This property is required. boolean - Field usage depends on
service
value: - Servicedatabricks
: Whether to create external tables - data
Format This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud message format. - data
Set Location This property is required. string - Field usage depends on
service
value: - Servicebig_query
: Data location. Datasets will reside in this location. - Servicebig_query_dts
: Data location. Datasets will reside in this location. - Servicemanaged_big_query
: Data location. Datasets will reside in this location. - database
This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database name - Serviceaurora_warehouse
: Database name - Serviceazure_postgres_warehouse
: Database name - Serviceazure_sql_data_warehouse
: Database name - Serviceazure_sql_database
: Database name - Serviceazure_sql_managed_db_warehouse
: Database name - Servicemaria_rds_warehouse
: Database name - Servicemaria_warehouse
: Database name - Servicemysql_rds_warehouse
: Database name - Servicemysql_warehouse
: Database name - Servicepanoply
: Database name - Serviceperiscope_warehouse
: Database name - Servicepostgres_gcp_warehouse
: Database name - Servicepostgres_rds_warehouse
: Database name - Servicepostgres_warehouse
: Database name - Serviceredshift
: Database name - Servicesnowflake
: Database name - Servicesql_server_rds_warehouse
: Database name - Servicesql_server_warehouse
: Database name - databricks
Connection Type This property is required. string - Field usage depends on
service
value: - Serviceadls
: Databricks Connection method. Default value:Directly
. - Servicenew_s3_datalake
: Databricks Connection method. Default value:Directly
. - Serviceonelake
: Databricks Connection method. Default value:Directly
. - enable
Remote Execution This property is required. boolean - external
Id This property is required. string - Field usage depends on
service
value: - Serviceaws_msk_wh
: Fivetran generated External ID - Servicepanoply
: Fivetran generated External ID - Serviceperiscope_warehouse
: Fivetran generated External ID - Serviceredshift
: Fivetran generated External ID - external
Location This property is required. string - Field usage depends on
service
value: - Servicedatabricks
: 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. string - fivetran
Msk Role Arn This property is required. string - fivetran
Role Arn This property is required. string - Field usage depends on
service
value: - Servicenew_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: - Serviceaurora_postgres_warehouse
: Server name - Serviceaurora_warehouse
: Server name - Serviceazure_postgres_warehouse
: Server name - Serviceazure_sql_data_warehouse
: Server name - Serviceazure_sql_database
: Server name - Serviceazure_sql_managed_db_warehouse
: Server name - Servicemaria_rds_warehouse
: Server name - Servicemaria_warehouse
: Server name - Servicemysql_rds_warehouse
: Server name - Servicemysql_warehouse
: Server name - Servicepanoply
: Server name - Serviceperiscope_warehouse
: Server name - Servicepostgres_gcp_warehouse
: Server name - Servicepostgres_rds_warehouse
: Server name - Servicepostgres_warehouse
: Server name - Serviceredshift
: Server name - Servicesnowflake
: Server name - Servicesql_server_rds_warehouse
: Server name - Servicesql_server_warehouse
: Server name - http
Path This property is required. string - Field usage depends on
service
value: - Serviceadls
: HTTP path - Servicedatabricks
: HTTP path - Servicenew_s3_datalake
: HTTP path - Serviceonelake
: HTTP path - is
Private Key Encrypted This property is required. boolean - Field usage depends on
service
value: - Servicesnowflake
: Indicates that a private key is encrypted. The default value:false
. The field can be specified if authentication type isKEY_PAIR
. - is
Private Link Required This property is required. boolean - Field usage depends on
service
value: - Servicenew_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. boolean - Field usage depends on
service
value: - Serviceredshift
: Is your destination Redshift Serverless - lakehouse
Guid This property is required. string - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake lakehouse GUID - lakehouse
Name This property is required. string - Field usage depends on
service
value: - Serviceonelake
: (Immutable) Name of your lakehouse - msk
Sts Region This property is required. string - num
Of Partitions This property is required. number - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Number of partitions per topic. - oauth2Client
Id This property is required. string - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 client ID - Servicedatabricks
: OAuth 2.0 client ID - Servicenew_s3_datalake
: OAuth 2.0 client ID - Serviceonelake
: OAuth 2.0 client ID - oauth2Secret
This property is required. string - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 secret - Servicedatabricks
: OAuth 2.0 secret - Servicenew_s3_datalake
: OAuth 2.0 secret - Serviceonelake
: OAuth 2.0 secret - passphrase
This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: 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 isKEY_PAIR
. - password
This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user password - Serviceaurora_warehouse
: Database user password - Serviceazure_postgres_warehouse
: Database user password - Serviceazure_sql_data_warehouse
: Database user password - Serviceazure_sql_database
: Database user password - Serviceazure_sql_managed_db_warehouse
: Database user password - Servicemaria_rds_warehouse
: Database user password - Servicemaria_warehouse
: Database user password - Servicemysql_rds_warehouse
: Database user password - Servicemysql_warehouse
: Database user password - Servicepanoply
: Database user password - Serviceperiscope_warehouse
: Database user password - Servicepostgres_gcp_warehouse
: Database user password - Servicepostgres_rds_warehouse
: Database user password - Servicepostgres_warehouse
: Database user password - Serviceredshift
: Database user password. Required if authentication type isPASSWORD
. - Servicesnowflake
: Database user password. The field should be specified if authentication type isPASSWORD
. - Servicesql_server_rds_warehouse
: Database user password - Servicesql_server_warehouse
: Database user password - personal
Access Token This property is required. string - Field usage depends on
service
value: - Serviceadls
: Personal access token - Servicedatabricks
: Personal access token - Servicenew_s3_datalake
: Personal access token - Serviceonelake
: Personal access token - port
This property is required. number - Field usage depends on
service
value: - Serviceadls
: Server port number - Serviceaurora_postgres_warehouse
: Server port number - Serviceaurora_warehouse
: Server port number - Serviceazure_postgres_warehouse
: Server port number - Serviceazure_sql_data_warehouse
: Server port number - Serviceazure_sql_database
: Server port number - Serviceazure_sql_managed_db_warehouse
: Server port number - Servicedatabricks
: Server port number - Servicemaria_rds_warehouse
: Server port number - Servicemaria_warehouse
: Server port number - Servicemysql_rds_warehouse
: Server port number - Servicemysql_warehouse
: Server port number - Servicenew_s3_datalake
: Server port number - Serviceonelake
: Server port number - Servicepanoply
: Server port number - Serviceperiscope_warehouse
: Server port number - Servicepostgres_gcp_warehouse
: Server port number - Servicepostgres_rds_warehouse
: Server port number - Servicepostgres_warehouse
: Server port number - Serviceredshift
: Server port number - Servicesnowflake
: Server port number - Servicesql_server_rds_warehouse
: Server port number - Servicesql_server_warehouse
: Server port number - prefix
Path This property is required. string - Field usage depends on
service
value: - Serviceadls
: (Immutable) path/to/data within the container - Servicenew_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 - Serviceonelake
: (Immutable) path/to/data within your lakehouse inside the Files directory - private
Key This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: Private access key. The field should be specified if authentication type isKEY_PAIR
. - project
Id This property is required. string - Field usage depends on
service
value: - Servicebig_query
: BigQuery project ID - public
Key This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Public Key - Serviceaurora_warehouse
: Public Key - Serviceazure_postgres_warehouse
: Public Key - Serviceazure_sql_data_warehouse
: Public Key - Serviceazure_sql_database
: Public Key - Serviceazure_sql_managed_db_warehouse
: Public Key - Servicemaria_rds_warehouse
: Public Key - Servicemaria_warehouse
: Public Key - Servicemysql_rds_warehouse
: Public Key - Servicemysql_warehouse
: Public Key - Servicepanoply
: Public Key - Serviceperiscope_warehouse
: Public Key - Servicepostgres_gcp_warehouse
: Public Key - Servicepostgres_rds_warehouse
: Public Key - Servicepostgres_warehouse
: Public Key - Serviceredshift
: Public Key - Servicesql_server_rds_warehouse
: Public Key - Servicesql_server_warehouse
: Public Key - region
This property is required. string - Field usage depends on
service
value: - Servicenew_s3_datalake
: Region of your AWS S3 bucket - registry
Name This property is required. string - registry
Sts Region This property is required. string - replication
Factor This property is required. number - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Replication factor. - resource
Id This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceaurora_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_data_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_database
: Field to test Self serve Private Link - Serviceazure_sql_managed_db_warehouse
: Field to test Self serve Private Link - Servicedatabricks
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepanoply
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceperiscope_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_gcp_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceredshift
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesnowflake
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesql_server_rds_warehouse
: Field to test Self serve Private Link - Servicesql_server_warehouse
: Field to test Self serve Private Link - role
This property is required. string - Field usage depends on
service
value: - Servicesnowflake
: If not specified, Fivetran will use the user's default role - role
Arn This property is required. string - Field usage depends on
service
value: - Serviceredshift
: Role ARN with Redshift permissions. Required if authentication type isIAM
. - sasl
Mechanism This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - sasl
Plain Key This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL key. - sasl
Plain Secret This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL secret. - schema
Compatibility This property is required. string - schema
Registry This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema Registry - schema
Registry Api Key This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API key. - schema
Registry Api Secret This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API secret. - schema
Registry Url This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry URL. - secret
Key This property is required. string - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. string - Field usage depends on
service
value: - Serviceadls
: Secret value for service principal - Serviceonelake
: Secret value for service principal - security
Protocol This property is required. string - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - server
Host Name This property is required. string - Field usage depends on
service
value: - Serviceadls
: Server Host name - Servicedatabricks
: Server name - Servicenew_s3_datalake
: Server host name - Serviceonelake
: Server Host name - should
Maintain Tables In Databricks This property is required. boolean - Field usage depends on
service
value: - Serviceadls
: Should maintain tables in Databricks - Servicenew_s3_datalake
: Should maintain tables in Databricks - Serviceonelake
: Should maintain tables in Databricks - snapshot
Retention Period This property is required. string - Field usage depends on
service
value: - Serviceadls
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Servicenew_s3_datalake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Serviceonelake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - snowflake
Cloud This property is required. string - snowflake
Region This property is required. string - storage
Account Name This property is required. string - Field usage depends on
service
value: - Serviceadls
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Serviceonelake
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - table
Format This property is required. string - Field usage depends on
service
value: - Servicenew_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. string - Field usage depends on
service
value: - Serviceadls
: Tenant id of service principal - Serviceonelake
: Tenant ID of service principal - tunnel
Host This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - tunnel
Port This property is required. number - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - tunnel
User This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - user
This property is required. string - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user name - Serviceaurora_warehouse
: Database user name - Serviceazure_postgres_warehouse
: Database user name - Serviceazure_sql_data_warehouse
: Database user name - Serviceazure_sql_database
: Database user name - Serviceazure_sql_managed_db_warehouse
: Database user name - Servicemaria_rds_warehouse
: Database user name - Servicemaria_warehouse
: Database user name - Servicemysql_rds_warehouse
: Database user name - Servicemysql_warehouse
: Database user name - Servicepanoply
: Database user name - Serviceperiscope_warehouse
: Database user name - Servicepostgres_gcp_warehouse
: Database user name - Servicepostgres_rds_warehouse
: Database user name - Servicepostgres_warehouse
: Database user name - Serviceredshift
: Database user name - Servicesnowflake
: Database user name - Servicesql_server_rds_warehouse
: Database user name - Servicesql_server_warehouse
: Database user name - workspace
Guid This property is required. string - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake workspace GUID - workspace
Name This property is required. string - Field usage depends on
service
value: - Serviceonelake
: OneLake workspace name
- always_
encrypted This property is required. bool - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: Require TLS through Tunnel - Servicesql_server_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - auth
This property is required. str - Field usage depends on
service
value: - Servicesnowflake
: Password-based or key-based authentication type - auth_
type This property is required. str - Field usage depends on
service
value: - Serviceadls
: Authentication type - Servicedatabricks
: Authentication type - Servicenew_s3_datalake
: Authentication type - Serviceonelake
: Authentication type - Serviceredshift
: Authentication type. Default value:PASSWORD
. - aws_
access_ key_ id This property is required. str - Field usage depends on
service
value: - Servicenew_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: - Servicenew_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: - Serviceconfluent_cloud_wh
: Comma-separated list of Confluent Cloud servers in theserver:port
format. - bucket
This property is required. str - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. - Servicenew_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: - Serviceadls
: Catalog name - Servicedatabricks
: Catalog name - Servicenew_s3_datalake
: Catalog name - Serviceonelake
: Catalog name - client_
id This property is required. str - Field usage depends on
service
value: - Serviceadls
: Client id of service principal - Serviceonelake
: Client ID of service principal - cloud_
provider This property is required. str - Field usage depends on
service
value: - Servicedatabricks
: Databricks deployment cloud - cluster_
id This property is required. str - Field usage depends on
service
value: - Servicepanoply
: Cluster ID. - Serviceperiscope_warehouse
: Cluster ID. - Serviceredshift
: Cluster ID. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - cluster_
region This property is required. str - Field usage depends on
service
value: - Servicepanoply
: Cluster region. - Serviceperiscope_warehouse
: Cluster region. - Serviceredshift
: Cluster region. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - connection_
method This property is required. str - connection_
type This property is required. str - Field usage depends on
service
value: - Serviceadls
: Connection method. Default value:Directly
. - Serviceaurora_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceaurora_warehouse
: Connection method. Default value:Directly
. - Serviceazure_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_data_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_database
: Connection method. Default value:Directly
. - Serviceazure_sql_managed_db_warehouse
: Connection method. Default value:Directly
. - Servicedatabricks
: Connection method. Default value:Directly
. - Servicemaria_rds_warehouse
: Connection method. Default value:Directly
. - Servicemaria_warehouse
: Connection method. Default value:Directly
. - Servicemysql_rds_warehouse
: Connection method. Default value:Directly
. - Servicemysql_warehouse
: Connection method. Default value:Directly
. - Servicepanoply
: Connection method. Default value:Directly
. - Serviceperiscope_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_gcp_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_rds_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_warehouse
: Connection method. Default value:Directly
. - Serviceredshift
: Connection method. Default value:Directly
. - Servicesnowflake
: Connection method. Default value:Directly
. - Servicesql_server_rds_warehouse
: Connection method. Default value:Directly
. - Servicesql_server_warehouse
: Connection method. Default value:Directly
. - container_
name This property is required. str - Field usage depends on
service
value: - Serviceadls
: (Immutable) Container to store delta table files - Serviceonelake
: 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: - Servicedatabricks
: Whether to create external tables - data_
format This property is required. str - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud message format. - data_
set_ location This property is required. str - Field usage depends on
service
value: - Servicebig_query
: Data location. Datasets will reside in this location. - Servicebig_query_dts
: Data location. Datasets will reside in this location. - Servicemanaged_big_query
: Data location. Datasets will reside in this location. - database
This property is required. str - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database name - Serviceaurora_warehouse
: Database name - Serviceazure_postgres_warehouse
: Database name - Serviceazure_sql_data_warehouse
: Database name - Serviceazure_sql_database
: Database name - Serviceazure_sql_managed_db_warehouse
: Database name - Servicemaria_rds_warehouse
: Database name - Servicemaria_warehouse
: Database name - Servicemysql_rds_warehouse
: Database name - Servicemysql_warehouse
: Database name - Servicepanoply
: Database name - Serviceperiscope_warehouse
: Database name - Servicepostgres_gcp_warehouse
: Database name - Servicepostgres_rds_warehouse
: Database name - Servicepostgres_warehouse
: Database name - Serviceredshift
: Database name - Servicesnowflake
: Database name - Servicesql_server_rds_warehouse
: Database name - Servicesql_server_warehouse
: Database name - databricks_
connection_ type This property is required. str - Field usage depends on
service
value: - Serviceadls
: Databricks Connection method. Default value:Directly
. - Servicenew_s3_datalake
: Databricks Connection method. Default value:Directly
. - Serviceonelake
: 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: - Serviceaws_msk_wh
: Fivetran generated External ID - Servicepanoply
: Fivetran generated External ID - Serviceperiscope_warehouse
: Fivetran generated External ID - Serviceredshift
: Fivetran generated External ID - external_
location This property is required. str - Field usage depends on
service
value: - Servicedatabricks
: 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: - Servicenew_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: - Serviceaurora_postgres_warehouse
: Server name - Serviceaurora_warehouse
: Server name - Serviceazure_postgres_warehouse
: Server name - Serviceazure_sql_data_warehouse
: Server name - Serviceazure_sql_database
: Server name - Serviceazure_sql_managed_db_warehouse
: Server name - Servicemaria_rds_warehouse
: Server name - Servicemaria_warehouse
: Server name - Servicemysql_rds_warehouse
: Server name - Servicemysql_warehouse
: Server name - Servicepanoply
: Server name - Serviceperiscope_warehouse
: Server name - Servicepostgres_gcp_warehouse
: Server name - Servicepostgres_rds_warehouse
: Server name - Servicepostgres_warehouse
: Server name - Serviceredshift
: Server name - Servicesnowflake
: Server name - Servicesql_server_rds_warehouse
: Server name - Servicesql_server_warehouse
: Server name - http_
path This property is required. str - Field usage depends on
service
value: - Serviceadls
: HTTP path - Servicedatabricks
: HTTP path - Servicenew_s3_datalake
: HTTP path - Serviceonelake
: HTTP path - is_
private_ key_ encrypted This property is required. bool - Field usage depends on
service
value: - Servicesnowflake
: Indicates that a private key is encrypted. The default value:false
. The field can be specified if authentication type isKEY_PAIR
. - is_
private_ link_ required This property is required. bool - Field usage depends on
service
value: - Servicenew_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: - Serviceredshift
: Is your destination Redshift Serverless - lakehouse_
guid This property is required. str - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake lakehouse GUID - lakehouse_
name This property is required. str - Field usage depends on
service
value: - Serviceonelake
: (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: - Serviceconfluent_cloud_wh
: Number of partitions per topic. - oauth2_
client_ id This property is required. str - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 client ID - Servicedatabricks
: OAuth 2.0 client ID - Servicenew_s3_datalake
: OAuth 2.0 client ID - Serviceonelake
: OAuth 2.0 client ID - oauth2_
secret This property is required. str - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 secret - Servicedatabricks
: OAuth 2.0 secret - Servicenew_s3_datalake
: OAuth 2.0 secret - Serviceonelake
: OAuth 2.0 secret - passphrase
This property is required. str - Field usage depends on
service
value: - Servicesnowflake
: 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 isKEY_PAIR
. - password
This property is required. str - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user password - Serviceaurora_warehouse
: Database user password - Serviceazure_postgres_warehouse
: Database user password - Serviceazure_sql_data_warehouse
: Database user password - Serviceazure_sql_database
: Database user password - Serviceazure_sql_managed_db_warehouse
: Database user password - Servicemaria_rds_warehouse
: Database user password - Servicemaria_warehouse
: Database user password - Servicemysql_rds_warehouse
: Database user password - Servicemysql_warehouse
: Database user password - Servicepanoply
: Database user password - Serviceperiscope_warehouse
: Database user password - Servicepostgres_gcp_warehouse
: Database user password - Servicepostgres_rds_warehouse
: Database user password - Servicepostgres_warehouse
: Database user password - Serviceredshift
: Database user password. Required if authentication type isPASSWORD
. - Servicesnowflake
: Database user password. The field should be specified if authentication type isPASSWORD
. - Servicesql_server_rds_warehouse
: Database user password - Servicesql_server_warehouse
: Database user password - personal_
access_ token This property is required. str - Field usage depends on
service
value: - Serviceadls
: Personal access token - Servicedatabricks
: Personal access token - Servicenew_s3_datalake
: Personal access token - Serviceonelake
: Personal access token - port
This property is required. float - Field usage depends on
service
value: - Serviceadls
: Server port number - Serviceaurora_postgres_warehouse
: Server port number - Serviceaurora_warehouse
: Server port number - Serviceazure_postgres_warehouse
: Server port number - Serviceazure_sql_data_warehouse
: Server port number - Serviceazure_sql_database
: Server port number - Serviceazure_sql_managed_db_warehouse
: Server port number - Servicedatabricks
: Server port number - Servicemaria_rds_warehouse
: Server port number - Servicemaria_warehouse
: Server port number - Servicemysql_rds_warehouse
: Server port number - Servicemysql_warehouse
: Server port number - Servicenew_s3_datalake
: Server port number - Serviceonelake
: Server port number - Servicepanoply
: Server port number - Serviceperiscope_warehouse
: Server port number - Servicepostgres_gcp_warehouse
: Server port number - Servicepostgres_rds_warehouse
: Server port number - Servicepostgres_warehouse
: Server port number - Serviceredshift
: Server port number - Servicesnowflake
: Server port number - Servicesql_server_rds_warehouse
: Server port number - Servicesql_server_warehouse
: Server port number - prefix_
path This property is required. str - Field usage depends on
service
value: - Serviceadls
: (Immutable) path/to/data within the container - Servicenew_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 - Serviceonelake
: (Immutable) path/to/data within your lakehouse inside the Files directory - private_
key This property is required. str - Field usage depends on
service
value: - Servicesnowflake
: Private access key. The field should be specified if authentication type isKEY_PAIR
. - project_
id This property is required. str - Field usage depends on
service
value: - Servicebig_query
: BigQuery project ID - public_
key This property is required. str - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Public Key - Serviceaurora_warehouse
: Public Key - Serviceazure_postgres_warehouse
: Public Key - Serviceazure_sql_data_warehouse
: Public Key - Serviceazure_sql_database
: Public Key - Serviceazure_sql_managed_db_warehouse
: Public Key - Servicemaria_rds_warehouse
: Public Key - Servicemaria_warehouse
: Public Key - Servicemysql_rds_warehouse
: Public Key - Servicemysql_warehouse
: Public Key - Servicepanoply
: Public Key - Serviceperiscope_warehouse
: Public Key - Servicepostgres_gcp_warehouse
: Public Key - Servicepostgres_rds_warehouse
: Public Key - Servicepostgres_warehouse
: Public Key - Serviceredshift
: Public Key - Servicesql_server_rds_warehouse
: Public Key - Servicesql_server_warehouse
: Public Key - region
This property is required. str - Field usage depends on
service
value: - Servicenew_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: - Serviceconfluent_cloud_wh
: Replication factor. - resource_
id This property is required. str - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceaurora_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_data_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_database
: Field to test Self serve Private Link - Serviceazure_sql_managed_db_warehouse
: Field to test Self serve Private Link - Servicedatabricks
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepanoply
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceperiscope_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_gcp_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceredshift
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesnowflake
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesql_server_rds_warehouse
: Field to test Self serve Private Link - Servicesql_server_warehouse
: Field to test Self serve Private Link - role
This property is required. str - Field usage depends on
service
value: - Servicesnowflake
: If not specified, Fivetran will use the user's default role - role_
arn This property is required. str - Field usage depends on
service
value: - Serviceredshift
: Role ARN with Redshift permissions. Required if authentication type isIAM
. - sasl_
mechanism This property is required. str - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - sasl_
plain_ key This property is required. str - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL key. - sasl_
plain_ secret This property is required. str - Field usage depends on
service
value: - Serviceconfluent_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: - Serviceconfluent_cloud_wh
: Schema Registry - schema_
registry_ api_ key This property is required. str - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API key. - schema_
registry_ api_ secret This property is required. str - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API secret. - schema_
registry_ url This property is required. str - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry URL. - secret_
key This property is required. str - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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: - Serviceadls
: Secret value for service principal - Serviceonelake
: Secret value for service principal - security_
protocol This property is required. str - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - server_
host_ name This property is required. str - Field usage depends on
service
value: - Serviceadls
: Server Host name - Servicedatabricks
: Server name - Servicenew_s3_datalake
: Server host name - Serviceonelake
: Server Host name - should_
maintain_ tables_ in_ databricks This property is required. bool - Field usage depends on
service
value: - Serviceadls
: Should maintain tables in Databricks - Servicenew_s3_datalake
: Should maintain tables in Databricks - Serviceonelake
: Should maintain tables in Databricks - snapshot_
retention_ period This property is required. str - Field usage depends on
service
value: - Serviceadls
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Servicenew_s3_datalake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Serviceonelake
: 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: - Serviceadls
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Serviceonelake
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - table_
format This property is required. str - Field usage depends on
service
value: - Servicenew_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: - Serviceadls
: Tenant id of service principal - Serviceonelake
: Tenant ID of service principal - tunnel_
host This property is required. str - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - tunnel_
port This property is required. float - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - tunnel_
user This property is required. str - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - user
This property is required. str - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user name - Serviceaurora_warehouse
: Database user name - Serviceazure_postgres_warehouse
: Database user name - Serviceazure_sql_data_warehouse
: Database user name - Serviceazure_sql_database
: Database user name - Serviceazure_sql_managed_db_warehouse
: Database user name - Servicemaria_rds_warehouse
: Database user name - Servicemaria_warehouse
: Database user name - Servicemysql_rds_warehouse
: Database user name - Servicemysql_warehouse
: Database user name - Servicepanoply
: Database user name - Serviceperiscope_warehouse
: Database user name - Servicepostgres_gcp_warehouse
: Database user name - Servicepostgres_rds_warehouse
: Database user name - Servicepostgres_warehouse
: Database user name - Serviceredshift
: Database user name - Servicesnowflake
: Database user name - Servicesql_server_rds_warehouse
: Database user name - Servicesql_server_warehouse
: Database user name - workspace_
guid This property is required. str - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake workspace GUID - workspace_
name This property is required. str - Field usage depends on
service
value: - Serviceonelake
: OneLake workspace name
- always
Encrypted This property is required. Boolean - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: Require TLS through Tunnel - Servicesql_server_rds_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: Specifies whether TLS is required. Must be populated ifconnection_type
is set toSshTunnel
. - auth
This property is required. String - Field usage depends on
service
value: - Servicesnowflake
: Password-based or key-based authentication type - auth
Type This property is required. String - Field usage depends on
service
value: - Serviceadls
: Authentication type - Servicedatabricks
: Authentication type - Servicenew_s3_datalake
: Authentication type - Serviceonelake
: Authentication type - Serviceredshift
: Authentication type. Default value:PASSWORD
. - aws
Access Key Id This property is required. String - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS access key to access the S3 bucket and AWS Glue - aws
Secret Access Key This property is required. String - Field usage depends on
service
value: - Servicenew_s3_datalake
: AWS secret access key to access the S3 bucket and AWS Glue - bootstrap
Servers This property is required. List<String> - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Comma-separated list of Confluent Cloud servers in theserver:port
format. - bucket
This property is required. String - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. - Servicenew_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: - Serviceadls
: Catalog name - Servicedatabricks
: Catalog name - Servicenew_s3_datalake
: Catalog name - Serviceonelake
: Catalog name - client
Id This property is required. String - Field usage depends on
service
value: - Serviceadls
: Client id of service principal - Serviceonelake
: Client ID of service principal - cloud
Provider This property is required. String - Field usage depends on
service
value: - Servicedatabricks
: Databricks deployment cloud - cluster
Id This property is required. String - Field usage depends on
service
value: - Servicepanoply
: Cluster ID. - Serviceperiscope_warehouse
: Cluster ID. - Serviceredshift
: Cluster ID. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - cluster
Region This property is required. String - Field usage depends on
service
value: - Servicepanoply
: Cluster region. - Serviceperiscope_warehouse
: Cluster region. - Serviceredshift
: Cluster region. Must be populated ifconnection_type
is set toSshTunnel
andauth_type
is set toIAM
. - connection
Method This property is required. String - connection
Type This property is required. String - Field usage depends on
service
value: - Serviceadls
: Connection method. Default value:Directly
. - Serviceaurora_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceaurora_warehouse
: Connection method. Default value:Directly
. - Serviceazure_postgres_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_data_warehouse
: Connection method. Default value:Directly
. - Serviceazure_sql_database
: Connection method. Default value:Directly
. - Serviceazure_sql_managed_db_warehouse
: Connection method. Default value:Directly
. - Servicedatabricks
: Connection method. Default value:Directly
. - Servicemaria_rds_warehouse
: Connection method. Default value:Directly
. - Servicemaria_warehouse
: Connection method. Default value:Directly
. - Servicemysql_rds_warehouse
: Connection method. Default value:Directly
. - Servicemysql_warehouse
: Connection method. Default value:Directly
. - Servicepanoply
: Connection method. Default value:Directly
. - Serviceperiscope_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_gcp_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_rds_warehouse
: Connection method. Default value:Directly
. - Servicepostgres_warehouse
: Connection method. Default value:Directly
. - Serviceredshift
: Connection method. Default value:Directly
. - Servicesnowflake
: Connection method. Default value:Directly
. - Servicesql_server_rds_warehouse
: Connection method. Default value:Directly
. - Servicesql_server_warehouse
: Connection method. Default value:Directly
. - container
Name This property is required. String - Field usage depends on
service
value: - Serviceadls
: (Immutable) Container to store delta table files - Serviceonelake
: Workspace name to store delta table files - controller
Id This property is required. String - create
External Tables This property is required. Boolean - Field usage depends on
service
value: - Servicedatabricks
: Whether to create external tables - data
Format This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud message format. - data
Set Location This property is required. String - Field usage depends on
service
value: - Servicebig_query
: Data location. Datasets will reside in this location. - Servicebig_query_dts
: Data location. Datasets will reside in this location. - Servicemanaged_big_query
: Data location. Datasets will reside in this location. - database
This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database name - Serviceaurora_warehouse
: Database name - Serviceazure_postgres_warehouse
: Database name - Serviceazure_sql_data_warehouse
: Database name - Serviceazure_sql_database
: Database name - Serviceazure_sql_managed_db_warehouse
: Database name - Servicemaria_rds_warehouse
: Database name - Servicemaria_warehouse
: Database name - Servicemysql_rds_warehouse
: Database name - Servicemysql_warehouse
: Database name - Servicepanoply
: Database name - Serviceperiscope_warehouse
: Database name - Servicepostgres_gcp_warehouse
: Database name - Servicepostgres_rds_warehouse
: Database name - Servicepostgres_warehouse
: Database name - Serviceredshift
: Database name - Servicesnowflake
: Database name - Servicesql_server_rds_warehouse
: Database name - Servicesql_server_warehouse
: Database name - databricks
Connection Type This property is required. String - Field usage depends on
service
value: - Serviceadls
: Databricks Connection method. Default value:Directly
. - Servicenew_s3_datalake
: Databricks Connection method. Default value:Directly
. - Serviceonelake
: Databricks Connection method. Default value:Directly
. - enable
Remote Execution This property is required. Boolean - external
Id This property is required. String - Field usage depends on
service
value: - Serviceaws_msk_wh
: Fivetran generated External ID - Servicepanoply
: Fivetran generated External ID - Serviceperiscope_warehouse
: Fivetran generated External ID - Serviceredshift
: Fivetran generated External ID - external
Location This property is required. String - Field usage depends on
service
value: - Servicedatabricks
: 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. String - fivetran
Msk Role Arn This property is required. String - fivetran
Role Arn This property is required. String - Field usage depends on
service
value: - Servicenew_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: - Serviceaurora_postgres_warehouse
: Server name - Serviceaurora_warehouse
: Server name - Serviceazure_postgres_warehouse
: Server name - Serviceazure_sql_data_warehouse
: Server name - Serviceazure_sql_database
: Server name - Serviceazure_sql_managed_db_warehouse
: Server name - Servicemaria_rds_warehouse
: Server name - Servicemaria_warehouse
: Server name - Servicemysql_rds_warehouse
: Server name - Servicemysql_warehouse
: Server name - Servicepanoply
: Server name - Serviceperiscope_warehouse
: Server name - Servicepostgres_gcp_warehouse
: Server name - Servicepostgres_rds_warehouse
: Server name - Servicepostgres_warehouse
: Server name - Serviceredshift
: Server name - Servicesnowflake
: Server name - Servicesql_server_rds_warehouse
: Server name - Servicesql_server_warehouse
: Server name - http
Path This property is required. String - Field usage depends on
service
value: - Serviceadls
: HTTP path - Servicedatabricks
: HTTP path - Servicenew_s3_datalake
: HTTP path - Serviceonelake
: HTTP path - is
Private Key Encrypted This property is required. Boolean - Field usage depends on
service
value: - Servicesnowflake
: Indicates that a private key is encrypted. The default value:false
. The field can be specified if authentication type isKEY_PAIR
. - is
Private Link Required This property is required. Boolean - Field usage depends on
service
value: - Servicenew_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. Boolean - Field usage depends on
service
value: - Serviceredshift
: Is your destination Redshift Serverless - lakehouse
Guid This property is required. String - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake lakehouse GUID - lakehouse
Name This property is required. String - Field usage depends on
service
value: - Serviceonelake
: (Immutable) Name of your lakehouse - msk
Sts Region This property is required. String - num
Of Partitions This property is required. Number - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Number of partitions per topic. - oauth2Client
Id This property is required. String - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 client ID - Servicedatabricks
: OAuth 2.0 client ID - Servicenew_s3_datalake
: OAuth 2.0 client ID - Serviceonelake
: OAuth 2.0 client ID - oauth2Secret
This property is required. String - Field usage depends on
service
value: - Serviceadls
: OAuth 2.0 secret - Servicedatabricks
: OAuth 2.0 secret - Servicenew_s3_datalake
: OAuth 2.0 secret - Serviceonelake
: OAuth 2.0 secret - passphrase
This property is required. String - Field usage depends on
service
value: - Servicesnowflake
: 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 isKEY_PAIR
. - password
This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user password - Serviceaurora_warehouse
: Database user password - Serviceazure_postgres_warehouse
: Database user password - Serviceazure_sql_data_warehouse
: Database user password - Serviceazure_sql_database
: Database user password - Serviceazure_sql_managed_db_warehouse
: Database user password - Servicemaria_rds_warehouse
: Database user password - Servicemaria_warehouse
: Database user password - Servicemysql_rds_warehouse
: Database user password - Servicemysql_warehouse
: Database user password - Servicepanoply
: Database user password - Serviceperiscope_warehouse
: Database user password - Servicepostgres_gcp_warehouse
: Database user password - Servicepostgres_rds_warehouse
: Database user password - Servicepostgres_warehouse
: Database user password - Serviceredshift
: Database user password. Required if authentication type isPASSWORD
. - Servicesnowflake
: Database user password. The field should be specified if authentication type isPASSWORD
. - Servicesql_server_rds_warehouse
: Database user password - Servicesql_server_warehouse
: Database user password - personal
Access Token This property is required. String - Field usage depends on
service
value: - Serviceadls
: Personal access token - Servicedatabricks
: Personal access token - Servicenew_s3_datalake
: Personal access token - Serviceonelake
: Personal access token - port
This property is required. Number - Field usage depends on
service
value: - Serviceadls
: Server port number - Serviceaurora_postgres_warehouse
: Server port number - Serviceaurora_warehouse
: Server port number - Serviceazure_postgres_warehouse
: Server port number - Serviceazure_sql_data_warehouse
: Server port number - Serviceazure_sql_database
: Server port number - Serviceazure_sql_managed_db_warehouse
: Server port number - Servicedatabricks
: Server port number - Servicemaria_rds_warehouse
: Server port number - Servicemaria_warehouse
: Server port number - Servicemysql_rds_warehouse
: Server port number - Servicemysql_warehouse
: Server port number - Servicenew_s3_datalake
: Server port number - Serviceonelake
: Server port number - Servicepanoply
: Server port number - Serviceperiscope_warehouse
: Server port number - Servicepostgres_gcp_warehouse
: Server port number - Servicepostgres_rds_warehouse
: Server port number - Servicepostgres_warehouse
: Server port number - Serviceredshift
: Server port number - Servicesnowflake
: Server port number - Servicesql_server_rds_warehouse
: Server port number - Servicesql_server_warehouse
: Server port number - prefix
Path This property is required. String - Field usage depends on
service
value: - Serviceadls
: (Immutable) path/to/data within the container - Servicenew_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 - Serviceonelake
: (Immutable) path/to/data within your lakehouse inside the Files directory - private
Key This property is required. String - Field usage depends on
service
value: - Servicesnowflake
: Private access key. The field should be specified if authentication type isKEY_PAIR
. - project
Id This property is required. String - Field usage depends on
service
value: - Servicebig_query
: BigQuery project ID - public
Key This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Public Key - Serviceaurora_warehouse
: Public Key - Serviceazure_postgres_warehouse
: Public Key - Serviceazure_sql_data_warehouse
: Public Key - Serviceazure_sql_database
: Public Key - Serviceazure_sql_managed_db_warehouse
: Public Key - Servicemaria_rds_warehouse
: Public Key - Servicemaria_warehouse
: Public Key - Servicemysql_rds_warehouse
: Public Key - Servicemysql_warehouse
: Public Key - Servicepanoply
: Public Key - Serviceperiscope_warehouse
: Public Key - Servicepostgres_gcp_warehouse
: Public Key - Servicepostgres_rds_warehouse
: Public Key - Servicepostgres_warehouse
: Public Key - Serviceredshift
: Public Key - Servicesql_server_rds_warehouse
: Public Key - Servicesql_server_warehouse
: Public Key - region
This property is required. String - Field usage depends on
service
value: - Servicenew_s3_datalake
: Region of your AWS S3 bucket - registry
Name This property is required. String - registry
Sts Region This property is required. String - replication
Factor This property is required. Number - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Replication factor. - resource
Id This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceaurora_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_postgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_data_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceazure_sql_database
: Field to test Self serve Private Link - Serviceazure_sql_managed_db_warehouse
: Field to test Self serve Private Link - Servicedatabricks
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemaria_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicemysql_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepanoply
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceperiscope_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_gcp_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_rds_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicepostgres_warehouse
: This field is currently being introduced to test the Self-serve Private Link functionality - Serviceredshift
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesnowflake
: This field is currently being introduced to test the Self-serve Private Link functionality - Servicesql_server_rds_warehouse
: Field to test Self serve Private Link - Servicesql_server_warehouse
: Field to test Self serve Private Link - role
This property is required. String - Field usage depends on
service
value: - Servicesnowflake
: If not specified, Fivetran will use the user's default role - role
Arn This property is required. String - Field usage depends on
service
value: - Serviceredshift
: Role ARN with Redshift permissions. Required if authentication type isIAM
. - sasl
Mechanism This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - sasl
Plain Key This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL key. - sasl
Plain Secret This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Confluent Cloud SASL secret. - schema
Compatibility This property is required. String - schema
Registry This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema Registry - schema
Registry Api Key This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API key. - schema
Registry Api Secret This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry API secret. - schema
Registry Url This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Schema registry URL. - secret
Key This property is required. String - Field usage depends on
service
value: - Servicebig_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. - Servicebig_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. - Servicemanaged_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. String - Field usage depends on
service
value: - Serviceadls
: Secret value for service principal - Serviceonelake
: Secret value for service principal - security
Protocol This property is required. String - Field usage depends on
service
value: - Serviceconfluent_cloud_wh
: Security protocol for Confluent Cloud interaction. - server
Host Name This property is required. String - Field usage depends on
service
value: - Serviceadls
: Server Host name - Servicedatabricks
: Server name - Servicenew_s3_datalake
: Server host name - Serviceonelake
: Server Host name - should
Maintain Tables In Databricks This property is required. Boolean - Field usage depends on
service
value: - Serviceadls
: Should maintain tables in Databricks - Servicenew_s3_datalake
: Should maintain tables in Databricks - Serviceonelake
: Should maintain tables in Databricks - snapshot
Retention Period This property is required. String - Field usage depends on
service
value: - Serviceadls
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Servicenew_s3_datalake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - Serviceonelake
: Snapshots older than the retention period are deleted every week. Default value:ONE_WEEK
. - snowflake
Cloud This property is required. String - snowflake
Region This property is required. String - storage
Account Name This property is required. String - Field usage depends on
service
value: - Serviceadls
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - Serviceonelake
: (Immutable) Storage account for Azure Data Lake Storage Gen2 name - table
Format This property is required. String - Field usage depends on
service
value: - Servicenew_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. String - Field usage depends on
service
value: - Serviceadls
: Tenant id of service principal - Serviceonelake
: Tenant ID of service principal - tunnel
Host This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server name. Must be populated ifconnection_type
is set toSshTunnel
. - tunnel
Port This property is required. Number - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH server port name. Must be populated ifconnection_type
is set toSshTunnel
. - tunnel
User This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceaurora_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_postgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_data_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_database
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceazure_sql_managed_db_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemaria_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicemysql_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepanoply
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceperiscope_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_gcp_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicepostgres_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Serviceredshift
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_rds_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - Servicesql_server_warehouse
: SSH user name. Must be populated ifconnection_type
is set toSshTunnel
. - user
This property is required. String - Field usage depends on
service
value: - Serviceaurora_postgres_warehouse
: Database user name - Serviceaurora_warehouse
: Database user name - Serviceazure_postgres_warehouse
: Database user name - Serviceazure_sql_data_warehouse
: Database user name - Serviceazure_sql_database
: Database user name - Serviceazure_sql_managed_db_warehouse
: Database user name - Servicemaria_rds_warehouse
: Database user name - Servicemaria_warehouse
: Database user name - Servicemysql_rds_warehouse
: Database user name - Servicemysql_warehouse
: Database user name - Servicepanoply
: Database user name - Serviceperiscope_warehouse
: Database user name - Servicepostgres_gcp_warehouse
: Database user name - Servicepostgres_rds_warehouse
: Database user name - Servicepostgres_warehouse
: Database user name - Serviceredshift
: Database user name - Servicesnowflake
: Database user name - Servicesql_server_rds_warehouse
: Database user name - Servicesql_server_warehouse
: Database user name - workspace
Guid This property is required. String - Field usage depends on
service
value: - Serviceonelake
: (Immutable) OneLake workspace GUID - workspace
Name This property is required. String - Field usage depends on
service
value: - Serviceonelake
: OneLake workspace name
Package Details
- Repository
- fivetran fivetran/terraform-provider-fivetran
- License
- Notes
- This Pulumi package is based on the
fivetran
Terraform Provider.