Statement class

Executes a Redshift Data Statement.

Example Usage

clusterIdentifier

import * as pulumi from "@pulumi/pulumi";
import * as aws from "@pulumi/aws";

const example = new aws.redshiftdata.Statement("example", {
    clusterIdentifier: exampleAwsRedshiftCluster.clusterIdentifier,
    database: exampleAwsRedshiftCluster.databaseName,
    dbUser: exampleAwsRedshiftCluster.masterUsername,
    sql: "CREATE GROUP group_name;",
});

import pulumi
import pulumi_aws as aws

example = aws.redshiftdata.Statement("example",
    cluster_identifier=example_aws_redshift_cluster["clusterIdentifier"],
    database=example_aws_redshift_cluster["databaseName"],
    db_user=example_aws_redshift_cluster["masterUsername"],
    sql="CREATE GROUP group_name;")

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aws = Pulumi.Aws;

return await Deployment.RunAsync(() =>
{
    var example = new Aws.RedshiftData.Statement("example", new()
    {
        ClusterIdentifier = exampleAwsRedshiftCluster.ClusterIdentifier,
        Database = exampleAwsRedshiftCluster.DatabaseName,
        DbUser = exampleAwsRedshiftCluster.MasterUsername,
        Sql = "CREATE GROUP group_name;",
    });

});

package main

import (
	"github.com/pulumi/pulumi-aws/sdk/v7/go/aws/redshiftdata"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := redshiftdata.NewStatement(ctx, "example", &redshiftdata.StatementArgs{
			ClusterIdentifier: pulumi.Any(exampleAwsRedshiftCluster.ClusterIdentifier),
			Database:          pulumi.Any(exampleAwsRedshiftCluster.DatabaseName),
			DbUser:            pulumi.Any(exampleAwsRedshiftCluster.MasterUsername),
			Sql:               pulumi.String("CREATE GROUP group_name;"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

pulumi {
  required_providers {
    aws = {
      source = "pulumi/aws"
    }
  }
}

resource "aws_redshiftdata_statement" "example" {
  cluster_identifier = exampleAwsRedshiftCluster.clusterIdentifier
  database           = exampleAwsRedshiftCluster.databaseName
  db_user            = exampleAwsRedshiftCluster.masterUsername
  sql                = "CREATE GROUP group_name;"
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aws.redshiftdata.Statement;
import com.pulumi.aws.redshiftdata.StatementArgs;
import java.util.ArrayList;
import java.util.Arrays;
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 example = new Statement("example", StatementArgs.builder()
            .clusterIdentifier(exampleAwsRedshiftCluster.clusterIdentifier())
            .database(exampleAwsRedshiftCluster.databaseName())
            .dbUser(exampleAwsRedshiftCluster.masterUsername())
            .sql("CREATE GROUP group_name;")
            .build());

    }
}

resources:
  example:
    type: aws:redshiftdata:Statement
    properties:
      clusterIdentifier: ${exampleAwsRedshiftCluster.clusterIdentifier}
      database: ${exampleAwsRedshiftCluster.databaseName}
      dbUser: ${exampleAwsRedshiftCluster.masterUsername}
      sql: CREATE GROUP group_name;

workgroupName

import * as pulumi from "@pulumi/pulumi";
import * as aws from "@pulumi/aws";

const example = new aws.redshiftdata.Statement("example", {
    workgroupName: exampleAwsRedshiftserverlessWorkgroup.workgroupName,
    database: "dev",
    sql: "CREATE GROUP group_name;",
});

import pulumi
import pulumi_aws as aws

example = aws.redshiftdata.Statement("example",
    workgroup_name=example_aws_redshiftserverless_workgroup["workgroupName"],
    database="dev",
    sql="CREATE GROUP group_name;")

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aws = Pulumi.Aws;

return await Deployment.RunAsync(() =>
{
    var example = new Aws.RedshiftData.Statement("example", new()
    {
        WorkgroupName = exampleAwsRedshiftserverlessWorkgroup.WorkgroupName,
        Database = "dev",
        Sql = "CREATE GROUP group_name;",
    });

});

package main

import (
	"github.com/pulumi/pulumi-aws/sdk/v7/go/aws/redshiftdata"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := redshiftdata.NewStatement(ctx, "example", &redshiftdata.StatementArgs{
			WorkgroupName: pulumi.Any(exampleAwsRedshiftserverlessWorkgroup.WorkgroupName),
			Database:      pulumi.String("dev"),
			Sql:           pulumi.String("CREATE GROUP group_name;"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

pulumi {
  required_providers {
    aws = {
      source = "pulumi/aws"
    }
  }
}

resource "aws_redshiftdata_statement" "example" {
  workgroup_name = exampleAwsRedshiftserverlessWorkgroup.workgroupName
  database       = "dev"
  sql            = "CREATE GROUP group_name;"
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aws.redshiftdata.Statement;
import com.pulumi.aws.redshiftdata.StatementArgs;
import java.util.ArrayList;
import java.util.Arrays;
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 example = new Statement("example", StatementArgs.builder()
            .workgroupName(exampleAwsRedshiftserverlessWorkgroup.workgroupName())
            .database("dev")
            .sql("CREATE GROUP group_name;")
            .build());

    }
}

resources:
  example:
    type: aws:redshiftdata:Statement
    properties:
      workgroupName: ${exampleAwsRedshiftserverlessWorkgroup.workgroupName}
      database: dev
      sql: CREATE GROUP group_name;

Import

Using pulumi import, import Redshift Data Statements using the id. For example:

$ pulumi import aws:redshiftdata/statement:Statement example example

Constructors

Statement(String name, {StatementArgs? args, CustomResourceOptions? options})
Creates a new Statement. name The Pulumi resource name. args Arguments used to configure this Statement. The set of arguments for Statement. options Resource options controlling this resource's behavior.
Statement.reference(String urn)
Creates a typed reference to an existing Statement resource.

Properties

childResources → Set<Resource>
finalinherited
clusterIdentifier ↔ Output<String?>
The cluster identifier. This parameter is required when connecting to a cluster and authenticating using either Secrets Manager or temporary credentials.
latefinal
completionSources ↔ Map<String, IOutputCompletionSource>
latefinalinherited
database ↔ Output<String>
The name of the database.
latefinal
dbUser ↔ Output<String?>
The database user name.
latefinal
hashCode → int
The hash code for this object.
no setterinherited
id ↔ Output<String>
getter/setter pairinherited
isCustom → bool
Returns whether this resource is provider-managed.
no setterinherited
isProtected → bool
Returns whether this resource is protected from deletion.
no setterinherited
isRemote → bool
Whether this resource is registered as remote.
no setterinherited
isResourceReference → bool
Whether this instance represents a resource value returned over RPC.
finalinherited
parameters ↔ Output<List<StatementParameter>?>
latefinal
region ↔ Output<String>
Region where this resource will be managed. Defaults to the Region set in the provider configuration.
latefinal
resourceTransforms → List<ResourceTransform>
Inherited/explicit async transforms.
no setterinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
secretArn ↔ Output<String?>
The name or ARN of the secret that enables access to the database.
latefinal
sql ↔ Output<String>
The SQL statement text to run.
latefinal
statementName ↔ Output<String?>
The name of the SQL statement. You can name the SQL statement when you create it to identify the query.
latefinal
transformations → List<ResourceTransformation>
Inherited/explicit legacy transformations.
no setterinherited
urn ↔ Output<String>
latefinalinherited
withEvent ↔ Output<bool?>
A value that indicates whether to send an event to the Amazon EventBridge event bus after the SQL statement runs.
latefinal
workgroupName ↔ Output<String?>
The serverless workgroup name. This parameter is required when connecting to a serverless workgroup and authenticating using either Secrets Manager or temporary credentials.
latefinal

Methods

failId(Object error) → void
Completes this resource ID with an error when registration fails.
inherited
failOutputs(Object error) → void
Completes all output properties with error.
inherited
failUrn(Object error) → void
Completes this resource URN with an error when registration fails.
inherited
getProvider(String moduleMember) → ProviderResource?
Returns provider for moduleMember's package, if configured.
inherited
getResourceName() → String
Returns this resource's logical name.
inherited
getResourceType() → String
Returns this resource's Pulumi type token.
inherited
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
registerOutput<T>(String propertyName, {Object? decoder(Object?)?, bool isSecret = false}) → Output<T>
Registers a dynamic output property for this resource.
inherited
resolveId(String? value, {required bool isKnown}) → void
Resolves the provider-assigned ID for this resource.
inherited
resolveOutputs(Struct outputs) → void
Resolves all output properties from a monitor response payload.
inherited
resolveUrn(String value) → void
Resolves this resource's URN once assigned by the engine.
inherited
serializeProperties(Map<String, dynamic> properties) → Future<Struct>
Serializes resource properties for RPC transmission.
inherited
toString() → String
A string representation of this object.
inherited

Operators

operator ==(Object other) → bool
The equality operator.
inherited

Static Methods

get(String name, Input<String> id, {StatementState? state, CustomResourceOptions? options}) → Statement
Gets an existing Statement resource's state with the given name and id.