import * as pulumi from "@pulumi/pulumi"; /** * Manages a Stream Analytics Reference Input from MS SQL. Reference data (also known as a lookup table) is a finite data set that is static or slowly changing in nature, used to perform a lookup or to correlate with your data stream. Learn more [here](https://docs.microsoft.com/azure/stream-analytics/stream-analytics-use-reference-data#azure-sql-database). * * ## Example Usage * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as azure from "@pulumi/azure"; * * const exampleResourceGroup = new azure.core.ResourceGroup("example", { * name: "example-resources", * location: "West Europe", * }); * const example = azure.streamanalytics.getJobOutput({ * name: "example-job", * resourceGroupName: exampleResourceGroup.name, * }); * const exampleServer = new azure.mssql.Server("example", { * name: "example-sqlserver", * resourceGroupName: exampleResourceGroup.name, * location: exampleResourceGroup.location, * version: "12.0", * administratorLogin: "admin", * administratorLoginPassword: "password", * }); * const exampleDatabase = new azure.mssql.Database("example", { * name: "example-db", * serverId: exampleServer.id, * }); * const exampleReferenceInputMssql = new azure.streamanalytics.ReferenceInputMssql("example", { * name: "example-reference-input", * resourceGroupName: example.apply(example => example.resourceGroupName), * streamAnalyticsJobName: example.apply(example => example.name), * server: exampleServer.fullyQualifiedDomainName, * database: exampleDatabase.name, * username: "exampleuser", * password: "examplepassword", * refreshType: "RefreshPeriodicallyWithFull", * refreshIntervalDuration: "00:20:00", * fullSnapshotQuery: ` SELECT * * INTO [YourOutputAlias] * FROM [YourInputAlias] * `, * }); * ``` * * ## API Providers * * * This resource uses the following Azure API Providers: * * * `Microsoft.StreamAnalytics` - 2020-03-01 * * ## Import * * Stream Analytics can be imported using the `resource id`, e.g. * * ```sh * $ pulumi import azure:streamanalytics/referenceInputMssql:ReferenceInputMssql example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/group1/providers/Microsoft.StreamAnalytics/streamingJobs/job1/inputs/input1 * ``` */ export declare class ReferenceInputMssql extends pulumi.CustomResource { /** * Get an existing ReferenceInputMssql resource's state with the given name, ID, and optional extra * properties used to qualify the lookup. * * @param name The _unique_ name of the resulting resource. * @param id The _unique_ provider ID of the resource to lookup. * @param state Any extra arguments used during the lookup. * @param opts Optional settings to control the behavior of the CustomResource. */ static get(name: string, id: pulumi.Input, state?: ReferenceInputMssqlState, opts?: pulumi.CustomResourceOptions): ReferenceInputMssql; /** * Returns true if the given object is an instance of ReferenceInputMssql. This is designed to work even * when multiple copies of the Pulumi SDK have been loaded into the same process. */ static isInstance(obj: any): obj is ReferenceInputMssql; /** * The MS SQL database name where the reference data exists. */ readonly database: pulumi.Output; /** * The query used to retrieve incremental changes in the reference data from the MS SQL database. Cannot be set when `refreshType` is `Static`. */ readonly deltaSnapshotQuery: pulumi.Output; /** * The query used to retrieve the reference data from the MS SQL database. */ readonly fullSnapshotQuery: pulumi.Output; /** * The name of the Reference Input MS SQL data. Changing this forces a new resource to be created. */ readonly name: pulumi.Output; /** * The password to connect to the MS SQL database. */ readonly password: pulumi.Output; /** * The frequency in `hh:mm:ss` with which the reference data should be retrieved from the MS SQL database e.g. `00:20:00` for every 20 minutes. Must be set when `refreshType` is `RefreshPeriodicallyWithFull` or `RefreshPeriodicallyWithDelta`. */ readonly refreshIntervalDuration: pulumi.Output; /** * Defines whether and how the reference data should be refreshed. Accepted values are `Static`, `RefreshPeriodicallyWithFull` and `RefreshPeriodicallyWithDelta`. */ readonly refreshType: pulumi.Output; /** * The name of the Resource Group where the Stream Analytics Job should exist. Changing this forces a new resource to be created. */ readonly resourceGroupName: pulumi.Output; /** * The fully qualified domain name of the MS SQL server. */ readonly server: pulumi.Output; /** * The name of the Stream Analytics Job. Changing this forces a new resource to be created. */ readonly streamAnalyticsJobName: pulumi.Output; /** * The name of the table in the Azure SQL database. */ readonly table: pulumi.Output; /** * The username to connect to the MS SQL database. */ readonly username: pulumi.Output; /** * Create a ReferenceInputMssql resource with the given unique name, arguments, and options. * * @param name The _unique_ name of the resource. * @param args The arguments to use to populate this resource's properties. * @param opts A bag of options that control this resource's behavior. */ constructor(name: string, args: ReferenceInputMssqlArgs, opts?: pulumi.CustomResourceOptions); } /** * Input properties used for looking up and filtering ReferenceInputMssql resources. */ export interface ReferenceInputMssqlState { /** * The MS SQL database name where the reference data exists. */ database?: pulumi.Input; /** * The query used to retrieve incremental changes in the reference data from the MS SQL database. Cannot be set when `refreshType` is `Static`. */ deltaSnapshotQuery?: pulumi.Input; /** * The query used to retrieve the reference data from the MS SQL database. */ fullSnapshotQuery?: pulumi.Input; /** * The name of the Reference Input MS SQL data. Changing this forces a new resource to be created. */ name?: pulumi.Input; /** * The password to connect to the MS SQL database. */ password?: pulumi.Input; /** * The frequency in `hh:mm:ss` with which the reference data should be retrieved from the MS SQL database e.g. `00:20:00` for every 20 minutes. Must be set when `refreshType` is `RefreshPeriodicallyWithFull` or `RefreshPeriodicallyWithDelta`. */ refreshIntervalDuration?: pulumi.Input; /** * Defines whether and how the reference data should be refreshed. Accepted values are `Static`, `RefreshPeriodicallyWithFull` and `RefreshPeriodicallyWithDelta`. */ refreshType?: pulumi.Input; /** * The name of the Resource Group where the Stream Analytics Job should exist. Changing this forces a new resource to be created. */ resourceGroupName?: pulumi.Input; /** * The fully qualified domain name of the MS SQL server. */ server?: pulumi.Input; /** * The name of the Stream Analytics Job. Changing this forces a new resource to be created. */ streamAnalyticsJobName?: pulumi.Input; /** * The name of the table in the Azure SQL database. */ table?: pulumi.Input; /** * The username to connect to the MS SQL database. */ username?: pulumi.Input; } /** * The set of arguments for constructing a ReferenceInputMssql resource. */ export interface ReferenceInputMssqlArgs { /** * The MS SQL database name where the reference data exists. */ database: pulumi.Input; /** * The query used to retrieve incremental changes in the reference data from the MS SQL database. Cannot be set when `refreshType` is `Static`. */ deltaSnapshotQuery?: pulumi.Input; /** * The query used to retrieve the reference data from the MS SQL database. */ fullSnapshotQuery: pulumi.Input; /** * The name of the Reference Input MS SQL data. Changing this forces a new resource to be created. */ name?: pulumi.Input; /** * The password to connect to the MS SQL database. */ password: pulumi.Input; /** * The frequency in `hh:mm:ss` with which the reference data should be retrieved from the MS SQL database e.g. `00:20:00` for every 20 minutes. Must be set when `refreshType` is `RefreshPeriodicallyWithFull` or `RefreshPeriodicallyWithDelta`. */ refreshIntervalDuration?: pulumi.Input; /** * Defines whether and how the reference data should be refreshed. Accepted values are `Static`, `RefreshPeriodicallyWithFull` and `RefreshPeriodicallyWithDelta`. */ refreshType: pulumi.Input; /** * The name of the Resource Group where the Stream Analytics Job should exist. Changing this forces a new resource to be created. */ resourceGroupName: pulumi.Input; /** * The fully qualified domain name of the MS SQL server. */ server: pulumi.Input; /** * The name of the Stream Analytics Job. Changing this forces a new resource to be created. */ streamAnalyticsJobName: pulumi.Input; /** * The name of the table in the Azure SQL database. */ table?: pulumi.Input; /** * The username to connect to the MS SQL database. */ username: pulumi.Input; }