![]() |
![]()
| ![]() |
![]()
NAMEPaws::RedshiftData::ExecuteStatement - Arguments for method ExecuteStatement on Paws::RedshiftData DESCRIPTIONThis class represents the parameters used for calling the method ExecuteStatement on the Redshift Data API Service service. Use the attributes of this class as arguments to method ExecuteStatement. You shouldn't make instances of this class. Each attribute should be used as a named argument in the call to ExecuteStatement. SYNOPSISmy $redshift-data = Paws->service('RedshiftData'); my $ExecuteStatementOutput = $redshift -data->ExecuteStatement( ClusterIdentifier => 'MyLocation', Sql => 'MyStatementString', Database => 'MyString', # OPTIONAL DbUser => 'MyString', # OPTIONAL Parameters => [ { Name => 'MyParameterName', Value => 'MyParameterValue', # min: 1 }, ... ], # OPTIONAL SecretArn => 'MySecretArn', # OPTIONAL StatementName => 'MyStatementNameString', # OPTIONAL WithEvent => 1, # OPTIONAL ); # Results: my $ClusterIdentifier = $ExecuteStatementOutput->ClusterIdentifier; my $CreatedAt = $ExecuteStatementOutput->CreatedAt; my $Database = $ExecuteStatementOutput->Database; my $DbUser = $ExecuteStatementOutput->DbUser; my $Id = $ExecuteStatementOutput->Id; my $SecretArn = $ExecuteStatementOutput->SecretArn; # Returns a L<Paws::RedshiftData::ExecuteStatementOutput> object. Values for attributes that are native types (Int, String, Float, etc) can passed as-is (scalar values). Values for complex Types (objects) can be passed as a HashRef. The keys and values of the hashref will be used to instance the underlying object. For the AWS API documentation, see <https://docs.aws.amazon.com/goto/WebAPI/redshift-data/ExecuteStatement> ATTRIBUTESREQUIRED ClusterIdentifier => StrThe cluster identifier. This parameter is required when authenticating using either AWS Secrets Manager or temporary credentials. Database => StrThe name of the database. This parameter is required when authenticating using temporary credentials. DbUser => StrThe database user name. This parameter is required when authenticating using temporary credentials. Parameters => ArrayRef[Paws::RedshiftData::SqlParameter]The parameters for the SQL statement. SecretArn => StrThe name or ARN of the secret that enables access to the database. This parameter is required when authenticating using AWS Secrets Manager. REQUIRED Sql => StrThe SQL statement text to run. StatementName => StrThe name of the SQL statement. You can name the SQL statement when you create it to identify the query. WithEvent => BoolA value that indicates whether to send an event to the Amazon EventBridge event bus after the SQL statement runs. SEE ALSOThis class forms part of Paws, documenting arguments for method ExecuteStatement in Paws::RedshiftData BUGS and CONTRIBUTIONSThe source code is located here: <https://github.com/pplu/aws-sdk-perl> Please report bugs to: <https://github.com/pplu/aws-sdk-perl/issues>
|