pulumi-azure-kotlin/com.pulumi.azure.datafactory.kotlin/DatasetSnowflakeArgs

DatasetSnowflakeArgs

data class DatasetSnowflakeArgs(val additionalProperties: Output<Map<String, String>>? = null, val annotations: Output<List<String>>? = null, val dataFactoryId: Output<String>? = null, val description: Output<String>? = null, val folder: Output<String>? = null, val linkedServiceName: Output<String>? = null, val name: Output<String>? = null, val parameters: Output<Map<String, String>>? = null, val schemaColumns: Output<List<DatasetSnowflakeSchemaColumnArgs>>? = null, val schemaName: Output<String>? = null, val tableName: Output<String>? = null) : ConvertibleToJava<DatasetSnowflakeArgs>

Manages a Snowflake Dataset inside an Azure Data Factory.

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const example = new azure.core.ResourceGroup("example", {
    name: "example-resources",
    location: "West Europe",
});
const exampleFactory = new azure.datafactory.Factory("example", {
    name: "example",
    location: example.location,
    resourceGroupName: example.name,
});
const exampleLinkedServiceSnowflake = new azure.datafactory.LinkedServiceSnowflake("example", {
    name: "example",
    dataFactoryId: exampleFactory.id,
    connectionString: "jdbc:snowflake://account.region.snowflakecomputing.com/?user=user&db=db&warehouse=wh",
});
const exampleDatasetSnowflake = new azure.datafactory.DatasetSnowflake("example", {
    name: "example",
    dataFactoryId: exampleFactory.id,
    linkedServiceName: exampleLinkedServiceSnowflake.name,
    schemaName: "foo_schema",
    tableName: "foo_table",
});
Content copied to clipboard
import pulumi
import pulumi_azure as azure
example = azure.core.ResourceGroup("example",
    name="example-resources",
    location="West Europe")
example_factory = azure.datafactory.Factory("example",
    name="example",
    location=example.location,
    resource_group_name=example.name)
example_linked_service_snowflake = azure.datafactory.LinkedServiceSnowflake("example",
    name="example",
    data_factory_id=example_factory.id,
    connection_string="jdbc:snowflake://account.region.snowflakecomputing.com/?user=user&db=db&warehouse=wh")
example_dataset_snowflake = azure.datafactory.DatasetSnowflake("example",
    name="example",
    data_factory_id=example_factory.id,
    linked_service_name=example_linked_service_snowflake.name,
    schema_name="foo_schema",
    table_name="foo_table")
Content copied to clipboard
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
    var example = new Azure.Core.ResourceGroup("example", new()
    {
        Name = "example-resources",
        Location = "West Europe",
    });
    var exampleFactory = new Azure.DataFactory.Factory("example", new()
    {
        Name = "example",
        Location = example.Location,
        ResourceGroupName = example.Name,
    });
    var exampleLinkedServiceSnowflake = new Azure.DataFactory.LinkedServiceSnowflake("example", new()
    {
        Name = "example",
        DataFactoryId = exampleFactory.Id,
        ConnectionString = "jdbc:snowflake://account.region.snowflakecomputing.com/?user=user&db=db&warehouse=wh",
    });
    var exampleDatasetSnowflake = new Azure.DataFactory.DatasetSnowflake("example", new()
    {
        Name = "example",
        DataFactoryId = exampleFactory.Id,
        LinkedServiceName = exampleLinkedServiceSnowflake.Name,
        SchemaName = "foo_schema",
        TableName = "foo_table",
    });
});
Content copied to clipboard
package main
import (
	"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/core"
	"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/datafactory"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		example, err := core.NewResourceGroup(ctx, "example", &core.ResourceGroupArgs{
			Name:     pulumi.String("example-resources"),
			Location: pulumi.String("West Europe"),
		})
		if err != nil {
			return err
		}
		exampleFactory, err := datafactory.NewFactory(ctx, "example", &datafactory.FactoryArgs{
			Name:              pulumi.String("example"),
			Location:          example.Location,
			ResourceGroupName: example.Name,
		})
		if err != nil {
			return err
		}
		exampleLinkedServiceSnowflake, err := datafactory.NewLinkedServiceSnowflake(ctx, "example", &datafactory.LinkedServiceSnowflakeArgs{
			Name:             pulumi.String("example"),
			DataFactoryId:    exampleFactory.ID(),
			ConnectionString: pulumi.String("jdbc:snowflake://account.region.snowflakecomputing.com/?user=user&db=db&warehouse=wh"),
		})
		if err != nil {
			return err
		}
		_, err = datafactory.NewDatasetSnowflake(ctx, "example", &datafactory.DatasetSnowflakeArgs{
			Name:              pulumi.String("example"),
			DataFactoryId:     exampleFactory.ID(),
			LinkedServiceName: exampleLinkedServiceSnowflake.Name,
			SchemaName:        pulumi.String("foo_schema"),
			TableName:         pulumi.String("foo_table"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.datafactory.Factory;
import com.pulumi.azure.datafactory.FactoryArgs;
import com.pulumi.azure.datafactory.LinkedServiceSnowflake;
import com.pulumi.azure.datafactory.LinkedServiceSnowflakeArgs;
import com.pulumi.azure.datafactory.DatasetSnowflake;
import com.pulumi.azure.datafactory.DatasetSnowflakeArgs;
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 example = new ResourceGroup("example", ResourceGroupArgs.builder()
            .name("example-resources")
            .location("West Europe")
            .build());
        var exampleFactory = new Factory("exampleFactory", FactoryArgs.builder()
            .name("example")
            .location(example.location())
            .resourceGroupName(example.name())
            .build());
        var exampleLinkedServiceSnowflake = new LinkedServiceSnowflake("exampleLinkedServiceSnowflake", LinkedServiceSnowflakeArgs.builder()
            .name("example")
            .dataFactoryId(exampleFactory.id())
            .connectionString("jdbc:snowflake://account.region.snowflakecomputing.com/?user=user&db=db&warehouse=wh")
            .build());
        var exampleDatasetSnowflake = new DatasetSnowflake("exampleDatasetSnowflake", DatasetSnowflakeArgs.builder()
            .name("example")
            .dataFactoryId(exampleFactory.id())
            .linkedServiceName(exampleLinkedServiceSnowflake.name())
            .schemaName("foo_schema")
            .tableName("foo_table")
            .build());
    }
}
Content copied to clipboard
resources:
  example:
    type: azure:core:ResourceGroup
    properties:
      name: example-resources
      location: West Europe
  exampleFactory:
    type: azure:datafactory:Factory
    name: example
    properties:
      name: example
      location: ${example.location}
      resourceGroupName: ${example.name}
  exampleLinkedServiceSnowflake:
    type: azure:datafactory:LinkedServiceSnowflake
    name: example
    properties:
      name: example
      dataFactoryId: ${exampleFactory.id}
      connectionString: jdbc:snowflake://account.region.snowflakecomputing.com/?user=user&db=db&warehouse=wh
  exampleDatasetSnowflake:
    type: azure:datafactory:DatasetSnowflake
    name: example
    properties:
      name: example
      dataFactoryId: ${exampleFactory.id}
      linkedServiceName: ${exampleLinkedServiceSnowflake.name}
      schemaName: foo_schema
      tableName: foo_table
Content copied to clipboard

Import

Data Factory Snowflake Datasets can be imported using the resource id, e.g.

$ pulumi import azure:datafactory/datasetSnowflake:DatasetSnowflake example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/example/providers/Microsoft.DataFactory/factories/example/datasets/example
Content copied to clipboard

Constructors

Link copied to clipboard
constructor(additionalProperties: Output<Map<String, String>>? = null, annotations: Output<List<String>>? = null, dataFactoryId: Output<String>? = null, description: Output<String>? = null, folder: Output<String>? = null, linkedServiceName: Output<String>? = null, name: Output<String>? = null, parameters: Output<Map<String, String>>? = null, schemaColumns: Output<List<DatasetSnowflakeSchemaColumnArgs>>? = null, schemaName: Output<String>? = null, tableName: Output<String>? = null)

Properties

Link copied to clipboard
val additionalProperties: Output<Map<String, String>>? = null

A map of additional properties to associate with the Data Factory Dataset Snowflake.

Link copied to clipboard
val annotations: Output<List<String>>? = null

List of tags that can be used for describing the Data Factory Dataset Snowflake.

Link copied to clipboard
val dataFactoryId: Output<String>? = null

The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource.

Link copied to clipboard
val description: Output<String>? = null

The description for the Data Factory Dataset Snowflake.

Link copied to clipboard
val folder: Output<String>? = null

The folder that this Dataset is in. If not specified, the Dataset will appear at the root level.

Link copied to clipboard
val linkedServiceName: Output<String>? = null

The Data Factory Linked Service name in which to associate the Dataset with.

Link copied to clipboard
val name: Output<String>? = null

Specifies the name of the Data Factory Dataset Snowflake. Changing this forces a new resource to be created. Must be globally unique. See the Microsoft documentation for all restrictions.

Link copied to clipboard
val parameters: Output<Map<String, String>>? = null

A map of parameters to associate with the Data Factory Dataset Snowflake.

Link copied to clipboard
val schemaColumns: Output<List<DatasetSnowflakeSchemaColumnArgs>>? = null

A schema_column block as defined below.

Link copied to clipboard
val schemaName: Output<String>? = null

The schema name of the Data Factory Dataset Snowflake.

Link copied to clipboard
val tableName: Output<String>? = null

The table name of the Data Factory Dataset Snowflake.

Functions

Link copied to clipboard
open override fun toJava(): DatasetSnowflakeArgs