import * as pulumi from "@pulumi/pulumi"; import { input as inputs, output as outputs } from "../types"; /** * Manages DLI SQL job resource within HuaweiCloud * * ## Example Usage * ### Create a Sql job * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as pulumi from "@huaweicloudos/pulumi"; * * const config = new pulumi.Config(); * const databaseName = config.requireObject("databaseName"); * const queueName = config.requireObject("queueName"); * const sql = config.requireObject("sql"); * const test = new huaweicloud.dli.SqlJob("test", { * sql: sql, * databaseName: databaseName, * queueName: queueName, * }); * ``` * * ## Import * * DLI SQL job can be imported by `id`. For example, bash * * ```sh * $ pulumi import huaweicloud:Dli/sqlJob:SqlJob example 7f803d70-c533-469f-8431-e378f3e97123 * ``` * * Note that the imported state may not be identical to your resource definition, due to some attributes missing from the API response, security or some other reason. The missing attributes include`conf`, `rows` and `schema`. It is generally recommended running `terraform plan` after importing a resource. You can then decide if changes should be applied to the resource, or the resource definition should be updated to align with the resource. Also you can ignore changes as below. hcl resource "huaweicloud_dli_sql_job" "test" { * * ... * * lifecycle { * * ignore_changes = [ * * conf, rows, schema * * ] * * } } */ export declare class SqlJob extends pulumi.CustomResource { /** * Get an existing SqlJob 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?: SqlJobState, opts?: pulumi.CustomResourceOptions): SqlJob; /** * Returns true if the given object is an instance of SqlJob. 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 SqlJob; /** * Specifies the configuration parameters for the SQL job. Changing this parameter * will create a new resource. Structure is documented below. */ readonly conf: pulumi.Output; /** * Specifies the database where the SQL is executed. This argument does * not need to be configured during database creation. Changing this parameter will create a new resource. */ readonly databaseName: pulumi.Output; /** * Job running duration (unit: millisecond). */ readonly duration: pulumi.Output; /** * Type of a job, Includes **DDL**, **DCL**, **IMPORT**, **EXPORT**, **QUERY**, **INSERT**, * **DATA_MIGRATION**, **UPDATE**, **DELETE**, **RESTART_QUEUE** and **SCALE_QUEUE**. */ readonly jobType: pulumi.Output; /** * User who submits a job. */ readonly owner: pulumi.Output; /** * Specifies queue which this job to be submitted belongs. * Changing this parameter will create a new resource. */ readonly queueName: pulumi.Output; /** * Specifies the region in which to create the DLI table resource. If omitted, * the provider-level region will be used. Changing this parameter will create a new resource. */ readonly region: pulumi.Output; /** * When the statement type is DDL, results of the DDL are displayed. */ readonly rows: pulumi.Output; /** * When the statement type is DDL, the column name and type of DDL are displayed. */ readonly schemas: pulumi.Output<{ [key: string]: string; }[]>; /** * Specifies SQL statement that you want to execute. * Changing this parameter will create a new resource. */ readonly sql: pulumi.Output; /** * Time when a job is started, in RFC-3339 format. e.g. `2019-10-12T07:20:50.52Z` */ readonly startTime: pulumi.Output; /** * Status of a job, including **RUNNING**, **SCALING**, **LAUNCHING**, **FINISHED**, **FAILED**, * and **CANCELLED.** */ readonly status: pulumi.Output; /** * Specifies label of a Job. Changing this parameter will create a new resource. */ readonly tags: pulumi.Output<{ [key: string]: string; } | undefined>; /** * Create a SqlJob 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: SqlJobArgs, opts?: pulumi.CustomResourceOptions); } /** * Input properties used for looking up and filtering SqlJob resources. */ export interface SqlJobState { /** * Specifies the configuration parameters for the SQL job. Changing this parameter * will create a new resource. Structure is documented below. */ conf?: pulumi.Input; /** * Specifies the database where the SQL is executed. This argument does * not need to be configured during database creation. Changing this parameter will create a new resource. */ databaseName?: pulumi.Input; /** * Job running duration (unit: millisecond). */ duration?: pulumi.Input; /** * Type of a job, Includes **DDL**, **DCL**, **IMPORT**, **EXPORT**, **QUERY**, **INSERT**, * **DATA_MIGRATION**, **UPDATE**, **DELETE**, **RESTART_QUEUE** and **SCALE_QUEUE**. */ jobType?: pulumi.Input; /** * User who submits a job. */ owner?: pulumi.Input; /** * Specifies queue which this job to be submitted belongs. * Changing this parameter will create a new resource. */ queueName?: pulumi.Input; /** * Specifies the region in which to create the DLI table resource. If omitted, * the provider-level region will be used. Changing this parameter will create a new resource. */ region?: pulumi.Input; /** * When the statement type is DDL, results of the DDL are displayed. */ rows?: pulumi.Input[]>[]>; /** * When the statement type is DDL, the column name and type of DDL are displayed. */ schemas?: pulumi.Input; }>[]>; /** * Specifies SQL statement that you want to execute. * Changing this parameter will create a new resource. */ sql?: pulumi.Input; /** * Time when a job is started, in RFC-3339 format. e.g. `2019-10-12T07:20:50.52Z` */ startTime?: pulumi.Input; /** * Status of a job, including **RUNNING**, **SCALING**, **LAUNCHING**, **FINISHED**, **FAILED**, * and **CANCELLED.** */ status?: pulumi.Input; /** * Specifies label of a Job. Changing this parameter will create a new resource. */ tags?: pulumi.Input<{ [key: string]: pulumi.Input; }>; } /** * The set of arguments for constructing a SqlJob resource. */ export interface SqlJobArgs { /** * Specifies the configuration parameters for the SQL job. Changing this parameter * will create a new resource. Structure is documented below. */ conf?: pulumi.Input; /** * Specifies the database where the SQL is executed. This argument does * not need to be configured during database creation. Changing this parameter will create a new resource. */ databaseName?: pulumi.Input; /** * Specifies queue which this job to be submitted belongs. * Changing this parameter will create a new resource. */ queueName?: pulumi.Input; /** * Specifies the region in which to create the DLI table resource. If omitted, * the provider-level region will be used. Changing this parameter will create a new resource. */ region?: pulumi.Input; /** * Specifies SQL statement that you want to execute. * Changing this parameter will create a new resource. */ sql: pulumi.Input; /** * Specifies label of a Job. Changing this parameter will create a new resource. */ tags?: pulumi.Input<{ [key: string]: pulumi.Input; }>; }