Class DatasetSqlServerTable

Manages a SQL Server Table Dataset inside a Azure Data Factory.

Example Usage

using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
public MyStack()
{
    var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new Azure.Core.ResourceGroupArgs
    {
        Location = "northeurope",
    });
    var exampleFactory = new Azure.DataFactory.Factory("exampleFactory", new Azure.DataFactory.FactoryArgs
    {
        Location = exampleResourceGroup.Location,
        ResourceGroupName = exampleResourceGroup.Name,
    });
    var exampleLinkedServiceSqlServer = new Azure.DataFactory.LinkedServiceSqlServer("exampleLinkedServiceSqlServer", new Azure.DataFactory.LinkedServiceSqlServerArgs
    {
        ResourceGroupName = exampleResourceGroup.Name,
        DataFactoryName = exampleFactory.Name,
        ConnectionString = "Integrated Security=False;Data Source=test;Initial Catalog=test;User ID=test;Password=test",
    });
    var exampleDatasetSqlServerTable = new Azure.DataFactory.DatasetSqlServerTable("exampleDatasetSqlServerTable", new Azure.DataFactory.DatasetSqlServerTableArgs
    {
        ResourceGroupName = exampleResourceGroup.Name,
        DataFactoryName = exampleFactory.Name,
        LinkedServiceName = exampleLinkedServiceSqlServer.Name,
    });
}

}

Inheritance

System.Object

Resource

CustomResource

DatasetSqlServerTable

Inherited Members

CustomResource.Id

Resource.GetResourceType()

Resource.GetResourceName()

Resource.Urn

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Pulumi.Azure.DataFactory

Assembly: Pulumi.Azure.dll

Syntax

public class DatasetSqlServerTable : CustomResource

Constructors

DatasetSqlServerTable(String, DatasetSqlServerTableArgs, CustomResourceOptions)

Create a DatasetSqlServerTable resource with the given unique name, arguments, and options.

Declaration

public DatasetSqlServerTable(string name, DatasetSqlServerTableArgs args, CustomResourceOptions options = null)

Parameters

Type	Name	Description
System.String	name	The unique name of the resource
DatasetSqlServerTableArgs	args	The arguments used to populate this resource's properties
CustomResourceOptions	options	A bag of options that control this resource's behavior

Properties

AdditionalProperties

A map of additional properties to associate with the Data Factory Dataset SQL Server Table.

Declaration

public Output<ImmutableDictionary<string, string>> AdditionalProperties { get; }

Property Value

Type	Description
Output<System.Collections.Immutable.ImmutableDictionary<System.String, System.String>>

Annotations

List of tags that can be used for describing the Data Factory Dataset SQL Server Table.

Declaration

public Output<ImmutableArray<string>> Annotations { get; }

Property Value

Type	Description
Output<System.Collections.Immutable.ImmutableArray<System.String>>

DataFactoryName

The Data Factory name in which to associate the Dataset with. Changing this forces a new resource.

Declaration

public Output<string> DataFactoryName { get; }

Property Value

Type	Description
Output<System.String>

Description

The description for the Data Factory Dataset SQL Server Table.

Declaration

public Output<string> Description { get; }

Property Value

Type	Description
Output<System.String>

Folder

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

Declaration

public Output<string> Folder { get; }

Property Value

Type	Description
Output<System.String>

LinkedServiceName

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

Declaration

public Output<string> LinkedServiceName { get; }

Property Value

Type	Description
Output<System.String>

Name

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

Declaration

public Output<string> Name { get; }

Property Value

Type	Description
Output<System.String>

Parameters

A map of parameters to associate with the Data Factory Dataset SQL Server Table.

Declaration

public Output<ImmutableDictionary<string, string>> Parameters { get; }

Property Value

Type	Description
Output<System.Collections.Immutable.ImmutableDictionary<System.String, System.String>>

ResourceGroupName

The name of the resource group in which to create the Data Factory Dataset SQL Server Table. Changing this forces a new resource

Declaration

public Output<string> ResourceGroupName { get; }

Property Value

Type	Description
Output<System.String>

SchemaColumns

A schema_column block as defined below.

Declaration

public Output<ImmutableArray<DatasetSqlServerTableSchemaColumn>> SchemaColumns { get; }

Property Value

Type	Description
Output<System.Collections.Immutable.ImmutableArray<DatasetSqlServerTableSchemaColumn>>

TableName

The table name of the Data Factory Dataset SQL Server Table.

Declaration

public Output<string> TableName { get; }

Property Value

Type	Description
Output<System.String>

Methods

Get(String, Input<String>, DatasetSqlServerTableState, CustomResourceOptions)

Get an existing DatasetSqlServerTable resource's state with the given name, ID, and optional extra properties used to qualify the lookup.

Declaration

public static DatasetSqlServerTable Get(string name, Input<string> id, DatasetSqlServerTableState state = null, CustomResourceOptions options = null)

Parameters

Type	Name	Description
System.String	name	The unique name of the resulting resource.
Input<System.String>	id	The unique provider ID of the resource to lookup.
DatasetSqlServerTableState	state	Any extra arguments used during the lookup.
CustomResourceOptions	options	A bag of options that control this resource's behavior

Returns

Type	Description
DatasetSqlServerTable