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

DatasetSqlServerTable

class DatasetSqlServerTable : KotlinCustomResource

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

Example Usage

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.LinkedServiceSqlServer;
import com.pulumi.azure.datafactory.LinkedServiceSqlServerArgs;
import com.pulumi.azure.datafactory.DatasetSqlServerTable;
import com.pulumi.azure.datafactory.DatasetSqlServerTableArgs;
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 exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()
            .location("West Europe")
            .build());
        var exampleFactory = new Factory("exampleFactory", FactoryArgs.builder()
            .location(exampleResourceGroup.location())
            .resourceGroupName(exampleResourceGroup.name())
            .build());
        var exampleLinkedServiceSqlServer = new LinkedServiceSqlServer("exampleLinkedServiceSqlServer", LinkedServiceSqlServerArgs.builder()
            .dataFactoryId(exampleFactory.id())
            .connectionString("Integrated Security=False;Data Source=test;Initial Catalog=test;User ID=test;Password=test")
            .build());
        var exampleDatasetSqlServerTable = new DatasetSqlServerTable("exampleDatasetSqlServerTable", DatasetSqlServerTableArgs.builder()
            .dataFactoryId(exampleFactory.id())
            .linkedServiceName(exampleLinkedServiceSqlServer.name())
            .build());
    }
}

Import

Data Factory SQL Server Table Datasets can be imported using the resource id, e.g.

$ pulumi import azure:datafactory/datasetSqlServerTable:DatasetSqlServerTable example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/example/providers/Microsoft.DataFactory/factories/example/datasets/example

Properties

additionalProperties

val additionalProperties: Output<Map<String, String>>?

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

annotations

val annotations: Output<List<String>>?

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

dataFactoryId

val dataFactoryId: Output<String>

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

description

val description: Output<String>?

The description for the Data Factory Dataset SQL Server Table.

folder

val folder: Output<String>?

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

val id: Output<String>

linkedServiceName

val linkedServiceName: Output<String>

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

name

val name: Output<String>

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.

parameters

val parameters: Output<Map<String, String>>?

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

pulumiChildResources

val pulumiChildResources: Set<KotlinResource>

pulumiResourceName

val pulumiResourceName: String

pulumiResourceType

val pulumiResourceType: String

schemaColumns

val schemaColumns: Output<List<DatasetSqlServerTableSchemaColumn>>?

A schema_column block as defined below.

tableName

val tableName: Output<String>?

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

urn

val urn: Output<String>