1. Packages
  2. Airbyte Provider
  3. API Docs
  4. SourceSnowflake
airbyte 0.8.0-beta2 published on Thursday, Mar 27, 2025 by airbytehq

airbyte.SourceSnowflake

Explore with Pulumi AI

SourceSnowflake 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.SourceSnowflake;
import com.pulumi.airbyte.SourceSnowflakeArgs;
import com.pulumi.airbyte.inputs.SourceSnowflakeConfigurationArgs;
import com.pulumi.airbyte.inputs.SourceSnowflakeConfigurationCredentialsArgs;
import com.pulumi.airbyte.inputs.SourceSnowflakeConfigurationCredentialsUsernameAndPasswordArgs;
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 mySourceSnowflake = new SourceSnowflake("mySourceSnowflake", SourceSnowflakeArgs.builder()
            .configuration(SourceSnowflakeConfigurationArgs.builder()
                .credentials(SourceSnowflakeConfigurationCredentialsArgs.builder()
                    .usernameAndPassword(SourceSnowflakeConfigurationCredentialsUsernameAndPasswordArgs.builder()
                        .password("...my_password...")
                        .username("AIRBYTE_USER")
                        .build())
                    .build())
                .database("AIRBYTE_DATABASE")
                .host("accountname.us-east-2.aws.snowflakecomputing.com")
                .jdbc_url_params("...my_jdbc_url_params...")
                .role("AIRBYTE_ROLE")
                .schema("AIRBYTE_SCHEMA")
                .warehouse("AIRBYTE_WAREHOUSE")
                .build())
            .definitionId("27125485-2542-4c33-816b-4945c1b73270")
            .secretId("...my_secret_id...")
            .workspaceId("f456591a-a491-49d7-af41-2d440d1ae6ee")
            .build());

    }
}
Copy
resources:
  mySourceSnowflake:
    type: airbyte:SourceSnowflake
    properties:
      configuration:
        credentials:
          usernameAndPassword:
            password: '...my_password...'
            username: AIRBYTE_USER
        database: AIRBYTE_DATABASE
        host: accountname.us-east-2.aws.snowflakecomputing.com
        jdbc_url_params: '...my_jdbc_url_params...'
        role: AIRBYTE_ROLE
        schema: AIRBYTE_SCHEMA
        warehouse: AIRBYTE_WAREHOUSE
      definitionId: 27125485-2542-4c33-816b-4945c1b73270
      secretId: '...my_secret_id...'
      workspaceId: f456591a-a491-49d7-af41-2d440d1ae6ee
Copy

Create SourceSnowflake Resource

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

Constructor syntax

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

@overload
def SourceSnowflake(resource_name: str,
                    opts: Optional[ResourceOptions] = None,
                    configuration: Optional[SourceSnowflakeConfigurationArgs] = None,
                    workspace_id: Optional[str] = None,
                    definition_id: Optional[str] = None,
                    name: Optional[str] = None,
                    secret_id: Optional[str] = None)
func NewSourceSnowflake(ctx *Context, name string, args SourceSnowflakeArgs, opts ...ResourceOption) (*SourceSnowflake, error)
public SourceSnowflake(string name, SourceSnowflakeArgs args, CustomResourceOptions? opts = null)
public SourceSnowflake(String name, SourceSnowflakeArgs args)
public SourceSnowflake(String name, SourceSnowflakeArgs args, CustomResourceOptions options)
type: airbyte:SourceSnowflake
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name This property is required. string
The unique name of the resource.
args This property is required. SourceSnowflakeArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args This property is required. SourceSnowflakeArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name This property is required. string
The unique name of the resource.
args This property is required. SourceSnowflakeArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args This property is required. SourceSnowflakeArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. SourceSnowflakeArgs
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 sourceSnowflakeResource = new Airbyte.SourceSnowflake("sourceSnowflakeResource", new()
{
    Configuration = new Airbyte.Inputs.SourceSnowflakeConfigurationArgs
    {
        Database = "string",
        Host = "string",
        Role = "string",
        Warehouse = "string",
        Credentials = new Airbyte.Inputs.SourceSnowflakeConfigurationCredentialsArgs
        {
            KeyPairAuthentication = new Airbyte.Inputs.SourceSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs
            {
                PrivateKey = "string",
                Username = "string",
                PrivateKeyPassword = "string",
            },
            OAuth20 = new Airbyte.Inputs.SourceSnowflakeConfigurationCredentialsOAuth20Args
            {
                ClientId = "string",
                ClientSecret = "string",
                AccessToken = "string",
                RefreshToken = "string",
            },
            UsernameAndPassword = new Airbyte.Inputs.SourceSnowflakeConfigurationCredentialsUsernameAndPasswordArgs
            {
                Password = "string",
                Username = "string",
            },
        },
        JdbcUrlParams = "string",
        Schema = "string",
    },
    WorkspaceId = "string",
    DefinitionId = "string",
    Name = "string",
    SecretId = "string",
});
Copy
example, err := airbyte.NewSourceSnowflake(ctx, "sourceSnowflakeResource", &airbyte.SourceSnowflakeArgs{
Configuration: &.SourceSnowflakeConfigurationArgs{
Database: pulumi.String("string"),
Host: pulumi.String("string"),
Role: pulumi.String("string"),
Warehouse: pulumi.String("string"),
Credentials: &.SourceSnowflakeConfigurationCredentialsArgs{
KeyPairAuthentication: &.SourceSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs{
PrivateKey: pulumi.String("string"),
Username: pulumi.String("string"),
PrivateKeyPassword: pulumi.String("string"),
},
OAuth20: &.SourceSnowflakeConfigurationCredentialsOAuth20Args{
ClientId: pulumi.String("string"),
ClientSecret: pulumi.String("string"),
AccessToken: pulumi.String("string"),
RefreshToken: pulumi.String("string"),
},
UsernameAndPassword: &.SourceSnowflakeConfigurationCredentialsUsernameAndPasswordArgs{
Password: pulumi.String("string"),
Username: pulumi.String("string"),
},
},
JdbcUrlParams: pulumi.String("string"),
Schema: pulumi.String("string"),
},
WorkspaceId: pulumi.String("string"),
DefinitionId: pulumi.String("string"),
Name: pulumi.String("string"),
SecretId: pulumi.String("string"),
})
Copy
var sourceSnowflakeResource = new SourceSnowflake("sourceSnowflakeResource", SourceSnowflakeArgs.builder()
    .configuration(SourceSnowflakeConfigurationArgs.builder()
        .database("string")
        .host("string")
        .role("string")
        .warehouse("string")
        .credentials(SourceSnowflakeConfigurationCredentialsArgs.builder()
            .keyPairAuthentication(SourceSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs.builder()
                .privateKey("string")
                .username("string")
                .privateKeyPassword("string")
                .build())
            .oAuth20(SourceSnowflakeConfigurationCredentialsOAuth20Args.builder()
                .clientId("string")
                .clientSecret("string")
                .accessToken("string")
                .refreshToken("string")
                .build())
            .usernameAndPassword(SourceSnowflakeConfigurationCredentialsUsernameAndPasswordArgs.builder()
                .password("string")
                .username("string")
                .build())
            .build())
        .jdbcUrlParams("string")
        .schema("string")
        .build())
    .workspaceId("string")
    .definitionId("string")
    .name("string")
    .secretId("string")
    .build());
Copy
source_snowflake_resource = airbyte.SourceSnowflake("sourceSnowflakeResource",
    configuration={
        "database": "string",
        "host": "string",
        "role": "string",
        "warehouse": "string",
        "credentials": {
            "key_pair_authentication": {
                "private_key": "string",
                "username": "string",
                "private_key_password": "string",
            },
            "o_auth20": {
                "client_id": "string",
                "client_secret": "string",
                "access_token": "string",
                "refresh_token": "string",
            },
            "username_and_password": {
                "password": "string",
                "username": "string",
            },
        },
        "jdbc_url_params": "string",
        "schema": "string",
    },
    workspace_id="string",
    definition_id="string",
    name="string",
    secret_id="string")
Copy
const sourceSnowflakeResource = new airbyte.SourceSnowflake("sourceSnowflakeResource", {
    configuration: {
        database: "string",
        host: "string",
        role: "string",
        warehouse: "string",
        credentials: {
            keyPairAuthentication: {
                privateKey: "string",
                username: "string",
                privateKeyPassword: "string",
            },
            oAuth20: {
                clientId: "string",
                clientSecret: "string",
                accessToken: "string",
                refreshToken: "string",
            },
            usernameAndPassword: {
                password: "string",
                username: "string",
            },
        },
        jdbcUrlParams: "string",
        schema: "string",
    },
    workspaceId: "string",
    definitionId: "string",
    name: "string",
    secretId: "string",
});
Copy
type: airbyte:SourceSnowflake
properties:
    configuration:
        credentials:
            keyPairAuthentication:
                privateKey: string
                privateKeyPassword: string
                username: string
            oAuth20:
                accessToken: string
                clientId: string
                clientSecret: string
                refreshToken: string
            usernameAndPassword:
                password: string
                username: string
        database: string
        host: string
        jdbcUrlParams: string
        role: string
        schema: string
        warehouse: string
    definitionId: string
    name: string
    secretId: string
    workspaceId: string
Copy

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

Configuration This property is required. SourceSnowflakeConfiguration
WorkspaceId This property is required. string
DefinitionId string
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
Name string
Name of the source e.g. dev-mysql-instance.
SecretId string
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
Configuration This property is required. SourceSnowflakeConfigurationArgs
WorkspaceId This property is required. string
DefinitionId string
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
Name string
Name of the source e.g. dev-mysql-instance.
SecretId string
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
configuration This property is required. SourceSnowflakeConfiguration
workspaceId This property is required. String
definitionId String
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
name String
Name of the source e.g. dev-mysql-instance.
secretId String
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
configuration This property is required. SourceSnowflakeConfiguration
workspaceId This property is required. string
definitionId string
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
name string
Name of the source e.g. dev-mysql-instance.
secretId string
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
configuration This property is required. SourceSnowflakeConfigurationArgs
workspace_id This property is required. str
definition_id str
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
name str
Name of the source e.g. dev-mysql-instance.
secret_id str
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
configuration This property is required. Property Map
workspaceId This property is required. String
definitionId String
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
name String
Name of the source e.g. dev-mysql-instance.
secretId String
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.

Outputs

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

CreatedAt double
Id string
The provider-assigned unique ID for this managed resource.
ResourceAllocation SourceSnowflakeResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
SourceId string
SourceType string
CreatedAt float64
Id string
The provider-assigned unique ID for this managed resource.
ResourceAllocation SourceSnowflakeResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
SourceId string
SourceType string
createdAt Double
id String
The provider-assigned unique ID for this managed resource.
resourceAllocation SourceSnowflakeResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
sourceId String
sourceType String
createdAt number
id string
The provider-assigned unique ID for this managed resource.
resourceAllocation SourceSnowflakeResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
sourceId string
sourceType string
created_at float
id str
The provider-assigned unique ID for this managed resource.
resource_allocation SourceSnowflakeResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
source_id str
source_type str
createdAt Number
id String
The provider-assigned unique ID for this managed resource.
resourceAllocation Property Map
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
sourceId String
sourceType String

Look up Existing SourceSnowflake Resource

Get an existing SourceSnowflake 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?: SourceSnowflakeState, opts?: CustomResourceOptions): SourceSnowflake
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        configuration: Optional[SourceSnowflakeConfigurationArgs] = None,
        created_at: Optional[float] = None,
        definition_id: Optional[str] = None,
        name: Optional[str] = None,
        resource_allocation: Optional[SourceSnowflakeResourceAllocationArgs] = None,
        secret_id: Optional[str] = None,
        source_id: Optional[str] = None,
        source_type: Optional[str] = None,
        workspace_id: Optional[str] = None) -> SourceSnowflake
func GetSourceSnowflake(ctx *Context, name string, id IDInput, state *SourceSnowflakeState, opts ...ResourceOption) (*SourceSnowflake, error)
public static SourceSnowflake Get(string name, Input<string> id, SourceSnowflakeState? state, CustomResourceOptions? opts = null)
public static SourceSnowflake get(String name, Output<String> id, SourceSnowflakeState state, CustomResourceOptions options)
resources:  _:    type: airbyte:SourceSnowflake    get:      id: ${id}
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
Configuration SourceSnowflakeConfiguration
CreatedAt double
DefinitionId string
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
Name string
Name of the source e.g. dev-mysql-instance.
ResourceAllocation SourceSnowflakeResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
SecretId string
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
SourceId string
SourceType string
WorkspaceId string
Configuration SourceSnowflakeConfigurationArgs
CreatedAt float64
DefinitionId string
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
Name string
Name of the source e.g. dev-mysql-instance.
ResourceAllocation SourceSnowflakeResourceAllocationArgs
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
SecretId string
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
SourceId string
SourceType string
WorkspaceId string
configuration SourceSnowflakeConfiguration
createdAt Double
definitionId String
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
name String
Name of the source e.g. dev-mysql-instance.
resourceAllocation SourceSnowflakeResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
secretId String
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
sourceId String
sourceType String
workspaceId String
configuration SourceSnowflakeConfiguration
createdAt number
definitionId string
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
name string
Name of the source e.g. dev-mysql-instance.
resourceAllocation SourceSnowflakeResourceAllocation
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
secretId string
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
sourceId string
sourceType string
workspaceId string
configuration SourceSnowflakeConfigurationArgs
created_at float
definition_id str
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
name str
Name of the source e.g. dev-mysql-instance.
resource_allocation SourceSnowflakeResourceAllocationArgs
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
secret_id str
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
source_id str
source_type str
workspace_id str
configuration Property Map
createdAt Number
definitionId String
The UUID of the connector definition. One of configuration.sourceType or definitionId must be provided. Requires replacement if changed.
name String
Name of the source e.g. dev-mysql-instance.
resourceAllocation Property Map
actor or actor definition specific resource requirements. if default is set, these are the requirements that should be set for ALL jobs run for this actor definition. it is overriden by the job type specific configurations. if not set, the platform will use defaults. these values will be overriden by configuration at the connection level.
secretId String
Optional secretID obtained through the public API OAuth redirect flow. Requires replacement if changed.
sourceId String
sourceType String
workspaceId String

Supporting Types

SourceSnowflakeConfiguration
, SourceSnowflakeConfigurationArgs

Database This property is required. string
The database you created for Airbyte to access data.
Host This property is required. string
The host domain of the snowflake instance (must include the account, region, cloud environment, and end with snowflakecomputing.com).
Role This property is required. string
The role you created for Airbyte to access Snowflake.
Warehouse This property is required. string
The warehouse you created for Airbyte to access data.
Credentials SourceSnowflakeConfigurationCredentials
JdbcUrlParams string
Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
Schema string
The source Snowflake schema tables. Leave empty to access tables from multiple schemas.
Database This property is required. string
The database you created for Airbyte to access data.
Host This property is required. string
The host domain of the snowflake instance (must include the account, region, cloud environment, and end with snowflakecomputing.com).
Role This property is required. string
The role you created for Airbyte to access Snowflake.
Warehouse This property is required. string
The warehouse you created for Airbyte to access data.
Credentials SourceSnowflakeConfigurationCredentials
JdbcUrlParams string
Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
Schema string
The source Snowflake schema tables. Leave empty to access tables from multiple schemas.
database This property is required. String
The database you created for Airbyte to access data.
host This property is required. String
The host domain of the snowflake instance (must include the account, region, cloud environment, and end with snowflakecomputing.com).
role This property is required. String
The role you created for Airbyte to access Snowflake.
warehouse This property is required. String
The warehouse you created for Airbyte to access data.
credentials SourceSnowflakeConfigurationCredentials
jdbcUrlParams String
Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
schema String
The source Snowflake schema tables. Leave empty to access tables from multiple schemas.
database This property is required. string
The database you created for Airbyte to access data.
host This property is required. string
The host domain of the snowflake instance (must include the account, region, cloud environment, and end with snowflakecomputing.com).
role This property is required. string
The role you created for Airbyte to access Snowflake.
warehouse This property is required. string
The warehouse you created for Airbyte to access data.
credentials SourceSnowflakeConfigurationCredentials
jdbcUrlParams string
Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
schema string
The source Snowflake schema tables. Leave empty to access tables from multiple schemas.
database This property is required. str
The database you created for Airbyte to access data.
host This property is required. str
The host domain of the snowflake instance (must include the account, region, cloud environment, and end with snowflakecomputing.com).
role This property is required. str
The role you created for Airbyte to access Snowflake.
warehouse This property is required. str
The warehouse you created for Airbyte to access data.
credentials SourceSnowflakeConfigurationCredentials
jdbc_url_params str
Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
schema str
The source Snowflake schema tables. Leave empty to access tables from multiple schemas.
database This property is required. String
The database you created for Airbyte to access data.
host This property is required. String
The host domain of the snowflake instance (must include the account, region, cloud environment, and end with snowflakecomputing.com).
role This property is required. String
The role you created for Airbyte to access Snowflake.
warehouse This property is required. String
The warehouse you created for Airbyte to access data.
credentials Property Map
jdbcUrlParams String
Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3).
schema String
The source Snowflake schema tables. Leave empty to access tables from multiple schemas.

SourceSnowflakeConfigurationCredentials
, SourceSnowflakeConfigurationCredentialsArgs

SourceSnowflakeConfigurationCredentialsKeyPairAuthentication
, SourceSnowflakeConfigurationCredentialsKeyPairAuthenticationArgs

PrivateKey This property is required. string
RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
Username This property is required. string
The username you created to allow Airbyte to access the database.
PrivateKeyPassword string
Passphrase for private key
PrivateKey This property is required. string
RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
Username This property is required. string
The username you created to allow Airbyte to access the database.
PrivateKeyPassword string
Passphrase for private key
privateKey This property is required. String
RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
username This property is required. String
The username you created to allow Airbyte to access the database.
privateKeyPassword String
Passphrase for private key
privateKey This property is required. string
RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
username This property is required. string
The username you created to allow Airbyte to access the database.
privateKeyPassword string
Passphrase for private key
private_key This property is required. str
RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
username This property is required. str
The username you created to allow Airbyte to access the database.
private_key_password str
Passphrase for private key
privateKey This property is required. String
RSA Private key to use for Snowflake connection. See the \n\ndocs\n\n for more information on how to obtain this key.
username This property is required. String
The username you created to allow Airbyte to access the database.
privateKeyPassword String
Passphrase for private key

SourceSnowflakeConfigurationCredentialsOAuth20
, SourceSnowflakeConfigurationCredentialsOAuth20Args

ClientId This property is required. string
The Client ID of your Snowflake developer application.
ClientSecret This property is required. string
The Client Secret of your Snowflake developer application.
AccessToken string
Access Token for making authenticated requests.
RefreshToken string
Refresh Token for making authenticated requests.
ClientId This property is required. string
The Client ID of your Snowflake developer application.
ClientSecret This property is required. string
The Client Secret of your Snowflake developer application.
AccessToken string
Access Token for making authenticated requests.
RefreshToken string
Refresh Token for making authenticated requests.
clientId This property is required. String
The Client ID of your Snowflake developer application.
clientSecret This property is required. String
The Client Secret of your Snowflake developer application.
accessToken String
Access Token for making authenticated requests.
refreshToken String
Refresh Token for making authenticated requests.
clientId This property is required. string
The Client ID of your Snowflake developer application.
clientSecret This property is required. string
The Client Secret of your Snowflake developer application.
accessToken string
Access Token for making authenticated requests.
refreshToken string
Refresh Token for making authenticated requests.
client_id This property is required. str
The Client ID of your Snowflake developer application.
client_secret This property is required. str
The Client Secret of your Snowflake developer application.
access_token str
Access Token for making authenticated requests.
refresh_token str
Refresh Token for making authenticated requests.
clientId This property is required. String
The Client ID of your Snowflake developer application.
clientSecret This property is required. String
The Client Secret of your Snowflake developer application.
accessToken String
Access Token for making authenticated requests.
refreshToken String
Refresh Token for making authenticated requests.

SourceSnowflakeConfigurationCredentialsUsernameAndPassword
, SourceSnowflakeConfigurationCredentialsUsernameAndPasswordArgs

Password This property is required. string
The password associated with the username.
Username This property is required. string
The username you created to allow Airbyte to access the database.
Password This property is required. string
The password associated with the username.
Username This property is required. string
The username you created to allow Airbyte to access the database.
password This property is required. String
The password associated with the username.
username This property is required. String
The username you created to allow Airbyte to access the database.
password This property is required. string
The password associated with the username.
username This property is required. string
The username you created to allow Airbyte to access the database.
password This property is required. str
The password associated with the username.
username This property is required. str
The username you created to allow Airbyte to access the database.
password This property is required. String
The password associated with the username.
username This property is required. String
The username you created to allow Airbyte to access the database.

SourceSnowflakeResourceAllocation
, SourceSnowflakeResourceAllocationArgs

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

SourceSnowflakeResourceAllocationDefault
, SourceSnowflakeResourceAllocationDefaultArgs

SourceSnowflakeResourceAllocationJobSpecific
, SourceSnowflakeResourceAllocationJobSpecificArgs

JobType string
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
ResourceRequirements SourceSnowflakeResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
JobType string
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
ResourceRequirements SourceSnowflakeResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
jobType String
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
resourceRequirements SourceSnowflakeResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
jobType string
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
resourceRequirements SourceSnowflakeResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
job_type str
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
resource_requirements SourceSnowflakeResourceAllocationJobSpecificResourceRequirements
optional resource requirements to run workers (blank for unbounded allocations)
jobType String
enum that describes the different types of jobs that the platform runs. must be one of ["getspec", "checkconnection", "discoverschema", "sync", "resetconnection", "connection_updater", "replicate"]
resourceRequirements Property Map
optional resource requirements to run workers (blank for unbounded allocations)

SourceSnowflakeResourceAllocationJobSpecificResourceRequirements
, SourceSnowflakeResourceAllocationJobSpecificResourceRequirementsArgs

Import

$ pulumi import airbyte:index/sourceSnowflake:SourceSnowflake my_airbyte_source_snowflake ""
Copy

To learn more about importing existing cloud resources, see Importing resources.

Package Details

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