Dataset
data class DatasetAzureSqlTableArgs(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 linkedServiceId: Output<String>? = null, val name: Output<String>? = null, val parameters: Output<Map<String, String>>? = null, val schema: Output<String>? = null, val schemaColumns: Output<List<DatasetAzureSqlTableSchemaColumnArgs>>? = null, val table: Output<String>? = null) : ConvertibleToJava<DatasetAzureSqlTableArgs>
Manages an Azure SQL Table 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 exampleLinkedServiceAzureSqlDatabase = new azure.datafactory.LinkedServiceAzureSqlDatabase("example", {
name: "example",
dataFactoryId: exampleFactory.id,
connectionString: "Integrated Security=False;Data Source=test;Initial Catalog=test;Initial Catalog=test;User ID=test;Password=test",
});
const exampleDatasetAzureSqlTable = new azure.datafactory.DatasetAzureSqlTable("example", {
name: "example",
dataFactoryId: exampleFactory.id,
linkedServiceId: exampleLinkedServiceAzureSqlDatabase.id,
});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_azure_sql_database = azure.datafactory.LinkedServiceAzureSqlDatabase("example",
name="example",
data_factory_id=example_factory.id,
connection_string="Integrated Security=False;Data Source=test;Initial Catalog=test;Initial Catalog=test;User ID=test;Password=test")
example_dataset_azure_sql_table = azure.datafactory.DatasetAzureSqlTable("example",
name="example",
data_factory_id=example_factory.id,
linked_service_id=example_linked_service_azure_sql_database.id)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 exampleLinkedServiceAzureSqlDatabase = new Azure.DataFactory.LinkedServiceAzureSqlDatabase("example", new()
{
Name = "example",
DataFactoryId = exampleFactory.Id,
ConnectionString = "Integrated Security=False;Data Source=test;Initial Catalog=test;Initial Catalog=test;User ID=test;Password=test",
});
var exampleDatasetAzureSqlTable = new Azure.DataFactory.DatasetAzureSqlTable("example", new()
{
Name = "example",
DataFactoryId = exampleFactory.Id,
LinkedServiceId = exampleLinkedServiceAzureSqlDatabase.Id,
});
});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
}
exampleLinkedServiceAzureSqlDatabase, err := datafactory.NewLinkedServiceAzureSqlDatabase(ctx, "example", &datafactory.LinkedServiceAzureSqlDatabaseArgs{
Name: pulumi.String("example"),
DataFactoryId: exampleFactory.ID(),
ConnectionString: pulumi.String("Integrated Security=False;Data Source=test;Initial Catalog=test;Initial Catalog=test;User ID=test;Password=test"),
})
if err != nil {
return err
}
_, err = datafactory.NewDatasetAzureSqlTable(ctx, "example", &datafactory.DatasetAzureSqlTableArgs{
Name: pulumi.String("example"),
DataFactoryId: exampleFactory.ID(),
LinkedServiceId: exampleLinkedServiceAzureSqlDatabase.ID(),
})
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.LinkedServiceAzureSqlDatabase;
import com.pulumi.azure.datafactory.LinkedServiceAzureSqlDatabaseArgs;
import com.pulumi.azure.datafactory.DatasetAzureSqlTable;
import com.pulumi.azure.datafactory.DatasetAzureSqlTableArgs;
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 exampleLinkedServiceAzureSqlDatabase = new LinkedServiceAzureSqlDatabase("exampleLinkedServiceAzureSqlDatabase", LinkedServiceAzureSqlDatabaseArgs.builder()
.name("example")
.dataFactoryId(exampleFactory.id())
.connectionString("Integrated Security=False;Data Source=test;Initial Catalog=test;Initial Catalog=test;User ID=test;Password=test")
.build());
var exampleDatasetAzureSqlTable = new DatasetAzureSqlTable("exampleDatasetAzureSqlTable", DatasetAzureSqlTableArgs.builder()
.name("example")
.dataFactoryId(exampleFactory.id())
.linkedServiceId(exampleLinkedServiceAzureSqlDatabase.id())
.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}
exampleLinkedServiceAzureSqlDatabase:
type: azure:datafactory:LinkedServiceAzureSqlDatabase
name: example
properties:
name: example
dataFactoryId: ${exampleFactory.id}
connectionString: Integrated Security=False;Data Source=test;Initial Catalog=test;Initial Catalog=test;User ID=test;Password=test
exampleDatasetAzureSqlTable:
type: azure:datafactory:DatasetAzureSqlTable
name: example
properties:
name: example
dataFactoryId: ${exampleFactory.id}
linkedServiceId: ${exampleLinkedServiceAzureSqlDatabase.id}Content copied to clipboard
Import
Data Factory Azure SQL Table Datasets can be imported using the resource id, e.g.
$ pulumi import azure:datafactory/datasetAzureSqlTable:DatasetAzureSqlTable example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/example/providers/Microsoft.DataFactory/factories/example/datasets/exampleContent 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, linkedServiceId: Output<String>? = null, name: Output<String>? = null, parameters: Output<Map<String, String>>? = null, schema: Output<String>? = null, schemaColumns: Output<List<DatasetAzureSqlTableSchemaColumnArgs>>? = null, table: Output<String>? = null)
Properties
Link copied to clipboard
A map of additional properties to associate with the Data Factory Dataset Azure SQL Table.
Link copied to clipboard
List of tags that can be used for describing the Data Factory Dataset Azure SQL Table.
Link copied to clipboard
The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource.
Link copied to clipboard
The description for the Data Factory Dataset Azure SQL Table.
Link copied to clipboard
The Data Factory Linked Service ID in which to associate the Dataset with.
Link copied to clipboard
Specifies the name of the Data Factory Dataset Azure SQL Table. Changing this forces a new resource to be created. Must be globally unique. See the Microsoft documentation for all restrictions.
Link copied to clipboard
A map of parameters to associate with the Data Factory Dataset Azure SQL Table.
Link copied to clipboard
A schema_column block as defined below.