DatasetAzureSqlTable

class DatasetAzureSqlTable : KotlinCustomResource

Manages an Azure SQL Table Dataset inside an 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.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 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 exampleLinkedServiceAzureSqlDatabase = new LinkedServiceAzureSqlDatabase("exampleLinkedServiceAzureSqlDatabase", LinkedServiceAzureSqlDatabaseArgs.builder()
.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()
.dataFactoryId(exampleFactory.id())
.linkedServiceId(exampleLinkedServiceAzureSqlDatabase.id())
.build());
}
}

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/example

Properties

Link copied to clipboard

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

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

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

Link copied to clipboard
val dataFactoryId: Output<String>

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>?

The description for the Data Factory Dataset Azure SQL Table.

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

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

Link copied to clipboard
val id: Output<String>
Link copied to clipboard
val linkedServiceId: Output<String>

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

Link copied to clipboard
val name: Output<String>

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
val parameters: Output<Map<String, String>>?

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

Link copied to clipboard
val pulumiChildResources: Set<KotlinResource>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
val schema: Output<String>?

The schema name of the table in the Azure SQL Database.

Link copied to clipboard

A schema_column block as defined below.

Link copied to clipboard
val table: Output<String>?

The table name of the table in the Azure SQL Database.

Link copied to clipboard
val urn: Output<String>