snowflake.Execute

!> Warning This is a dangerous resource that allows executing ANY SQL statement. It may destroy resources if used incorrectly. It may behave incorrectly combined with other resources. Use at your own risk.

!> Warning Do not run USE ROLE ... or USE WAREHOUSE ... statements as they will cause the provider to produce inconsistent results. Use provider aliases with different roles instead.

!> Sensitive values This resource’s execute, query, revert and query_results fields are not marked as sensitive in the provider. Ensure that no personal data, sensitive data, export-controlled data, or other regulated data is entered as metadata when using the provider. If you use one of these fields, they may be present in logs, so ensure that the provider logs are properly restricted. For more information, see Sensitive values limitations and Metadata fields in Snowflake.

Note It can be theoretically used to manage resource that are not supported by the provider. This is risky and may break other resources if used incorrectly.

Note Use query parameter with caution. It will fetch ALL the results returned by the query provided. Try to limit the number of results by writing query with filters. Query failure does not stop resource creation; it simply results in query_results being empty.

Note: Default timeout is set to 60 minutes for each Terraform operation.

Resource allowing execution of ANY SQL statement.

Create Execute Resource

Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

Constructor syntax

new Execute(name: string, args: ExecuteArgs, opts?: CustomResourceOptions);

@overload
def Execute(resource_name: str,
            args: ExecuteArgs,
            opts: Optional[ResourceOptions] = None)

@overload
def Execute(resource_name: str,
            opts: Optional[ResourceOptions] = None,
            execute: Optional[str] = None,
            revert: Optional[str] = None,
            query: Optional[str] = None)

func NewExecute(ctx *Context, name string, args ExecuteArgs, opts ...ResourceOption) (*Execute, error)

public Execute(string name, ExecuteArgs args, CustomResourceOptions? opts = null)

public Execute(String name, ExecuteArgs args)
public Execute(String name, ExecuteArgs args, CustomResourceOptions options)

type: snowflake:Execute
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

Constructor example

The following reference example uses placeholder values for all input properties.

var executeResource = new Snowflake.Execute("executeResource", new()
{
    ExecuteSQL = "string",
    Revert = "string",
    Query = "string",
});

example, err := snowflake.NewExecute(ctx, "executeResource", &snowflake.ExecuteArgs{
	Execute: pulumi.String("string"),
	Revert:  pulumi.String("string"),
	Query:   pulumi.String("string"),
})

var executeResource = new Execute("executeResource", ExecuteArgs.builder()
    .execute("string")
    .revert("string")
    .query("string")
    .build());

execute_resource = snowflake.Execute("executeResource",
    execute="string",
    revert="string",
    query="string")

const executeResource = new snowflake.Execute("executeResource", {
    execute: "string",
    revert: "string",
    query: "string",
});

type: snowflake:Execute
properties:
    execute: string
    query: string
    revert: string

Execute Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The Execute resource accepts the following input properties:

Outputs

All input properties are implicitly available as output properties. Additionally, the Execute resource produces the following output properties:

Look up Existing Execute Resource

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

public static get(name: string, id: Input<ID>, state?: ExecuteState, opts?: CustomResourceOptions): Execute

@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        execute: Optional[str] = None,
        query: Optional[str] = None,
        query_results: Optional[Sequence[Mapping[str, str]]] = None,
        revert: Optional[str] = None) -> Execute

func GetExecute(ctx *Context, name string, id IDInput, state *ExecuteState, opts ...ResourceOption) (*Execute, error)

public static Execute Get(string name, Input<string> id, ExecuteState? state, CustomResourceOptions? opts = null)

public static Execute get(String name, Output<String> id, ExecuteState state, CustomResourceOptions options)

resources:  _:    type: snowflake:Execute    get:      id: ${id}

Import

$ pulumi import snowflake:index/execute:Execute example '<random_uuid>'

To learn more about importing existing cloud resources, see Importing resources.

Package Details

Repository

Snowflake pulumi/pulumi-snowflake

License

Apache-2.0

Notes

This Pulumi package is based on the snowflake Terraform Provider.