airbyte.DestinationSnowflake
Explore with Pulumi AI
DestinationSnowflake Resource
Example Usage
Coming soon!
Coming soon!
Coming soon!
Coming soon!
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.airbyte.DestinationSnowflake;
import com.pulumi.airbyte.DestinationSnowflakeArgs;
import com.pulumi.airbyte.inputs.DestinationSnowflakeConfigurationArgs;
import com.pulumi.airbyte.inputs.DestinationSnowflakeConfigurationCredentialsArgs;
import com.pulumi.airbyte.inputs.DestinationSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs;
import com.pulumi.airbyte.inputs.DestinationSnowflakeConfigurationCredentialsOAuth20Args;
import com.pulumi.airbyte.inputs.DestinationSnowflakeConfigurationCredentialsUsernameAndPasswordArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var myDestinationSnowflake = new DestinationSnowflake("myDestinationSnowflake", DestinationSnowflakeArgs.builder()
            .configuration(DestinationSnowflakeConfigurationArgs.builder()
                .credentials(DestinationSnowflakeConfigurationCredentialsArgs.builder()
                    .keyPairAuthentication(DestinationSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs.builder()
                        .privateKey("...my_private_key...")
                        .privateKeyPassword("...my_private_key_password...")
                        .build())
                    .oAuth20(DestinationSnowflakeConfigurationCredentialsOAuth20Args.builder()
                        .accessToken("...my_access_token...")
                        .clientId("...my_client_id...")
                        .clientSecret("...my_client_secret...")
                        .refreshToken("...my_refresh_token...")
                        .build())
                    .usernameAndPassword(DestinationSnowflakeConfigurationCredentialsUsernameAndPasswordArgs.builder()
                        .password("...my_password...")
                        .build())
                    .build())
                .database("AIRBYTE_DATABASE")
                .disable_type_dedupe(true)
                .host("accountname.us-east-2.aws.snowflakecomputing.com")
                .jdbc_url_params("...my_jdbc_url_params...")
                .raw_data_schema("...my_raw_data_schema...")
                .retention_period_days(9)
                .role("AIRBYTE_ROLE")
                .schema("AIRBYTE_SCHEMA")
                .use_merge_for_upsert(false)
                .username("AIRBYTE_USER")
                .warehouse("AIRBYTE_WAREHOUSE")
                .build())
            .definitionId("fce231ce-04a4-46ec-a244-d1436db0281f")
            .workspaceId("058d9730-38a6-485c-8631-dc0cc86125f9")
            .build());
    }
}
resources:
  myDestinationSnowflake:
    type: airbyte:DestinationSnowflake
    properties:
      configuration:
        credentials:
          keyPairAuthentication:
            privateKey: '...my_private_key...'
            privateKeyPassword: '...my_private_key_password...'
          oAuth20:
            accessToken: '...my_access_token...'
            clientId: '...my_client_id...'
            clientSecret: '...my_client_secret...'
            refreshToken: '...my_refresh_token...'
          usernameAndPassword:
            password: '...my_password...'
        database: AIRBYTE_DATABASE
        disable_type_dedupe: true
        host: accountname.us-east-2.aws.snowflakecomputing.com
        jdbc_url_params: '...my_jdbc_url_params...'
        raw_data_schema: '...my_raw_data_schema...'
        retention_period_days: 9
        role: AIRBYTE_ROLE
        schema: AIRBYTE_SCHEMA
        use_merge_for_upsert: false
        username: AIRBYTE_USER
        warehouse: AIRBYTE_WAREHOUSE
      definitionId: fce231ce-04a4-46ec-a244-d1436db0281f
      workspaceId: 058d9730-38a6-485c-8631-dc0cc86125f9
Create DestinationSnowflake Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new DestinationSnowflake(name: string, args: DestinationSnowflakeArgs, opts?: CustomResourceOptions);@overload
def DestinationSnowflake(resource_name: str,
                         args: DestinationSnowflakeArgs,
                         opts: Optional[ResourceOptions] = None)
@overload
def DestinationSnowflake(resource_name: str,
                         opts: Optional[ResourceOptions] = None,
                         configuration: Optional[DestinationSnowflakeConfigurationArgs] = None,
                         workspace_id: Optional[str] = None,
                         definition_id: Optional[str] = None,
                         name: Optional[str] = None)func NewDestinationSnowflake(ctx *Context, name string, args DestinationSnowflakeArgs, opts ...ResourceOption) (*DestinationSnowflake, error)public DestinationSnowflake(string name, DestinationSnowflakeArgs args, CustomResourceOptions? opts = null)
public DestinationSnowflake(String name, DestinationSnowflakeArgs args)
public DestinationSnowflake(String name, DestinationSnowflakeArgs args, CustomResourceOptions options)
type: airbyte:DestinationSnowflake
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args DestinationSnowflakeArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args DestinationSnowflakeArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args DestinationSnowflakeArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args DestinationSnowflakeArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args DestinationSnowflakeArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var destinationSnowflakeResource = new Airbyte.DestinationSnowflake("destinationSnowflakeResource", new()
{
    Configuration = new Airbyte.Inputs.DestinationSnowflakeConfigurationArgs
    {
        Database = "string",
        Host = "string",
        Role = "string",
        Schema = "string",
        Username = "string",
        Warehouse = "string",
        Credentials = new Airbyte.Inputs.DestinationSnowflakeConfigurationCredentialsArgs
        {
            KeyPairAuthentication = new Airbyte.Inputs.DestinationSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs
            {
                PrivateKey = "string",
                PrivateKeyPassword = "string",
            },
            OAuth20 = new Airbyte.Inputs.DestinationSnowflakeConfigurationCredentialsOAuth20Args
            {
                AccessToken = "string",
                RefreshToken = "string",
                ClientId = "string",
                ClientSecret = "string",
            },
            UsernameAndPassword = new Airbyte.Inputs.DestinationSnowflakeConfigurationCredentialsUsernameAndPasswordArgs
            {
                Password = "string",
            },
        },
        DisableTypeDedupe = false,
        JdbcUrlParams = "string",
        RawDataSchema = "string",
        RetentionPeriodDays = 0,
        UseMergeForUpsert = false,
    },
    WorkspaceId = "string",
    DefinitionId = "string",
    Name = "string",
});
example, err := airbyte.NewDestinationSnowflake(ctx, "destinationSnowflakeResource", &airbyte.DestinationSnowflakeArgs{
Configuration: &.DestinationSnowflakeConfigurationArgs{
Database: pulumi.String("string"),
Host: pulumi.String("string"),
Role: pulumi.String("string"),
Schema: pulumi.String("string"),
Username: pulumi.String("string"),
Warehouse: pulumi.String("string"),
Credentials: &.DestinationSnowflakeConfigurationCredentialsArgs{
KeyPairAuthentication: &.DestinationSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs{
PrivateKey: pulumi.String("string"),
PrivateKeyPassword: pulumi.String("string"),
},
OAuth20: &.DestinationSnowflakeConfigurationCredentialsOAuth20Args{
AccessToken: pulumi.String("string"),
RefreshToken: pulumi.String("string"),
ClientId: pulumi.String("string"),
ClientSecret: pulumi.String("string"),
},
UsernameAndPassword: &.DestinationSnowflakeConfigurationCredentialsUsernameAndPasswordArgs{
Password: pulumi.String("string"),
},
},
DisableTypeDedupe: pulumi.Bool(false),
JdbcUrlParams: pulumi.String("string"),
RawDataSchema: pulumi.String("string"),
RetentionPeriodDays: pulumi.Float64(0),
UseMergeForUpsert: pulumi.Bool(false),
},
WorkspaceId: pulumi.String("string"),
DefinitionId: pulumi.String("string"),
Name: pulumi.String("string"),
})
var destinationSnowflakeResource = new DestinationSnowflake("destinationSnowflakeResource", DestinationSnowflakeArgs.builder()
    .configuration(DestinationSnowflakeConfigurationArgs.builder()
        .database("string")
        .host("string")
        .role("string")
        .schema("string")
        .username("string")
        .warehouse("string")
        .credentials(DestinationSnowflakeConfigurationCredentialsArgs.builder()
            .keyPairAuthentication(DestinationSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs.builder()
                .privateKey("string")
                .privateKeyPassword("string")
                .build())
            .oAuth20(DestinationSnowflakeConfigurationCredentialsOAuth20Args.builder()
                .accessToken("string")
                .refreshToken("string")
                .clientId("string")
                .clientSecret("string")
                .build())
            .usernameAndPassword(DestinationSnowflakeConfigurationCredentialsUsernameAndPasswordArgs.builder()
                .password("string")
                .build())
            .build())
        .disableTypeDedupe(false)
        .jdbcUrlParams("string")
        .rawDataSchema("string")
        .retentionPeriodDays(0)
        .useMergeForUpsert(false)
        .build())
    .workspaceId("string")
    .definitionId("string")
    .name("string")
    .build());
destination_snowflake_resource = airbyte.DestinationSnowflake("destinationSnowflakeResource",
    configuration={
        "database": "string",
        "host": "string",
        "role": "string",
        "schema": "string",
        "username": "string",
        "warehouse": "string",
        "credentials": {
            "key_pair_authentication": {
                "private_key": "string",
                "private_key_password": "string",
            },
            "o_auth20": {
                "access_token": "string",
                "refresh_token": "string",
                "client_id": "string",
                "client_secret": "string",
            },
            "username_and_password": {
                "password": "string",
            },
        },
        "disable_type_dedupe": False,
        "jdbc_url_params": "string",
        "raw_data_schema": "string",
        "retention_period_days": 0,
        "use_merge_for_upsert": False,
    },
    workspace_id="string",
    definition_id="string",
    name="string")
const destinationSnowflakeResource = new airbyte.DestinationSnowflake("destinationSnowflakeResource", {
    configuration: {
        database: "string",
        host: "string",
        role: "string",
        schema: "string",
        username: "string",
        warehouse: "string",
        credentials: {
            keyPairAuthentication: {
                privateKey: "string",
                privateKeyPassword: "string",
            },
            oAuth20: {
                accessToken: "string",
                refreshToken: "string",
                clientId: "string",
                clientSecret: "string",
            },
            usernameAndPassword: {
                password: "string",
            },
        },
        disableTypeDedupe: false,
        jdbcUrlParams: "string",
        rawDataSchema: "string",
        retentionPeriodDays: 0,
        useMergeForUpsert: false,
    },
    workspaceId: "string",
    definitionId: "string",
    name: "string",
});
type: airbyte:DestinationSnowflake
properties:
    configuration:
        credentials:
            keyPairAuthentication:
                privateKey: string
                privateKeyPassword: string
            oAuth20:
                accessToken: string
                clientId: string
                clientSecret: string
                refreshToken: string
            usernameAndPassword:
                password: string
        database: string
        disableTypeDedupe: false
        host: string
        jdbcUrlParams: string
        rawDataSchema: string
        retentionPeriodDays: 0
        role: string
        schema: string
        useMergeForUpsert: false
        username: string
        warehouse: string
    definitionId: string
    name: string
    workspaceId: string
DestinationSnowflake Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The DestinationSnowflake resource accepts the following input properties:
- Configuration
DestinationSnowflake Configuration 
- WorkspaceId string
- DefinitionId string
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- Name string
- Name of the destination e.g. dev-mysql-instance.
- Configuration
DestinationSnowflake Configuration Args 
- WorkspaceId string
- DefinitionId string
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- Name string
- Name of the destination e.g. dev-mysql-instance.
- configuration
DestinationSnowflake Configuration 
- workspaceId String
- definitionId String
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- name String
- Name of the destination e.g. dev-mysql-instance.
- configuration
DestinationSnowflake Configuration 
- workspaceId string
- definitionId string
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- name string
- Name of the destination e.g. dev-mysql-instance.
- configuration
DestinationSnowflake Configuration Args 
- workspace_id str
- definition_id str
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- name str
- Name of the destination e.g. dev-mysql-instance.
- configuration Property Map
- workspaceId String
- definitionId String
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- name String
- Name of the destination e.g. dev-mysql-instance.
Outputs
All input properties are implicitly available as output properties. Additionally, the DestinationSnowflake resource produces the following output properties:
- CreatedAt double
- DestinationId string
- DestinationType string
- Id string
- The provider-assigned unique ID for this managed resource.
- CreatedAt float64
- DestinationId string
- DestinationType string
- Id string
- The provider-assigned unique ID for this managed resource.
- createdAt Double
- destinationId String
- destinationType String
- id String
- The provider-assigned unique ID for this managed resource.
- createdAt number
- destinationId string
- destinationType string
- id string
- The provider-assigned unique ID for this managed resource.
- created_at float
- destination_id str
- destination_type str
- id str
- The provider-assigned unique ID for this managed resource.
- createdAt Number
- destinationId String
- destinationType String
- id String
- The provider-assigned unique ID for this managed resource.
Look up Existing DestinationSnowflake Resource
Get an existing DestinationSnowflake resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: DestinationSnowflakeState, opts?: CustomResourceOptions): DestinationSnowflake@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        configuration: Optional[DestinationSnowflakeConfigurationArgs] = None,
        created_at: Optional[float] = None,
        definition_id: Optional[str] = None,
        destination_id: Optional[str] = None,
        destination_type: Optional[str] = None,
        name: Optional[str] = None,
        workspace_id: Optional[str] = None) -> DestinationSnowflakefunc GetDestinationSnowflake(ctx *Context, name string, id IDInput, state *DestinationSnowflakeState, opts ...ResourceOption) (*DestinationSnowflake, error)public static DestinationSnowflake Get(string name, Input<string> id, DestinationSnowflakeState? state, CustomResourceOptions? opts = null)public static DestinationSnowflake get(String name, Output<String> id, DestinationSnowflakeState state, CustomResourceOptions options)resources:  _:    type: airbyte:DestinationSnowflake    get:      id: ${id}- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Configuration
DestinationSnowflake Configuration 
- CreatedAt double
- DefinitionId string
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- DestinationId string
- DestinationType string
- Name string
- Name of the destination e.g. dev-mysql-instance.
- WorkspaceId string
- Configuration
DestinationSnowflake Configuration Args 
- CreatedAt float64
- DefinitionId string
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- DestinationId string
- DestinationType string
- Name string
- Name of the destination e.g. dev-mysql-instance.
- WorkspaceId string
- configuration
DestinationSnowflake Configuration 
- createdAt Double
- definitionId String
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- destinationId String
- destinationType String
- name String
- Name of the destination e.g. dev-mysql-instance.
- workspaceId String
- configuration
DestinationSnowflake Configuration 
- createdAt number
- definitionId string
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- destinationId string
- destinationType string
- name string
- Name of the destination e.g. dev-mysql-instance.
- workspaceId string
- configuration
DestinationSnowflake Configuration Args 
- created_at float
- definition_id str
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- destination_id str
- destination_type str
- name str
- Name of the destination e.g. dev-mysql-instance.
- workspace_id str
- configuration Property Map
- createdAt Number
- definitionId String
- The UUID of the connector definition. One of configuration.destinationType or definitionId must be provided. Requires replacement if changed.
- destinationId String
- destinationType String
- name String
- Name of the destination e.g. dev-mysql-instance.
- workspaceId String
Supporting Types
DestinationSnowflakeConfiguration, DestinationSnowflakeConfigurationArgs      
- Database string
- Enter the name of the \n\ndatabase\n\n you want to sync data into
- Host string
- Enter your Snowflake account's \n\nlocator\n\n (in the format \n\n.\n\n.\n\n.snowflakecomputing.com)
- Role string
- Enter the \n\nrole\n\n that you want to use to access Snowflake
- Schema string
- Enter the name of the default \n\nschema\n\n
- Username string
- Enter the name of the user you want to use to access the database
- Warehouse string
- Enter the name of the \n\nwarehouse\n\n that you want to use as a compute cluster
- Credentials
DestinationSnowflake Configuration Credentials 
- DisableType boolDedupe 
- Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions. Default: false
- JdbcUrl stringParams 
- Enter the additional properties to pass to the JDBC URL string when connecting to the database (formatted as key=value pairs separated by the symbol &). Example: key1=value1&key2=value2&key3=value3
- RawData stringSchema 
- The schema to write raw tables into (default: airbyte_internal)
- RetentionPeriod doubleDays 
- The number of days of Snowflake Time Travel to enable on the tables. See \n\nSnowflake's documentation\n\n for more information. Setting a nonzero value will incur increased storage costs in your Snowflake instance. Default: 1
- UseMerge boolFor Upsert 
- Use MERGE for de-duplication of final tables. This option no effect if Final tables are disabled or Sync mode is not DEDUPE. Default: false
- Database string
- Enter the name of the \n\ndatabase\n\n you want to sync data into
- Host string
- Enter your Snowflake account's \n\nlocator\n\n (in the format \n\n.\n\n.\n\n.snowflakecomputing.com)
- Role string
- Enter the \n\nrole\n\n that you want to use to access Snowflake
- Schema string
- Enter the name of the default \n\nschema\n\n
- Username string
- Enter the name of the user you want to use to access the database
- Warehouse string
- Enter the name of the \n\nwarehouse\n\n that you want to use as a compute cluster
- Credentials
DestinationSnowflake Configuration Credentials 
- DisableType boolDedupe 
- Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions. Default: false
- JdbcUrl stringParams 
- Enter the additional properties to pass to the JDBC URL string when connecting to the database (formatted as key=value pairs separated by the symbol &). Example: key1=value1&key2=value2&key3=value3
- RawData stringSchema 
- The schema to write raw tables into (default: airbyte_internal)
- RetentionPeriod float64Days 
- The number of days of Snowflake Time Travel to enable on the tables. See \n\nSnowflake's documentation\n\n for more information. Setting a nonzero value will incur increased storage costs in your Snowflake instance. Default: 1
- UseMerge boolFor Upsert 
- Use MERGE for de-duplication of final tables. This option no effect if Final tables are disabled or Sync mode is not DEDUPE. Default: false
- database String
- Enter the name of the \n\ndatabase\n\n you want to sync data into
- host String
- Enter your Snowflake account's \n\nlocator\n\n (in the format \n\n.\n\n.\n\n.snowflakecomputing.com)
- role String
- Enter the \n\nrole\n\n that you want to use to access Snowflake
- schema String
- Enter the name of the default \n\nschema\n\n
- username String
- Enter the name of the user you want to use to access the database
- warehouse String
- Enter the name of the \n\nwarehouse\n\n that you want to use as a compute cluster
- credentials
DestinationSnowflake Configuration Credentials 
- disableType BooleanDedupe 
- Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions. Default: false
- jdbcUrl StringParams 
- Enter the additional properties to pass to the JDBC URL string when connecting to the database (formatted as key=value pairs separated by the symbol &). Example: key1=value1&key2=value2&key3=value3
- rawData StringSchema 
- The schema to write raw tables into (default: airbyte_internal)
- retentionPeriod DoubleDays 
- The number of days of Snowflake Time Travel to enable on the tables. See \n\nSnowflake's documentation\n\n for more information. Setting a nonzero value will incur increased storage costs in your Snowflake instance. Default: 1
- useMerge BooleanFor Upsert 
- Use MERGE for de-duplication of final tables. This option no effect if Final tables are disabled or Sync mode is not DEDUPE. Default: false
- database string
- Enter the name of the \n\ndatabase\n\n you want to sync data into
- host string
- Enter your Snowflake account's \n\nlocator\n\n (in the format \n\n.\n\n.\n\n.snowflakecomputing.com)
- role string
- Enter the \n\nrole\n\n that you want to use to access Snowflake
- schema string
- Enter the name of the default \n\nschema\n\n
- username string
- Enter the name of the user you want to use to access the database
- warehouse string
- Enter the name of the \n\nwarehouse\n\n that you want to use as a compute cluster
- credentials
DestinationSnowflake Configuration Credentials 
- disableType booleanDedupe 
- Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions. Default: false
- jdbcUrl stringParams 
- Enter the additional properties to pass to the JDBC URL string when connecting to the database (formatted as key=value pairs separated by the symbol &). Example: key1=value1&key2=value2&key3=value3
- rawData stringSchema 
- The schema to write raw tables into (default: airbyte_internal)
- retentionPeriod numberDays 
- The number of days of Snowflake Time Travel to enable on the tables. See \n\nSnowflake's documentation\n\n for more information. Setting a nonzero value will incur increased storage costs in your Snowflake instance. Default: 1
- useMerge booleanFor Upsert 
- Use MERGE for de-duplication of final tables. This option no effect if Final tables are disabled or Sync mode is not DEDUPE. Default: false
- database str
- Enter the name of the \n\ndatabase\n\n you want to sync data into
- host str
- Enter your Snowflake account's \n\nlocator\n\n (in the format \n\n.\n\n.\n\n.snowflakecomputing.com)
- role str
- Enter the \n\nrole\n\n that you want to use to access Snowflake
- schema str
- Enter the name of the default \n\nschema\n\n
- username str
- Enter the name of the user you want to use to access the database
- warehouse str
- Enter the name of the \n\nwarehouse\n\n that you want to use as a compute cluster
- credentials
DestinationSnowflake Configuration Credentials 
- disable_type_ booldedupe 
- Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions. Default: false
- jdbc_url_ strparams 
- Enter the additional properties to pass to the JDBC URL string when connecting to the database (formatted as key=value pairs separated by the symbol &). Example: key1=value1&key2=value2&key3=value3
- raw_data_ strschema 
- The schema to write raw tables into (default: airbyte_internal)
- retention_period_ floatdays 
- The number of days of Snowflake Time Travel to enable on the tables. See \n\nSnowflake's documentation\n\n for more information. Setting a nonzero value will incur increased storage costs in your Snowflake instance. Default: 1
- use_merge_ boolfor_ upsert 
- Use MERGE for de-duplication of final tables. This option no effect if Final tables are disabled or Sync mode is not DEDUPE. Default: false
- database String
- Enter the name of the \n\ndatabase\n\n you want to sync data into
- host String
- Enter your Snowflake account's \n\nlocator\n\n (in the format \n\n.\n\n.\n\n.snowflakecomputing.com)
- role String
- Enter the \n\nrole\n\n that you want to use to access Snowflake
- schema String
- Enter the name of the default \n\nschema\n\n
- username String
- Enter the name of the user you want to use to access the database
- warehouse String
- Enter the name of the \n\nwarehouse\n\n that you want to use as a compute cluster
- credentials Property Map
- disableType BooleanDedupe 
- Disable Writing Final Tables. WARNING! The data format in airbytedata is likely stable but there are no guarantees that other metadata columns will remain the same in future versions. Default: false
- jdbcUrl StringParams 
- Enter the additional properties to pass to the JDBC URL string when connecting to the database (formatted as key=value pairs separated by the symbol &). Example: key1=value1&key2=value2&key3=value3
- rawData StringSchema 
- The schema to write raw tables into (default: airbyte_internal)
- retentionPeriod NumberDays 
- The number of days of Snowflake Time Travel to enable on the tables. See \n\nSnowflake's documentation\n\n for more information. Setting a nonzero value will incur increased storage costs in your Snowflake instance. Default: 1
- useMerge BooleanFor Upsert 
- Use MERGE for de-duplication of final tables. This option no effect if Final tables are disabled or Sync mode is not DEDUPE. Default: false
DestinationSnowflakeConfigurationCredentials, DestinationSnowflakeConfigurationCredentialsArgs        
DestinationSnowflakeConfigurationCredentialsKeyPairAuthentication, DestinationSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs              
- PrivateKey string
- RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
- PrivateKey stringPassword 
- Passphrase for private key
- PrivateKey string
- RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
- PrivateKey stringPassword 
- Passphrase for private key
- privateKey String
- RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
- privateKey StringPassword 
- Passphrase for private key
- privateKey string
- RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
- privateKey stringPassword 
- Passphrase for private key
- private_key str
- RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
- private_key_ strpassword 
- Passphrase for private key
- privateKey String
- RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
- privateKey StringPassword 
- Passphrase for private key
DestinationSnowflakeConfigurationCredentialsOAuth20, DestinationSnowflakeConfigurationCredentialsOAuth20Args          
- AccessToken string
- Enter you application's Access Token
- RefreshToken string
- Enter your application's Refresh Token
- ClientId string
- Enter your application's Client ID
- ClientSecret string
- Enter your application's Client secret
- AccessToken string
- Enter you application's Access Token
- RefreshToken string
- Enter your application's Refresh Token
- ClientId string
- Enter your application's Client ID
- ClientSecret string
- Enter your application's Client secret
- accessToken String
- Enter you application's Access Token
- refreshToken String
- Enter your application's Refresh Token
- clientId String
- Enter your application's Client ID
- clientSecret String
- Enter your application's Client secret
- accessToken string
- Enter you application's Access Token
- refreshToken string
- Enter your application's Refresh Token
- clientId string
- Enter your application's Client ID
- clientSecret string
- Enter your application's Client secret
- access_token str
- Enter you application's Access Token
- refresh_token str
- Enter your application's Refresh Token
- client_id str
- Enter your application's Client ID
- client_secret str
- Enter your application's Client secret
- accessToken String
- Enter you application's Access Token
- refreshToken String
- Enter your application's Refresh Token
- clientId String
- Enter your application's Client ID
- clientSecret String
- Enter your application's Client secret
DestinationSnowflakeConfigurationCredentialsUsernameAndPassword, DestinationSnowflakeConfigurationCredentialsUsernameAndPasswordArgs              
- Password string
- Enter the password associated with the username.
- Password string
- Enter the password associated with the username.
- password String
- Enter the password associated with the username.
- password string
- Enter the password associated with the username.
- password str
- Enter the password associated with the username.
- password String
- Enter the password associated with the username.
Import
$ pulumi import airbyte:index/destinationSnowflake:DestinationSnowflake my_airbyte_destination_snowflake ""
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- airbyte airbytehq/terraform-provider-airbyte
- License
- Notes
- This Pulumi package is based on the airbyteTerraform Provider.