Docs Home
AWS v6.76.0 published on Tuesday, Apr 8, 2025 by Pulumi
aws.timestreamquery.ScheduledQuery
Explore with Pulumi AI
- Example Usage
- Basic Usage
- Multi-step Example
- Step 1. Create the prerequisite infrastructure
- Step 3. Create the scheduled query
- Create ScheduledQuery Resource
- Constructor syntax
- Constructor example
- ScheduledQuery Resource Properties
- Inputs
- Outputs
- Look up Existing ScheduledQuery Resource
- Supporting Types
- Import
- Package Details
Resource for managing an AWS Timestream Query Scheduled Query.
Example Usage
Basic Usage
Before creating a scheduled query, you must have a source database and table with ingested data. Below is a multi-step example, providing an opportunity for data ingestion.
If your infrastructure is already set up—including the source database and table with data, results database and table, error report S3 bucket, SNS topic, and IAM role—you can create a scheduled query as follows:
import * as pulumi from "@pulumi/pulumi";
import * as aws from "@pulumi/aws";
const example = new aws.timestreamquery.ScheduledQuery("example", {
executionRoleArn: exampleAwsIamRole.arn,
name: exampleAwsTimestreamwriteTable.tableName,
queryString: `SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
\x09ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
`,
errorReportConfiguration: {
s3Configuration: {
bucketName: exampleAwsS3Bucket.bucket,
},
},
notificationConfiguration: {
snsConfiguration: {
topicArn: exampleAwsSnsTopic.arn,
},
},
scheduleConfiguration: {
scheduleExpression: "rate(1 hour)",
},
targetConfiguration: {
timestreamConfiguration: {
databaseName: results.databaseName,
tableName: resultsAwsTimestreamwriteTable.tableName,
timeColumn: "binned_timestamp",
dimensionMappings: [
{
dimensionValueType: "VARCHAR",
name: "az",
},
{
dimensionValueType: "VARCHAR",
name: "region",
},
{
dimensionValueType: "VARCHAR",
name: "hostname",
},
],
multiMeasureMappings: {
targetMultiMeasureName: "multi-metrics",
multiMeasureAttributeMappings: [
{
measureValueType: "DOUBLE",
sourceColumn: "avg_cpu_utilization",
},
{
measureValueType: "DOUBLE",
sourceColumn: "p90_cpu_utilization",
},
{
measureValueType: "DOUBLE",
sourceColumn: "p95_cpu_utilization",
},
{
measureValueType: "DOUBLE",
sourceColumn: "p99_cpu_utilization",
},
],
},
},
},
});
import pulumi
import pulumi_aws as aws
example = aws.timestreamquery.ScheduledQuery("example",
execution_role_arn=example_aws_iam_role["arn"],
name=example_aws_timestreamwrite_table["tableName"],
query_string="""SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
\x09ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
""",
error_report_configuration={
"s3_configuration": {
"bucket_name": example_aws_s3_bucket["bucket"],
},
},
notification_configuration={
"sns_configuration": {
"topic_arn": example_aws_sns_topic["arn"],
},
},
schedule_configuration={
"schedule_expression": "rate(1 hour)",
},
target_configuration={
"timestream_configuration": {
"database_name": results["databaseName"],
"table_name": results_aws_timestreamwrite_table["tableName"],
"time_column": "binned_timestamp",
"dimension_mappings": [
{
"dimension_value_type": "VARCHAR",
"name": "az",
},
{
"dimension_value_type": "VARCHAR",
"name": "region",
},
{
"dimension_value_type": "VARCHAR",
"name": "hostname",
},
],
"multi_measure_mappings": {
"target_multi_measure_name": "multi-metrics",
"multi_measure_attribute_mappings": [
{
"measure_value_type": "DOUBLE",
"source_column": "avg_cpu_utilization",
},
{
"measure_value_type": "DOUBLE",
"source_column": "p90_cpu_utilization",
},
{
"measure_value_type": "DOUBLE",
"source_column": "p95_cpu_utilization",
},
{
"measure_value_type": "DOUBLE",
"source_column": "p99_cpu_utilization",
},
],
},
},
})
package main
import (
"github.com/pulumi/pulumi-aws/sdk/v6/go/aws/timestreamquery"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := timestreamquery.NewScheduledQuery(ctx, "example", ×treamquery.ScheduledQueryArgs{
ExecutionRoleArn: pulumi.Any(exampleAwsIamRole.Arn),
Name: pulumi.Any(exampleAwsTimestreamwriteTable.TableName),
QueryString: pulumi.String(`SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
`),
ErrorReportConfiguration: ×treamquery.ScheduledQueryErrorReportConfigurationArgs{
S3Configuration: ×treamquery.ScheduledQueryErrorReportConfigurationS3ConfigurationArgs{
BucketName: pulumi.Any(exampleAwsS3Bucket.Bucket),
},
},
NotificationConfiguration: ×treamquery.ScheduledQueryNotificationConfigurationArgs{
SnsConfiguration: ×treamquery.ScheduledQueryNotificationConfigurationSnsConfigurationArgs{
TopicArn: pulumi.Any(exampleAwsSnsTopic.Arn),
},
},
ScheduleConfiguration: ×treamquery.ScheduledQueryScheduleConfigurationArgs{
ScheduleExpression: pulumi.String("rate(1 hour)"),
},
TargetConfiguration: ×treamquery.ScheduledQueryTargetConfigurationArgs{
TimestreamConfiguration: ×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationArgs{
DatabaseName: pulumi.Any(results.DatabaseName),
TableName: pulumi.Any(resultsAwsTimestreamwriteTable.TableName),
TimeColumn: pulumi.String("binned_timestamp"),
DimensionMappings: timestreamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArray{
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs{
DimensionValueType: pulumi.String("VARCHAR"),
Name: pulumi.String("az"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs{
DimensionValueType: pulumi.String("VARCHAR"),
Name: pulumi.String("region"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs{
DimensionValueType: pulumi.String("VARCHAR"),
Name: pulumi.String("hostname"),
},
},
MultiMeasureMappings: ×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs{
TargetMultiMeasureName: pulumi.String("multi-metrics"),
MultiMeasureAttributeMappings: timestreamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArray{
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("DOUBLE"),
SourceColumn: pulumi.String("avg_cpu_utilization"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("DOUBLE"),
SourceColumn: pulumi.String("p90_cpu_utilization"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("DOUBLE"),
SourceColumn: pulumi.String("p95_cpu_utilization"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("DOUBLE"),
SourceColumn: pulumi.String("p99_cpu_utilization"),
},
},
},
},
},
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aws = Pulumi.Aws;
return await Deployment.RunAsync(() =>
{
var example = new Aws.TimestreamQuery.ScheduledQuery("example", new()
{
ExecutionRoleArn = exampleAwsIamRole.Arn,
Name = exampleAwsTimestreamwriteTable.TableName,
QueryString = @"SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
",
ErrorReportConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryErrorReportConfigurationArgs
{
S3Configuration = new Aws.TimestreamQuery.Inputs.ScheduledQueryErrorReportConfigurationS3ConfigurationArgs
{
BucketName = exampleAwsS3Bucket.Bucket,
},
},
NotificationConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryNotificationConfigurationArgs
{
SnsConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryNotificationConfigurationSnsConfigurationArgs
{
TopicArn = exampleAwsSnsTopic.Arn,
},
},
ScheduleConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryScheduleConfigurationArgs
{
ScheduleExpression = "rate(1 hour)",
},
TargetConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationArgs
{
TimestreamConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationArgs
{
DatabaseName = results.DatabaseName,
TableName = resultsAwsTimestreamwriteTable.TableName,
TimeColumn = "binned_timestamp",
DimensionMappings = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs
{
DimensionValueType = "VARCHAR",
Name = "az",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs
{
DimensionValueType = "VARCHAR",
Name = "region",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs
{
DimensionValueType = "VARCHAR",
Name = "hostname",
},
},
MultiMeasureMappings = new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs
{
TargetMultiMeasureName = "multi-metrics",
MultiMeasureAttributeMappings = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
{
MeasureValueType = "DOUBLE",
SourceColumn = "avg_cpu_utilization",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
{
MeasureValueType = "DOUBLE",
SourceColumn = "p90_cpu_utilization",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
{
MeasureValueType = "DOUBLE",
SourceColumn = "p95_cpu_utilization",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
{
MeasureValueType = "DOUBLE",
SourceColumn = "p99_cpu_utilization",
},
},
},
},
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aws.timestreamquery.ScheduledQuery;
import com.pulumi.aws.timestreamquery.ScheduledQueryArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryErrorReportConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryErrorReportConfigurationS3ConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryNotificationConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryNotificationConfigurationSnsConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryScheduleConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryTargetConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs;
import java.util.List;
import java.util.ArrayList;
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 ScheduledQuery("example", ScheduledQueryArgs.builder()
.executionRoleArn(exampleAwsIamRole.arn())
.name(exampleAwsTimestreamwriteTable.tableName())
.queryString("""
SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
""")
.errorReportConfiguration(ScheduledQueryErrorReportConfigurationArgs.builder()
.s3Configuration(ScheduledQueryErrorReportConfigurationS3ConfigurationArgs.builder()
.bucketName(exampleAwsS3Bucket.bucket())
.build())
.build())
.notificationConfiguration(ScheduledQueryNotificationConfigurationArgs.builder()
.snsConfiguration(ScheduledQueryNotificationConfigurationSnsConfigurationArgs.builder()
.topicArn(exampleAwsSnsTopic.arn())
.build())
.build())
.scheduleConfiguration(ScheduledQueryScheduleConfigurationArgs.builder()
.scheduleExpression("rate(1 hour)")
.build())
.targetConfiguration(ScheduledQueryTargetConfigurationArgs.builder()
.timestreamConfiguration(ScheduledQueryTargetConfigurationTimestreamConfigurationArgs.builder()
.databaseName(results.databaseName())
.tableName(resultsAwsTimestreamwriteTable.tableName())
.timeColumn("binned_timestamp")
.dimensionMappings(
ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs.builder()
.dimensionValueType("VARCHAR")
.name("az")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs.builder()
.dimensionValueType("VARCHAR")
.name("region")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs.builder()
.dimensionValueType("VARCHAR")
.name("hostname")
.build())
.multiMeasureMappings(ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs.builder()
.targetMultiMeasureName("multi-metrics")
.multiMeasureAttributeMappings(
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs.builder()
.measureValueType("DOUBLE")
.sourceColumn("avg_cpu_utilization")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs.builder()
.measureValueType("DOUBLE")
.sourceColumn("p90_cpu_utilization")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs.builder()
.measureValueType("DOUBLE")
.sourceColumn("p95_cpu_utilization")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs.builder()
.measureValueType("DOUBLE")
.sourceColumn("p99_cpu_utilization")
.build())
.build())
.build())
.build())
.build());
}
}
resources:
example:
type: aws:timestreamquery:ScheduledQuery
properties:
executionRoleArn: ${exampleAwsIamRole.arn}
name: ${exampleAwsTimestreamwriteTable.tableName}
queryString: |
SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
errorReportConfiguration:
s3Configuration:
bucketName: ${exampleAwsS3Bucket.bucket}
notificationConfiguration:
snsConfiguration:
topicArn: ${exampleAwsSnsTopic.arn}
scheduleConfiguration:
scheduleExpression: rate(1 hour)
targetConfiguration:
timestreamConfiguration:
databaseName: ${results.databaseName}
tableName: ${resultsAwsTimestreamwriteTable.tableName}
timeColumn: binned_timestamp
dimensionMappings:
- dimensionValueType: VARCHAR
name: az
- dimensionValueType: VARCHAR
name: region
- dimensionValueType: VARCHAR
name: hostname
multiMeasureMappings:
targetMultiMeasureName: multi-metrics
multiMeasureAttributeMappings:
- measureValueType: DOUBLE
sourceColumn: avg_cpu_utilization
- measureValueType: DOUBLE
sourceColumn: p90_cpu_utilization
- measureValueType: DOUBLE
sourceColumn: p95_cpu_utilization
- measureValueType: DOUBLE
sourceColumn: p99_cpu_utilization
Multi-step Example
To ingest data before creating a scheduled query, this example provides multiple steps:
- Create the prerequisite infrastructure
- Ingest data
- Create the scheduled query
Step 1. Create the prerequisite infrastructure
import * as pulumi from "@pulumi/pulumi";
import * as aws from "@pulumi/aws";
const test = new aws.s3.BucketV2("test", {
bucket: "example",
forceDestroy: true,
});
const testTopic = new aws.sns.Topic("test", {name: "example"});
const testQueue = new aws.sqs.Queue("test", {
name: "example",
sqsManagedSseEnabled: true,
});
const testTopicSubscription = new aws.sns.TopicSubscription("test", {
topic: testTopic.arn,
protocol: "sqs",
endpoint: testQueue.arn,
});
const testQueuePolicy = new aws.sqs.QueuePolicy("test", {
queueUrl: testQueue.id,
policy: pulumi.jsonStringify({
Version: "2012-10-17",
Statement: [{
Effect: "Allow",
Principal: {
AWS: "*",
},
Action: ["sqs:SendMessage"],
Resource: testQueue.arn,
Condition: {
ArnEquals: {
"aws:SourceArn": testTopic.arn,
},
},
}],
}),
});
const testRole = new aws.iam.Role("test", {
name: "example",
assumeRolePolicy: JSON.stringify({
Version: "2012-10-17",
Statement: [{
Effect: "Allow",
Principal: {
Service: "timestream.amazonaws.com",
},
Action: "sts:AssumeRole",
}],
}),
tags: {
Name: "example",
},
});
const testRolePolicy = new aws.iam.RolePolicy("test", {
name: "example",
role: testRole.id,
policy: JSON.stringify({
Version: "2012-10-17",
Statement: [{
Action: [
"kms:Decrypt",
"sns:Publish",
"timestream:describeEndpoints",
"timestream:Select",
"timestream:SelectValues",
"timestream:WriteRecords",
"s3:PutObject",
],
Resource: "*",
Effect: "Allow",
}],
}),
});
const testDatabase = new aws.timestreamwrite.Database("test", {databaseName: "exampledatabase"});
const testTable = new aws.timestreamwrite.Table("test", {
databaseName: testDatabase.databaseName,
tableName: "exampletable",
magneticStoreWriteProperties: {
enableMagneticStoreWrites: true,
},
retentionProperties: {
magneticStoreRetentionPeriodInDays: 1,
memoryStoreRetentionPeriodInHours: 1,
},
});
const results = new aws.timestreamwrite.Database("results", {databaseName: "exampledatabase-results"});
const resultsTable = new aws.timestreamwrite.Table("results", {
databaseName: results.databaseName,
tableName: "exampletable-results",
magneticStoreWriteProperties: {
enableMagneticStoreWrites: true,
},
retentionProperties: {
magneticStoreRetentionPeriodInDays: 1,
memoryStoreRetentionPeriodInHours: 1,
},
});
import pulumi
import json
import pulumi_aws as aws
test = aws.s3.BucketV2("test",
bucket="example",
force_destroy=True)
test_topic = aws.sns.Topic("test", name="example")
test_queue = aws.sqs.Queue("test",
name="example",
sqs_managed_sse_enabled=True)
test_topic_subscription = aws.sns.TopicSubscription("test",
topic=test_topic.arn,
protocol="sqs",
endpoint=test_queue.arn)
test_queue_policy = aws.sqs.QueuePolicy("test",
queue_url=test_queue.id,
policy=pulumi.Output.json_dumps({
"Version": "2012-10-17",
"Statement": [{
"Effect": "Allow",
"Principal": {
"AWS": "*",
},
"Action": ["sqs:SendMessage"],
"Resource": test_queue.arn,
"Condition": {
"ArnEquals": {
"aws:SourceArn": test_topic.arn,
},
},
}],
}))
test_role = aws.iam.Role("test",
name="example",
assume_role_policy=json.dumps({
"Version": "2012-10-17",
"Statement": [{
"Effect": "Allow",
"Principal": {
"Service": "timestream.amazonaws.com",
},
"Action": "sts:AssumeRole",
}],
}),
tags={
"Name": "example",
})
test_role_policy = aws.iam.RolePolicy("test",
name="example",
role=test_role.id,
policy=json.dumps({
"Version": "2012-10-17",
"Statement": [{
"Action": [
"kms:Decrypt",
"sns:Publish",
"timestream:describeEndpoints",
"timestream:Select",
"timestream:SelectValues",
"timestream:WriteRecords",
"s3:PutObject",
],
"Resource": "*",
"Effect": "Allow",
}],
}))
test_database = aws.timestreamwrite.Database("test", database_name="exampledatabase")
test_table = aws.timestreamwrite.Table("test",
database_name=test_database.database_name,
table_name="exampletable",
magnetic_store_write_properties={
"enable_magnetic_store_writes": True,
},
retention_properties={
"magnetic_store_retention_period_in_days": 1,
"memory_store_retention_period_in_hours": 1,
})
results = aws.timestreamwrite.Database("results", database_name="exampledatabase-results")
results_table = aws.timestreamwrite.Table("results",
database_name=results.database_name,
table_name="exampletable-results",
magnetic_store_write_properties={
"enable_magnetic_store_writes": True,
},
retention_properties={
"magnetic_store_retention_period_in_days": 1,
"memory_store_retention_period_in_hours": 1,
})
package main
import (
"encoding/json"
"github.com/pulumi/pulumi-aws/sdk/v6/go/aws/iam"
"github.com/pulumi/pulumi-aws/sdk/v6/go/aws/s3"
"github.com/pulumi/pulumi-aws/sdk/v6/go/aws/sns"
"github.com/pulumi/pulumi-aws/sdk/v6/go/aws/sqs"
"github.com/pulumi/pulumi-aws/sdk/v6/go/aws/timestreamwrite"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := s3.NewBucketV2(ctx, "test", &s3.BucketV2Args{
Bucket: pulumi.String("example"),
ForceDestroy: pulumi.Bool(true),
})
if err != nil {
return err
}
testTopic, err := sns.NewTopic(ctx, "test", &sns.TopicArgs{
Name: pulumi.String("example"),
})
if err != nil {
return err
}
testQueue, err := sqs.NewQueue(ctx, "test", &sqs.QueueArgs{
Name: pulumi.String("example"),
SqsManagedSseEnabled: pulumi.Bool(true),
})
if err != nil {
return err
}
_, err = sns.NewTopicSubscription(ctx, "test", &sns.TopicSubscriptionArgs{
Topic: testTopic.Arn,
Protocol: pulumi.String("sqs"),
Endpoint: testQueue.Arn,
})
if err != nil {
return err
}
_, err = sqs.NewQueuePolicy(ctx, "test", &sqs.QueuePolicyArgs{
QueueUrl: testQueue.ID(),
Policy: pulumi.All(testQueue.Arn, testTopic.Arn).ApplyT(func(_args []interface{}) (string, error) {
testQueueArn := _args[0].(string)
testTopicArn := _args[1].(string)
var _zero string
tmpJSON0, err := json.Marshal(map[string]interface{}{
"Version": "2012-10-17",
"Statement": []map[string]interface{}{
map[string]interface{}{
"Effect": "Allow",
"Principal": map[string]interface{}{
"AWS": "*",
},
"Action": []string{
"sqs:SendMessage",
},
"Resource": testQueueArn,
"Condition": map[string]interface{}{
"ArnEquals": map[string]interface{}{
"aws:SourceArn": testTopicArn,
},
},
},
},
})
if err != nil {
return _zero, err
}
json0 := string(tmpJSON0)
return json0, nil
}).(pulumi.StringOutput),
})
if err != nil {
return err
}
tmpJSON1, err := json.Marshal(map[string]interface{}{
"Version": "2012-10-17",
"Statement": []map[string]interface{}{
map[string]interface{}{
"Effect": "Allow",
"Principal": map[string]interface{}{
"Service": "timestream.amazonaws.com",
},
"Action": "sts:AssumeRole",
},
},
})
if err != nil {
return err
}
json1 := string(tmpJSON1)
testRole, err := iam.NewRole(ctx, "test", &iam.RoleArgs{
Name: pulumi.String("example"),
AssumeRolePolicy: pulumi.String(json1),
Tags: pulumi.StringMap{
"Name": pulumi.String("example"),
},
})
if err != nil {
return err
}
tmpJSON2, err := json.Marshal(map[string]interface{}{
"Version": "2012-10-17",
"Statement": []map[string]interface{}{
map[string]interface{}{
"Action": []string{
"kms:Decrypt",
"sns:Publish",
"timestream:describeEndpoints",
"timestream:Select",
"timestream:SelectValues",
"timestream:WriteRecords",
"s3:PutObject",
},
"Resource": "*",
"Effect": "Allow",
},
},
})
if err != nil {
return err
}
json2 := string(tmpJSON2)
_, err = iam.NewRolePolicy(ctx, "test", &iam.RolePolicyArgs{
Name: pulumi.String("example"),
Role: testRole.ID(),
Policy: pulumi.String(json2),
})
if err != nil {
return err
}
testDatabase, err := timestreamwrite.NewDatabase(ctx, "test", ×treamwrite.DatabaseArgs{
DatabaseName: pulumi.String("exampledatabase"),
})
if err != nil {
return err
}
_, err = timestreamwrite.NewTable(ctx, "test", ×treamwrite.TableArgs{
DatabaseName: testDatabase.DatabaseName,
TableName: pulumi.String("exampletable"),
MagneticStoreWriteProperties: ×treamwrite.TableMagneticStoreWritePropertiesArgs{
EnableMagneticStoreWrites: pulumi.Bool(true),
},
RetentionProperties: ×treamwrite.TableRetentionPropertiesArgs{
MagneticStoreRetentionPeriodInDays: pulumi.Int(1),
MemoryStoreRetentionPeriodInHours: pulumi.Int(1),
},
})
if err != nil {
return err
}
results, err := timestreamwrite.NewDatabase(ctx, "results", ×treamwrite.DatabaseArgs{
DatabaseName: pulumi.String("exampledatabase-results"),
})
if err != nil {
return err
}
_, err = timestreamwrite.NewTable(ctx, "results", ×treamwrite.TableArgs{
DatabaseName: results.DatabaseName,
TableName: pulumi.String("exampletable-results"),
MagneticStoreWriteProperties: ×treamwrite.TableMagneticStoreWritePropertiesArgs{
EnableMagneticStoreWrites: pulumi.Bool(true),
},
RetentionProperties: ×treamwrite.TableRetentionPropertiesArgs{
MagneticStoreRetentionPeriodInDays: pulumi.Int(1),
MemoryStoreRetentionPeriodInHours: pulumi.Int(1),
},
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using System.Text.Json;
using Pulumi;
using Aws = Pulumi.Aws;
return await Deployment.RunAsync(() =>
{
var test = new Aws.S3.BucketV2("test", new()
{
Bucket = "example",
ForceDestroy = true,
});
var testTopic = new Aws.Sns.Topic("test", new()
{
Name = "example",
});
var testQueue = new Aws.Sqs.Queue("test", new()
{
Name = "example",
SqsManagedSseEnabled = true,
});
var testTopicSubscription = new Aws.Sns.TopicSubscription("test", new()
{
Topic = testTopic.Arn,
Protocol = "sqs",
Endpoint = testQueue.Arn,
});
var testQueuePolicy = new Aws.Sqs.QueuePolicy("test", new()
{
QueueUrl = testQueue.Id,
Policy = Output.JsonSerialize(Output.Create(new Dictionary<string, object?>
{
["Version"] = "2012-10-17",
["Statement"] = new[]
{
new Dictionary<string, object?>
{
["Effect"] = "Allow",
["Principal"] = new Dictionary<string, object?>
{
["AWS"] = "*",
},
["Action"] = new[]
{
"sqs:SendMessage",
},
["Resource"] = testQueue.Arn,
["Condition"] = new Dictionary<string, object?>
{
["ArnEquals"] = new Dictionary<string, object?>
{
["aws:SourceArn"] = testTopic.Arn,
},
},
},
},
})),
});
var testRole = new Aws.Iam.Role("test", new()
{
Name = "example",
AssumeRolePolicy = JsonSerializer.Serialize(new Dictionary<string, object?>
{
["Version"] = "2012-10-17",
["Statement"] = new[]
{
new Dictionary<string, object?>
{
["Effect"] = "Allow",
["Principal"] = new Dictionary<string, object?>
{
["Service"] = "timestream.amazonaws.com",
},
["Action"] = "sts:AssumeRole",
},
},
}),
Tags =
{
{ "Name", "example" },
},
});
var testRolePolicy = new Aws.Iam.RolePolicy("test", new()
{
Name = "example",
Role = testRole.Id,
Policy = JsonSerializer.Serialize(new Dictionary<string, object?>
{
["Version"] = "2012-10-17",
["Statement"] = new[]
{
new Dictionary<string, object?>
{
["Action"] = new[]
{
"kms:Decrypt",
"sns:Publish",
"timestream:describeEndpoints",
"timestream:Select",
"timestream:SelectValues",
"timestream:WriteRecords",
"s3:PutObject",
},
["Resource"] = "*",
["Effect"] = "Allow",
},
},
}),
});
var testDatabase = new Aws.TimestreamWrite.Database("test", new()
{
DatabaseName = "exampledatabase",
});
var testTable = new Aws.TimestreamWrite.Table("test", new()
{
DatabaseName = testDatabase.DatabaseName,
TableName = "exampletable",
MagneticStoreWriteProperties = new Aws.TimestreamWrite.Inputs.TableMagneticStoreWritePropertiesArgs
{
EnableMagneticStoreWrites = true,
},
RetentionProperties = new Aws.TimestreamWrite.Inputs.TableRetentionPropertiesArgs
{
MagneticStoreRetentionPeriodInDays = 1,
MemoryStoreRetentionPeriodInHours = 1,
},
});
var results = new Aws.TimestreamWrite.Database("results", new()
{
DatabaseName = "exampledatabase-results",
});
var resultsTable = new Aws.TimestreamWrite.Table("results", new()
{
DatabaseName = results.DatabaseName,
TableName = "exampletable-results",
MagneticStoreWriteProperties = new Aws.TimestreamWrite.Inputs.TableMagneticStoreWritePropertiesArgs
{
EnableMagneticStoreWrites = true,
},
RetentionProperties = new Aws.TimestreamWrite.Inputs.TableRetentionPropertiesArgs
{
MagneticStoreRetentionPeriodInDays = 1,
MemoryStoreRetentionPeriodInHours = 1,
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aws.s3.BucketV2;
import com.pulumi.aws.s3.BucketV2Args;
import com.pulumi.aws.sns.Topic;
import com.pulumi.aws.sns.TopicArgs;
import com.pulumi.aws.sqs.Queue;
import com.pulumi.aws.sqs.QueueArgs;
import com.pulumi.aws.sns.TopicSubscription;
import com.pulumi.aws.sns.TopicSubscriptionArgs;
import com.pulumi.aws.sqs.QueuePolicy;
import com.pulumi.aws.sqs.QueuePolicyArgs;
import com.pulumi.aws.iam.Role;
import com.pulumi.aws.iam.RoleArgs;
import com.pulumi.aws.iam.RolePolicy;
import com.pulumi.aws.iam.RolePolicyArgs;
import com.pulumi.aws.timestreamwrite.Database;
import com.pulumi.aws.timestreamwrite.DatabaseArgs;
import com.pulumi.aws.timestreamwrite.Table;
import com.pulumi.aws.timestreamwrite.TableArgs;
import com.pulumi.aws.timestreamwrite.inputs.TableMagneticStoreWritePropertiesArgs;
import com.pulumi.aws.timestreamwrite.inputs.TableRetentionPropertiesArgs;
import static com.pulumi.codegen.internal.Serialization.*;
import java.util.List;
import java.util.ArrayList;
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 test = new BucketV2("test", BucketV2Args.builder()
.bucket("example")
.forceDestroy(true)
.build());
var testTopic = new Topic("testTopic", TopicArgs.builder()
.name("example")
.build());
var testQueue = new Queue("testQueue", QueueArgs.builder()
.name("example")
.sqsManagedSseEnabled(true)
.build());
var testTopicSubscription = new TopicSubscription("testTopicSubscription", TopicSubscriptionArgs.builder()
.topic(testTopic.arn())
.protocol("sqs")
.endpoint(testQueue.arn())
.build());
var testQueuePolicy = new QueuePolicy("testQueuePolicy", QueuePolicyArgs.builder()
.queueUrl(testQueue.id())
.policy(Output.tuple(testQueue.arn(), testTopic.arn()).applyValue(values -> {
var testQueueArn = values.t1;
var testTopicArn = values.t2;
return serializeJson(
jsonObject(
jsonProperty("Version", "2012-10-17"),
jsonProperty("Statement", jsonArray(jsonObject(
jsonProperty("Effect", "Allow"),
jsonProperty("Principal", jsonObject(
jsonProperty("AWS", "*")
)),
jsonProperty("Action", jsonArray("sqs:SendMessage")),
jsonProperty("Resource", testQueueArn),
jsonProperty("Condition", jsonObject(
jsonProperty("ArnEquals", jsonObject(
jsonProperty("aws:SourceArn", testTopicArn)
))
))
)))
));
}))
.build());
var testRole = new Role("testRole", RoleArgs.builder()
.name("example")
.assumeRolePolicy(serializeJson(
jsonObject(
jsonProperty("Version", "2012-10-17"),
jsonProperty("Statement", jsonArray(jsonObject(
jsonProperty("Effect", "Allow"),
jsonProperty("Principal", jsonObject(
jsonProperty("Service", "timestream.amazonaws.com")
)),
jsonProperty("Action", "sts:AssumeRole")
)))
)))
.tags(Map.of("Name", "example"))
.build());
var testRolePolicy = new RolePolicy("testRolePolicy", RolePolicyArgs.builder()
.name("example")
.role(testRole.id())
.policy(serializeJson(
jsonObject(
jsonProperty("Version", "2012-10-17"),
jsonProperty("Statement", jsonArray(jsonObject(
jsonProperty("Action", jsonArray(
"kms:Decrypt",
"sns:Publish",
"timestream:describeEndpoints",
"timestream:Select",
"timestream:SelectValues",
"timestream:WriteRecords",
"s3:PutObject"
)),
jsonProperty("Resource", "*"),
jsonProperty("Effect", "Allow")
)))
)))
.build());
var testDatabase = new Database("testDatabase", DatabaseArgs.builder()
.databaseName("exampledatabase")
.build());
var testTable = new Table("testTable", TableArgs.builder()
.databaseName(testDatabase.databaseName())
.tableName("exampletable")
.magneticStoreWriteProperties(TableMagneticStoreWritePropertiesArgs.builder()
.enableMagneticStoreWrites(true)
.build())
.retentionProperties(TableRetentionPropertiesArgs.builder()
.magneticStoreRetentionPeriodInDays(1)
.memoryStoreRetentionPeriodInHours(1)
.build())
.build());
var results = new Database("results", DatabaseArgs.builder()
.databaseName("exampledatabase-results")
.build());
var resultsTable = new Table("resultsTable", TableArgs.builder()
.databaseName(results.databaseName())
.tableName("exampletable-results")
.magneticStoreWriteProperties(TableMagneticStoreWritePropertiesArgs.builder()
.enableMagneticStoreWrites(true)
.build())
.retentionProperties(TableRetentionPropertiesArgs.builder()
.magneticStoreRetentionPeriodInDays(1)
.memoryStoreRetentionPeriodInHours(1)
.build())
.build());
}
}
resources:
test:
type: aws:s3:BucketV2
properties:
bucket: example
forceDestroy: true
testTopic:
type: aws:sns:Topic
name: test
properties:
name: example
testQueue:
type: aws:sqs:Queue
name: test
properties:
name: example
sqsManagedSseEnabled: true
testTopicSubscription:
type: aws:sns:TopicSubscription
name: test
properties:
topic: ${testTopic.arn}
protocol: sqs
endpoint: ${testQueue.arn}
testQueuePolicy:
type: aws:sqs:QueuePolicy
name: test
properties:
queueUrl: ${testQueue.id}
policy:
fn::toJSON:
Version: 2012-10-17
Statement:
- Effect: Allow
Principal:
AWS: '*'
Action:
- sqs:SendMessage
Resource: ${testQueue.arn}
Condition:
ArnEquals:
aws:SourceArn: ${testTopic.arn}
testRole:
type: aws:iam:Role
name: test
properties:
name: example
assumeRolePolicy:
fn::toJSON:
Version: 2012-10-17
Statement:
- Effect: Allow
Principal:
Service: timestream.amazonaws.com
Action: sts:AssumeRole
tags:
Name: example
testRolePolicy:
type: aws:iam:RolePolicy
name: test
properties:
name: example
role: ${testRole.id}
policy:
fn::toJSON:
Version: 2012-10-17
Statement:
- Action:
- kms:Decrypt
- sns:Publish
- timestream:describeEndpoints
- timestream:Select
- timestream:SelectValues
- timestream:WriteRecords
- s3:PutObject
Resource: '*'
Effect: Allow
testDatabase:
type: aws:timestreamwrite:Database
name: test
properties:
databaseName: exampledatabase
testTable:
type: aws:timestreamwrite:Table
name: test
properties:
databaseName: ${testDatabase.databaseName}
tableName: exampletable
magneticStoreWriteProperties:
enableMagneticStoreWrites: true
retentionProperties:
magneticStoreRetentionPeriodInDays: 1
memoryStoreRetentionPeriodInHours: 1
results:
type: aws:timestreamwrite:Database
properties:
databaseName: exampledatabase-results
resultsTable:
type: aws:timestreamwrite:Table
name: results
properties:
databaseName: ${results.databaseName}
tableName: exampletable-results
magneticStoreWriteProperties:
enableMagneticStoreWrites: true
retentionProperties:
magneticStoreRetentionPeriodInDays: 1
memoryStoreRetentionPeriodInHours: 1
Step 2. Ingest data
This is done with Amazon Timestream Write WriteRecords.
Step 3. Create the scheduled query
import * as pulumi from "@pulumi/pulumi";
import * as aws from "@pulumi/aws";
const example = new aws.timestreamquery.ScheduledQuery("example", {
executionRoleArn: exampleAwsIamRole.arn,
name: exampleAwsTimestreamwriteTable.tableName,
queryString: `SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
\x09ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
`,
errorReportConfiguration: {
s3Configuration: {
bucketName: exampleAwsS3Bucket.bucket,
},
},
notificationConfiguration: {
snsConfiguration: {
topicArn: exampleAwsSnsTopic.arn,
},
},
scheduleConfiguration: {
scheduleExpression: "rate(1 hour)",
},
targetConfiguration: {
timestreamConfiguration: {
databaseName: results.databaseName,
tableName: resultsAwsTimestreamwriteTable.tableName,
timeColumn: "binned_timestamp",
dimensionMappings: [
{
dimensionValueType: "VARCHAR",
name: "az",
},
{
dimensionValueType: "VARCHAR",
name: "region",
},
{
dimensionValueType: "VARCHAR",
name: "hostname",
},
],
multiMeasureMappings: {
targetMultiMeasureName: "multi-metrics",
multiMeasureAttributeMappings: [
{
measureValueType: "DOUBLE",
sourceColumn: "avg_cpu_utilization",
},
{
measureValueType: "DOUBLE",
sourceColumn: "p90_cpu_utilization",
},
{
measureValueType: "DOUBLE",
sourceColumn: "p95_cpu_utilization",
},
{
measureValueType: "DOUBLE",
sourceColumn: "p99_cpu_utilization",
},
],
},
},
},
});
import pulumi
import pulumi_aws as aws
example = aws.timestreamquery.ScheduledQuery("example",
execution_role_arn=example_aws_iam_role["arn"],
name=example_aws_timestreamwrite_table["tableName"],
query_string="""SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
\x09ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
\x09ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
""",
error_report_configuration={
"s3_configuration": {
"bucket_name": example_aws_s3_bucket["bucket"],
},
},
notification_configuration={
"sns_configuration": {
"topic_arn": example_aws_sns_topic["arn"],
},
},
schedule_configuration={
"schedule_expression": "rate(1 hour)",
},
target_configuration={
"timestream_configuration": {
"database_name": results["databaseName"],
"table_name": results_aws_timestreamwrite_table["tableName"],
"time_column": "binned_timestamp",
"dimension_mappings": [
{
"dimension_value_type": "VARCHAR",
"name": "az",
},
{
"dimension_value_type": "VARCHAR",
"name": "region",
},
{
"dimension_value_type": "VARCHAR",
"name": "hostname",
},
],
"multi_measure_mappings": {
"target_multi_measure_name": "multi-metrics",
"multi_measure_attribute_mappings": [
{
"measure_value_type": "DOUBLE",
"source_column": "avg_cpu_utilization",
},
{
"measure_value_type": "DOUBLE",
"source_column": "p90_cpu_utilization",
},
{
"measure_value_type": "DOUBLE",
"source_column": "p95_cpu_utilization",
},
{
"measure_value_type": "DOUBLE",
"source_column": "p99_cpu_utilization",
},
],
},
},
})
package main
import (
"github.com/pulumi/pulumi-aws/sdk/v6/go/aws/timestreamquery"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := timestreamquery.NewScheduledQuery(ctx, "example", ×treamquery.ScheduledQueryArgs{
ExecutionRoleArn: pulumi.Any(exampleAwsIamRole.Arn),
Name: pulumi.Any(exampleAwsTimestreamwriteTable.TableName),
QueryString: pulumi.String(`SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
`),
ErrorReportConfiguration: ×treamquery.ScheduledQueryErrorReportConfigurationArgs{
S3Configuration: ×treamquery.ScheduledQueryErrorReportConfigurationS3ConfigurationArgs{
BucketName: pulumi.Any(exampleAwsS3Bucket.Bucket),
},
},
NotificationConfiguration: ×treamquery.ScheduledQueryNotificationConfigurationArgs{
SnsConfiguration: ×treamquery.ScheduledQueryNotificationConfigurationSnsConfigurationArgs{
TopicArn: pulumi.Any(exampleAwsSnsTopic.Arn),
},
},
ScheduleConfiguration: ×treamquery.ScheduledQueryScheduleConfigurationArgs{
ScheduleExpression: pulumi.String("rate(1 hour)"),
},
TargetConfiguration: ×treamquery.ScheduledQueryTargetConfigurationArgs{
TimestreamConfiguration: ×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationArgs{
DatabaseName: pulumi.Any(results.DatabaseName),
TableName: pulumi.Any(resultsAwsTimestreamwriteTable.TableName),
TimeColumn: pulumi.String("binned_timestamp"),
DimensionMappings: timestreamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArray{
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs{
DimensionValueType: pulumi.String("VARCHAR"),
Name: pulumi.String("az"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs{
DimensionValueType: pulumi.String("VARCHAR"),
Name: pulumi.String("region"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs{
DimensionValueType: pulumi.String("VARCHAR"),
Name: pulumi.String("hostname"),
},
},
MultiMeasureMappings: ×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs{
TargetMultiMeasureName: pulumi.String("multi-metrics"),
MultiMeasureAttributeMappings: timestreamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArray{
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("DOUBLE"),
SourceColumn: pulumi.String("avg_cpu_utilization"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("DOUBLE"),
SourceColumn: pulumi.String("p90_cpu_utilization"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("DOUBLE"),
SourceColumn: pulumi.String("p95_cpu_utilization"),
},
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("DOUBLE"),
SourceColumn: pulumi.String("p99_cpu_utilization"),
},
},
},
},
},
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aws = Pulumi.Aws;
return await Deployment.RunAsync(() =>
{
var example = new Aws.TimestreamQuery.ScheduledQuery("example", new()
{
ExecutionRoleArn = exampleAwsIamRole.Arn,
Name = exampleAwsTimestreamwriteTable.TableName,
QueryString = @"SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
",
ErrorReportConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryErrorReportConfigurationArgs
{
S3Configuration = new Aws.TimestreamQuery.Inputs.ScheduledQueryErrorReportConfigurationS3ConfigurationArgs
{
BucketName = exampleAwsS3Bucket.Bucket,
},
},
NotificationConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryNotificationConfigurationArgs
{
SnsConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryNotificationConfigurationSnsConfigurationArgs
{
TopicArn = exampleAwsSnsTopic.Arn,
},
},
ScheduleConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryScheduleConfigurationArgs
{
ScheduleExpression = "rate(1 hour)",
},
TargetConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationArgs
{
TimestreamConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationArgs
{
DatabaseName = results.DatabaseName,
TableName = resultsAwsTimestreamwriteTable.TableName,
TimeColumn = "binned_timestamp",
DimensionMappings = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs
{
DimensionValueType = "VARCHAR",
Name = "az",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs
{
DimensionValueType = "VARCHAR",
Name = "region",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs
{
DimensionValueType = "VARCHAR",
Name = "hostname",
},
},
MultiMeasureMappings = new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs
{
TargetMultiMeasureName = "multi-metrics",
MultiMeasureAttributeMappings = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
{
MeasureValueType = "DOUBLE",
SourceColumn = "avg_cpu_utilization",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
{
MeasureValueType = "DOUBLE",
SourceColumn = "p90_cpu_utilization",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
{
MeasureValueType = "DOUBLE",
SourceColumn = "p95_cpu_utilization",
},
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
{
MeasureValueType = "DOUBLE",
SourceColumn = "p99_cpu_utilization",
},
},
},
},
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aws.timestreamquery.ScheduledQuery;
import com.pulumi.aws.timestreamquery.ScheduledQueryArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryErrorReportConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryErrorReportConfigurationS3ConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryNotificationConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryNotificationConfigurationSnsConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryScheduleConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryTargetConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationArgs;
import com.pulumi.aws.timestreamquery.inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs;
import java.util.List;
import java.util.ArrayList;
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 ScheduledQuery("example", ScheduledQueryArgs.builder()
.executionRoleArn(exampleAwsIamRole.arn())
.name(exampleAwsTimestreamwriteTable.tableName())
.queryString("""
SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
""")
.errorReportConfiguration(ScheduledQueryErrorReportConfigurationArgs.builder()
.s3Configuration(ScheduledQueryErrorReportConfigurationS3ConfigurationArgs.builder()
.bucketName(exampleAwsS3Bucket.bucket())
.build())
.build())
.notificationConfiguration(ScheduledQueryNotificationConfigurationArgs.builder()
.snsConfiguration(ScheduledQueryNotificationConfigurationSnsConfigurationArgs.builder()
.topicArn(exampleAwsSnsTopic.arn())
.build())
.build())
.scheduleConfiguration(ScheduledQueryScheduleConfigurationArgs.builder()
.scheduleExpression("rate(1 hour)")
.build())
.targetConfiguration(ScheduledQueryTargetConfigurationArgs.builder()
.timestreamConfiguration(ScheduledQueryTargetConfigurationTimestreamConfigurationArgs.builder()
.databaseName(results.databaseName())
.tableName(resultsAwsTimestreamwriteTable.tableName())
.timeColumn("binned_timestamp")
.dimensionMappings(
ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs.builder()
.dimensionValueType("VARCHAR")
.name("az")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs.builder()
.dimensionValueType("VARCHAR")
.name("region")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs.builder()
.dimensionValueType("VARCHAR")
.name("hostname")
.build())
.multiMeasureMappings(ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs.builder()
.targetMultiMeasureName("multi-metrics")
.multiMeasureAttributeMappings(
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs.builder()
.measureValueType("DOUBLE")
.sourceColumn("avg_cpu_utilization")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs.builder()
.measureValueType("DOUBLE")
.sourceColumn("p90_cpu_utilization")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs.builder()
.measureValueType("DOUBLE")
.sourceColumn("p95_cpu_utilization")
.build(),
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs.builder()
.measureValueType("DOUBLE")
.sourceColumn("p99_cpu_utilization")
.build())
.build())
.build())
.build())
.build());
}
}
resources:
example:
type: aws:timestreamquery:ScheduledQuery
properties:
executionRoleArn: ${exampleAwsIamRole.arn}
name: ${exampleAwsTimestreamwriteTable.tableName}
queryString: |
SELECT region, az, hostname, BIN(time, 15s) AS binned_timestamp,
ROUND(AVG(cpu_utilization), 2) AS avg_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.9), 2) AS p90_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.95), 2) AS p95_cpu_utilization,
ROUND(APPROX_PERCENTILE(cpu_utilization, 0.99), 2) AS p99_cpu_utilization
FROM exampledatabase.exampletable
WHERE measure_name = 'metrics' AND time > ago(2h)
GROUP BY region, hostname, az, BIN(time, 15s)
ORDER BY binned_timestamp ASC
LIMIT 5
errorReportConfiguration:
s3Configuration:
bucketName: ${exampleAwsS3Bucket.bucket}
notificationConfiguration:
snsConfiguration:
topicArn: ${exampleAwsSnsTopic.arn}
scheduleConfiguration:
scheduleExpression: rate(1 hour)
targetConfiguration:
timestreamConfiguration:
databaseName: ${results.databaseName}
tableName: ${resultsAwsTimestreamwriteTable.tableName}
timeColumn: binned_timestamp
dimensionMappings:
- dimensionValueType: VARCHAR
name: az
- dimensionValueType: VARCHAR
name: region
- dimensionValueType: VARCHAR
name: hostname
multiMeasureMappings:
targetMultiMeasureName: multi-metrics
multiMeasureAttributeMappings:
- measureValueType: DOUBLE
sourceColumn: avg_cpu_utilization
- measureValueType: DOUBLE
sourceColumn: p90_cpu_utilization
- measureValueType: DOUBLE
sourceColumn: p95_cpu_utilization
- measureValueType: DOUBLE
sourceColumn: p99_cpu_utilization
Create ScheduledQuery Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new ScheduledQuery(name: string, args: ScheduledQueryArgs, opts?: CustomResourceOptions);@overload
def ScheduledQuery(resource_name: str,
args: ScheduledQueryArgs,
opts: Optional[ResourceOptions] = None)
@overload
def ScheduledQuery(resource_name: str,
opts: Optional[ResourceOptions] = None,
error_report_configuration: Optional[ScheduledQueryErrorReportConfigurationArgs] = None,
execution_role_arn: Optional[str] = None,
notification_configuration: Optional[ScheduledQueryNotificationConfigurationArgs] = None,
query_string: Optional[str] = None,
schedule_configuration: Optional[ScheduledQueryScheduleConfigurationArgs] = None,
target_configuration: Optional[ScheduledQueryTargetConfigurationArgs] = None,
kms_key_id: Optional[str] = None,
last_run_summaries: Optional[Sequence[ScheduledQueryLastRunSummaryArgs]] = None,
name: Optional[str] = None,
recently_failed_runs: Optional[Sequence[ScheduledQueryRecentlyFailedRunArgs]] = None,
tags: Optional[Mapping[str, str]] = None,
timeouts: Optional[ScheduledQueryTimeoutsArgs] = None)func NewScheduledQuery(ctx *Context, name string, args ScheduledQueryArgs, opts ...ResourceOption) (*ScheduledQuery, error)public ScheduledQuery(string name, ScheduledQueryArgs args, CustomResourceOptions? opts = null)public ScheduledQuery(String name, ScheduledQueryArgs args)
public ScheduledQuery(String name, ScheduledQueryArgs args, CustomResourceOptions options)
type: aws:timestreamquery:ScheduledQuery
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name
This property is required. string - The unique name of the resource.
- args
This property is required. ScheduledQueryArgs - The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name
This property is required. str - The unique name of the resource.
- args
This property is required. ScheduledQueryArgs - The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name
This property is required. string - The unique name of the resource.
- args
This property is required. ScheduledQueryArgs - The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name
This property is required. string - The unique name of the resource.
- args
This property is required. ScheduledQueryArgs - The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name
This property is required. String - The unique name of the resource.
- args
This property is required. ScheduledQueryArgs - The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var scheduledQueryResource = new Aws.TimestreamQuery.ScheduledQuery("scheduledQueryResource", new()
{
ErrorReportConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryErrorReportConfigurationArgs
{
S3Configuration = new Aws.TimestreamQuery.Inputs.ScheduledQueryErrorReportConfigurationS3ConfigurationArgs
{
BucketName = "string",
EncryptionOption = "string",
ObjectKeyPrefix = "string",
},
},
ExecutionRoleArn = "string",
NotificationConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryNotificationConfigurationArgs
{
SnsConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryNotificationConfigurationSnsConfigurationArgs
{
TopicArn = "string",
},
},
QueryString = "string",
ScheduleConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryScheduleConfigurationArgs
{
ScheduleExpression = "string",
},
TargetConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationArgs
{
TimestreamConfiguration = new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationArgs
{
DatabaseName = "string",
TableName = "string",
TimeColumn = "string",
DimensionMappings = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs
{
DimensionValueType = "string",
Name = "string",
},
},
MeasureNameColumn = "string",
MixedMeasureMappings = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingArgs
{
MeasureValueType = "string",
MeasureName = "string",
MultiMeasureAttributeMappings = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingMultiMeasureAttributeMappingArgs
{
MeasureValueType = "string",
SourceColumn = "string",
TargetMultiMeasureAttributeName = "string",
},
},
SourceColumn = "string",
TargetMeasureName = "string",
},
},
MultiMeasureMappings = new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs
{
MultiMeasureAttributeMappings = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
{
MeasureValueType = "string",
SourceColumn = "string",
TargetMultiMeasureAttributeName = "string",
},
},
TargetMultiMeasureName = "string",
},
},
},
KmsKeyId = "string",
LastRunSummaries = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryLastRunSummaryArgs
{
ErrorReportLocations = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryLastRunSummaryErrorReportLocationArgs
{
S3ReportLocations = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryLastRunSummaryErrorReportLocationS3ReportLocationArgs
{
BucketName = "string",
ObjectKey = "string",
},
},
},
},
ExecutionStats = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryLastRunSummaryExecutionStatArgs
{
BytesMetered = 0,
CumulativeBytesScanned = 0,
DataWrites = 0,
ExecutionTimeInMillis = 0,
QueryResultRows = 0,
RecordsIngested = 0,
},
},
FailureReason = "string",
InvocationTime = "string",
QueryInsightsResponses = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryLastRunSummaryQueryInsightsResponseArgs
{
OutputBytes = 0,
OutputRows = 0,
QuerySpatialCoverages = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageArgs
{
Maxes = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageMaxisArgs
{
PartitionKeys = new[]
{
"string",
},
TableArn = "string",
Value = 0,
},
},
},
},
QueryTableCount = 0,
QueryTemporalRanges = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeArgs
{
Maxes = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeMaxisArgs
{
TableArn = "string",
Value = 0,
},
},
},
},
},
},
RunStatus = "string",
TriggerTime = "string",
},
},
Name = "string",
RecentlyFailedRuns = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryRecentlyFailedRunArgs
{
ErrorReportLocations = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryRecentlyFailedRunErrorReportLocationArgs
{
S3ReportLocations = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryRecentlyFailedRunErrorReportLocationS3ReportLocationArgs
{
BucketName = "string",
ObjectKey = "string",
},
},
},
},
ExecutionStats = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryRecentlyFailedRunExecutionStatArgs
{
BytesMetered = 0,
CumulativeBytesScanned = 0,
DataWrites = 0,
ExecutionTimeInMillis = 0,
QueryResultRows = 0,
RecordsIngested = 0,
},
},
FailureReason = "string",
InvocationTime = "string",
QueryInsightsResponses = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryRecentlyFailedRunQueryInsightsResponseArgs
{
OutputBytes = 0,
OutputRows = 0,
QuerySpatialCoverages = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageArgs
{
Maxes = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageMaxisArgs
{
PartitionKeys = new[]
{
"string",
},
TableArn = "string",
Value = 0,
},
},
},
},
QueryTableCount = 0,
QueryTemporalRanges = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeArgs
{
Maxes = new[]
{
new Aws.TimestreamQuery.Inputs.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeMaxisArgs
{
TableArn = "string",
Value = 0,
},
},
},
},
},
},
RunStatus = "string",
TriggerTime = "string",
},
},
Tags =
{
{ "string", "string" },
},
Timeouts = new Aws.TimestreamQuery.Inputs.ScheduledQueryTimeoutsArgs
{
Create = "string",
Delete = "string",
Update = "string",
},
});
example, err := timestreamquery.NewScheduledQuery(ctx, "scheduledQueryResource", ×treamquery.ScheduledQueryArgs{
ErrorReportConfiguration: ×treamquery.ScheduledQueryErrorReportConfigurationArgs{
S3Configuration: ×treamquery.ScheduledQueryErrorReportConfigurationS3ConfigurationArgs{
BucketName: pulumi.String("string"),
EncryptionOption: pulumi.String("string"),
ObjectKeyPrefix: pulumi.String("string"),
},
},
ExecutionRoleArn: pulumi.String("string"),
NotificationConfiguration: ×treamquery.ScheduledQueryNotificationConfigurationArgs{
SnsConfiguration: ×treamquery.ScheduledQueryNotificationConfigurationSnsConfigurationArgs{
TopicArn: pulumi.String("string"),
},
},
QueryString: pulumi.String("string"),
ScheduleConfiguration: ×treamquery.ScheduledQueryScheduleConfigurationArgs{
ScheduleExpression: pulumi.String("string"),
},
TargetConfiguration: ×treamquery.ScheduledQueryTargetConfigurationArgs{
TimestreamConfiguration: ×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationArgs{
DatabaseName: pulumi.String("string"),
TableName: pulumi.String("string"),
TimeColumn: pulumi.String("string"),
DimensionMappings: timestreamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArray{
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs{
DimensionValueType: pulumi.String("string"),
Name: pulumi.String("string"),
},
},
MeasureNameColumn: pulumi.String("string"),
MixedMeasureMappings: timestreamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingArray{
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingArgs{
MeasureValueType: pulumi.String("string"),
MeasureName: pulumi.String("string"),
MultiMeasureAttributeMappings: timestreamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingMultiMeasureAttributeMappingArray{
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("string"),
SourceColumn: pulumi.String("string"),
TargetMultiMeasureAttributeName: pulumi.String("string"),
},
},
SourceColumn: pulumi.String("string"),
TargetMeasureName: pulumi.String("string"),
},
},
MultiMeasureMappings: ×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs{
MultiMeasureAttributeMappings: timestreamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArray{
×treamquery.ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs{
MeasureValueType: pulumi.String("string"),
SourceColumn: pulumi.String("string"),
TargetMultiMeasureAttributeName: pulumi.String("string"),
},
},
TargetMultiMeasureName: pulumi.String("string"),
},
},
},
KmsKeyId: pulumi.String("string"),
LastRunSummaries: timestreamquery.ScheduledQueryLastRunSummaryArray{
×treamquery.ScheduledQueryLastRunSummaryArgs{
ErrorReportLocations: timestreamquery.ScheduledQueryLastRunSummaryErrorReportLocationArray{
×treamquery.ScheduledQueryLastRunSummaryErrorReportLocationArgs{
S3ReportLocations: timestreamquery.ScheduledQueryLastRunSummaryErrorReportLocationS3ReportLocationArray{
×treamquery.ScheduledQueryLastRunSummaryErrorReportLocationS3ReportLocationArgs{
BucketName: pulumi.String("string"),
ObjectKey: pulumi.String("string"),
},
},
},
},
ExecutionStats: timestreamquery.ScheduledQueryLastRunSummaryExecutionStatArray{
×treamquery.ScheduledQueryLastRunSummaryExecutionStatArgs{
BytesMetered: pulumi.Int(0),
CumulativeBytesScanned: pulumi.Int(0),
DataWrites: pulumi.Int(0),
ExecutionTimeInMillis: pulumi.Int(0),
QueryResultRows: pulumi.Int(0),
RecordsIngested: pulumi.Int(0),
},
},
FailureReason: pulumi.String("string"),
InvocationTime: pulumi.String("string"),
QueryInsightsResponses: timestreamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseArray{
×treamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseArgs{
OutputBytes: pulumi.Int(0),
OutputRows: pulumi.Int(0),
QuerySpatialCoverages: timestreamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageArray{
×treamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageArgs{
Maxes: timestreamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageMaxisArray{
×treamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageMaxisArgs{
PartitionKeys: pulumi.StringArray{
pulumi.String("string"),
},
TableArn: pulumi.String("string"),
Value: pulumi.Float64(0),
},
},
},
},
QueryTableCount: pulumi.Int(0),
QueryTemporalRanges: timestreamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeArray{
×treamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeArgs{
Maxes: timestreamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeMaxisArray{
×treamquery.ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeMaxisArgs{
TableArn: pulumi.String("string"),
Value: pulumi.Int(0),
},
},
},
},
},
},
RunStatus: pulumi.String("string"),
TriggerTime: pulumi.String("string"),
},
},
Name: pulumi.String("string"),
RecentlyFailedRuns: timestreamquery.ScheduledQueryRecentlyFailedRunArray{
×treamquery.ScheduledQueryRecentlyFailedRunArgs{
ErrorReportLocations: timestreamquery.ScheduledQueryRecentlyFailedRunErrorReportLocationArray{
×treamquery.ScheduledQueryRecentlyFailedRunErrorReportLocationArgs{
S3ReportLocations: timestreamquery.ScheduledQueryRecentlyFailedRunErrorReportLocationS3ReportLocationArray{
×treamquery.ScheduledQueryRecentlyFailedRunErrorReportLocationS3ReportLocationArgs{
BucketName: pulumi.String("string"),
ObjectKey: pulumi.String("string"),
},
},
},
},
ExecutionStats: timestreamquery.ScheduledQueryRecentlyFailedRunExecutionStatArray{
×treamquery.ScheduledQueryRecentlyFailedRunExecutionStatArgs{
BytesMetered: pulumi.Int(0),
CumulativeBytesScanned: pulumi.Int(0),
DataWrites: pulumi.Int(0),
ExecutionTimeInMillis: pulumi.Int(0),
QueryResultRows: pulumi.Int(0),
RecordsIngested: pulumi.Int(0),
},
},
FailureReason: pulumi.String("string"),
InvocationTime: pulumi.String("string"),
QueryInsightsResponses: timestreamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseArray{
×treamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseArgs{
OutputBytes: pulumi.Int(0),
OutputRows: pulumi.Int(0),
QuerySpatialCoverages: timestreamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageArray{
×treamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageArgs{
Maxes: timestreamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageMaxisArray{
×treamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageMaxisArgs{
PartitionKeys: pulumi.StringArray{
pulumi.String("string"),
},
TableArn: pulumi.String("string"),
Value: pulumi.Float64(0),
},
},
},
},
QueryTableCount: pulumi.Int(0),
QueryTemporalRanges: timestreamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeArray{
×treamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeArgs{
Maxes: timestreamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeMaxisArray{
×treamquery.ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeMaxisArgs{
TableArn: pulumi.String("string"),
Value: pulumi.Int(0),
},
},
},
},
},
},
RunStatus: pulumi.String("string"),
TriggerTime: pulumi.String("string"),
},
},
Tags: pulumi.StringMap{
"string": pulumi.String("string"),
},
Timeouts: ×treamquery.ScheduledQueryTimeoutsArgs{
Create: pulumi.String("string"),
Delete: pulumi.String("string"),
Update: pulumi.String("string"),
},
})
var scheduledQueryResource = new ScheduledQuery("scheduledQueryResource", ScheduledQueryArgs.builder()
.errorReportConfiguration(ScheduledQueryErrorReportConfigurationArgs.builder()
.s3Configuration(ScheduledQueryErrorReportConfigurationS3ConfigurationArgs.builder()
.bucketName("string")
.encryptionOption("string")
.objectKeyPrefix("string")
.build())
.build())
.executionRoleArn("string")
.notificationConfiguration(ScheduledQueryNotificationConfigurationArgs.builder()
.snsConfiguration(ScheduledQueryNotificationConfigurationSnsConfigurationArgs.builder()
.topicArn("string")
.build())
.build())
.queryString("string")
.scheduleConfiguration(ScheduledQueryScheduleConfigurationArgs.builder()
.scheduleExpression("string")
.build())
.targetConfiguration(ScheduledQueryTargetConfigurationArgs.builder()
.timestreamConfiguration(ScheduledQueryTargetConfigurationTimestreamConfigurationArgs.builder()
.databaseName("string")
.tableName("string")
.timeColumn("string")
.dimensionMappings(ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs.builder()
.dimensionValueType("string")
.name("string")
.build())
.measureNameColumn("string")
.mixedMeasureMappings(ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingArgs.builder()
.measureValueType("string")
.measureName("string")
.multiMeasureAttributeMappings(ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingMultiMeasureAttributeMappingArgs.builder()
.measureValueType("string")
.sourceColumn("string")
.targetMultiMeasureAttributeName("string")
.build())
.sourceColumn("string")
.targetMeasureName("string")
.build())
.multiMeasureMappings(ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs.builder()
.multiMeasureAttributeMappings(ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs.builder()
.measureValueType("string")
.sourceColumn("string")
.targetMultiMeasureAttributeName("string")
.build())
.targetMultiMeasureName("string")
.build())
.build())
.build())
.kmsKeyId("string")
.lastRunSummaries(ScheduledQueryLastRunSummaryArgs.builder()
.errorReportLocations(ScheduledQueryLastRunSummaryErrorReportLocationArgs.builder()
.s3ReportLocations(ScheduledQueryLastRunSummaryErrorReportLocationS3ReportLocationArgs.builder()
.bucketName("string")
.objectKey("string")
.build())
.build())
.executionStats(ScheduledQueryLastRunSummaryExecutionStatArgs.builder()
.bytesMetered(0)
.cumulativeBytesScanned(0)
.dataWrites(0)
.executionTimeInMillis(0)
.queryResultRows(0)
.recordsIngested(0)
.build())
.failureReason("string")
.invocationTime("string")
.queryInsightsResponses(ScheduledQueryLastRunSummaryQueryInsightsResponseArgs.builder()
.outputBytes(0)
.outputRows(0)
.querySpatialCoverages(ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageArgs.builder()
.maxes(ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageMaxisArgs.builder()
.partitionKeys("string")
.tableArn("string")
.value(0)
.build())
.build())
.queryTableCount(0)
.queryTemporalRanges(ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeArgs.builder()
.maxes(ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeMaxisArgs.builder()
.tableArn("string")
.value(0)
.build())
.build())
.build())
.runStatus("string")
.triggerTime("string")
.build())
.name("string")
.recentlyFailedRuns(ScheduledQueryRecentlyFailedRunArgs.builder()
.errorReportLocations(ScheduledQueryRecentlyFailedRunErrorReportLocationArgs.builder()
.s3ReportLocations(ScheduledQueryRecentlyFailedRunErrorReportLocationS3ReportLocationArgs.builder()
.bucketName("string")
.objectKey("string")
.build())
.build())
.executionStats(ScheduledQueryRecentlyFailedRunExecutionStatArgs.builder()
.bytesMetered(0)
.cumulativeBytesScanned(0)
.dataWrites(0)
.executionTimeInMillis(0)
.queryResultRows(0)
.recordsIngested(0)
.build())
.failureReason("string")
.invocationTime("string")
.queryInsightsResponses(ScheduledQueryRecentlyFailedRunQueryInsightsResponseArgs.builder()
.outputBytes(0)
.outputRows(0)
.querySpatialCoverages(ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageArgs.builder()
.maxes(ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageMaxisArgs.builder()
.partitionKeys("string")
.tableArn("string")
.value(0)
.build())
.build())
.queryTableCount(0)
.queryTemporalRanges(ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeArgs.builder()
.maxes(ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeMaxisArgs.builder()
.tableArn("string")
.value(0)
.build())
.build())
.build())
.runStatus("string")
.triggerTime("string")
.build())
.tags(Map.of("string", "string"))
.timeouts(ScheduledQueryTimeoutsArgs.builder()
.create("string")
.delete("string")
.update("string")
.build())
.build());
scheduled_query_resource = aws.timestreamquery.ScheduledQuery("scheduledQueryResource",
error_report_configuration={
"s3_configuration": {
"bucket_name": "string",
"encryption_option": "string",
"object_key_prefix": "string",
},
},
execution_role_arn="string",
notification_configuration={
"sns_configuration": {
"topic_arn": "string",
},
},
query_string="string",
schedule_configuration={
"schedule_expression": "string",
},
target_configuration={
"timestream_configuration": {
"database_name": "string",
"table_name": "string",
"time_column": "string",
"dimension_mappings": [{
"dimension_value_type": "string",
"name": "string",
}],
"measure_name_column": "string",
"mixed_measure_mappings": [{
"measure_value_type": "string",
"measure_name": "string",
"multi_measure_attribute_mappings": [{
"measure_value_type": "string",
"source_column": "string",
"target_multi_measure_attribute_name": "string",
}],
"source_column": "string",
"target_measure_name": "string",
}],
"multi_measure_mappings": {
"multi_measure_attribute_mappings": [{
"measure_value_type": "string",
"source_column": "string",
"target_multi_measure_attribute_name": "string",
}],
"target_multi_measure_name": "string",
},
},
},
kms_key_id="string",
last_run_summaries=[{
"error_report_locations": [{
"s3_report_locations": [{
"bucket_name": "string",
"object_key": "string",
}],
}],
"execution_stats": [{
"bytes_metered": 0,
"cumulative_bytes_scanned": 0,
"data_writes": 0,
"execution_time_in_millis": 0,
"query_result_rows": 0,
"records_ingested": 0,
}],
"failure_reason": "string",
"invocation_time": "string",
"query_insights_responses": [{
"output_bytes": 0,
"output_rows": 0,
"query_spatial_coverages": [{
"maxes": [{
"partition_keys": ["string"],
"table_arn": "string",
"value": 0,
}],
}],
"query_table_count": 0,
"query_temporal_ranges": [{
"maxes": [{
"table_arn": "string",
"value": 0,
}],
}],
}],
"run_status": "string",
"trigger_time": "string",
}],
name="string",
recently_failed_runs=[{
"error_report_locations": [{
"s3_report_locations": [{
"bucket_name": "string",
"object_key": "string",
}],
}],
"execution_stats": [{
"bytes_metered": 0,
"cumulative_bytes_scanned": 0,
"data_writes": 0,
"execution_time_in_millis": 0,
"query_result_rows": 0,
"records_ingested": 0,
}],
"failure_reason": "string",
"invocation_time": "string",
"query_insights_responses": [{
"output_bytes": 0,
"output_rows": 0,
"query_spatial_coverages": [{
"maxes": [{
"partition_keys": ["string"],
"table_arn": "string",
"value": 0,
}],
}],
"query_table_count": 0,
"query_temporal_ranges": [{
"maxes": [{
"table_arn": "string",
"value": 0,
}],
}],
}],
"run_status": "string",
"trigger_time": "string",
}],
tags={
"string": "string",
},
timeouts={
"create": "string",
"delete": "string",
"update": "string",
})
const scheduledQueryResource = new aws.timestreamquery.ScheduledQuery("scheduledQueryResource", {
errorReportConfiguration: {
s3Configuration: {
bucketName: "string",
encryptionOption: "string",
objectKeyPrefix: "string",
},
},
executionRoleArn: "string",
notificationConfiguration: {
snsConfiguration: {
topicArn: "string",
},
},
queryString: "string",
scheduleConfiguration: {
scheduleExpression: "string",
},
targetConfiguration: {
timestreamConfiguration: {
databaseName: "string",
tableName: "string",
timeColumn: "string",
dimensionMappings: [{
dimensionValueType: "string",
name: "string",
}],
measureNameColumn: "string",
mixedMeasureMappings: [{
measureValueType: "string",
measureName: "string",
multiMeasureAttributeMappings: [{
measureValueType: "string",
sourceColumn: "string",
targetMultiMeasureAttributeName: "string",
}],
sourceColumn: "string",
targetMeasureName: "string",
}],
multiMeasureMappings: {
multiMeasureAttributeMappings: [{
measureValueType: "string",
sourceColumn: "string",
targetMultiMeasureAttributeName: "string",
}],
targetMultiMeasureName: "string",
},
},
},
kmsKeyId: "string",
lastRunSummaries: [{
errorReportLocations: [{
s3ReportLocations: [{
bucketName: "string",
objectKey: "string",
}],
}],
executionStats: [{
bytesMetered: 0,
cumulativeBytesScanned: 0,
dataWrites: 0,
executionTimeInMillis: 0,
queryResultRows: 0,
recordsIngested: 0,
}],
failureReason: "string",
invocationTime: "string",
queryInsightsResponses: [{
outputBytes: 0,
outputRows: 0,
querySpatialCoverages: [{
maxes: [{
partitionKeys: ["string"],
tableArn: "string",
value: 0,
}],
}],
queryTableCount: 0,
queryTemporalRanges: [{
maxes: [{
tableArn: "string",
value: 0,
}],
}],
}],
runStatus: "string",
triggerTime: "string",
}],
name: "string",
recentlyFailedRuns: [{
errorReportLocations: [{
s3ReportLocations: [{
bucketName: "string",
objectKey: "string",
}],
}],
executionStats: [{
bytesMetered: 0,
cumulativeBytesScanned: 0,
dataWrites: 0,
executionTimeInMillis: 0,
queryResultRows: 0,
recordsIngested: 0,
}],
failureReason: "string",
invocationTime: "string",
queryInsightsResponses: [{
outputBytes: 0,
outputRows: 0,
querySpatialCoverages: [{
maxes: [{
partitionKeys: ["string"],
tableArn: "string",
value: 0,
}],
}],
queryTableCount: 0,
queryTemporalRanges: [{
maxes: [{
tableArn: "string",
value: 0,
}],
}],
}],
runStatus: "string",
triggerTime: "string",
}],
tags: {
string: "string",
},
timeouts: {
create: "string",
"delete": "string",
update: "string",
},
});
type: aws:timestreamquery:ScheduledQuery
properties:
errorReportConfiguration:
s3Configuration:
bucketName: string
encryptionOption: string
objectKeyPrefix: string
executionRoleArn: string
kmsKeyId: string
lastRunSummaries:
- errorReportLocations:
- s3ReportLocations:
- bucketName: string
objectKey: string
executionStats:
- bytesMetered: 0
cumulativeBytesScanned: 0
dataWrites: 0
executionTimeInMillis: 0
queryResultRows: 0
recordsIngested: 0
failureReason: string
invocationTime: string
queryInsightsResponses:
- outputBytes: 0
outputRows: 0
querySpatialCoverages:
- maxes:
- partitionKeys:
- string
tableArn: string
value: 0
queryTableCount: 0
queryTemporalRanges:
- maxes:
- tableArn: string
value: 0
runStatus: string
triggerTime: string
name: string
notificationConfiguration:
snsConfiguration:
topicArn: string
queryString: string
recentlyFailedRuns:
- errorReportLocations:
- s3ReportLocations:
- bucketName: string
objectKey: string
executionStats:
- bytesMetered: 0
cumulativeBytesScanned: 0
dataWrites: 0
executionTimeInMillis: 0
queryResultRows: 0
recordsIngested: 0
failureReason: string
invocationTime: string
queryInsightsResponses:
- outputBytes: 0
outputRows: 0
querySpatialCoverages:
- maxes:
- partitionKeys:
- string
tableArn: string
value: 0
queryTableCount: 0
queryTemporalRanges:
- maxes:
- tableArn: string
value: 0
runStatus: string
triggerTime: string
scheduleConfiguration:
scheduleExpression: string
tags:
string: string
targetConfiguration:
timestreamConfiguration:
databaseName: string
dimensionMappings:
- dimensionValueType: string
name: string
measureNameColumn: string
mixedMeasureMappings:
- measureName: string
measureValueType: string
multiMeasureAttributeMappings:
- measureValueType: string
sourceColumn: string
targetMultiMeasureAttributeName: string
sourceColumn: string
targetMeasureName: string
multiMeasureMappings:
multiMeasureAttributeMappings:
- measureValueType: string
sourceColumn: string
targetMultiMeasureAttributeName: string
targetMultiMeasureName: string
tableName: string
timeColumn: string
timeouts:
create: string
delete: string
update: string
ScheduledQuery Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The ScheduledQuery resource accepts the following input properties:
- Error
Report Configuration This property is required. ScheduledQuery Error Report Configuration - Configuration block for error reporting configuration. See below.
- Execution
Role Arn This property is required. string - ARN for the IAM role that Timestream will assume when running the scheduled query.
- Notification
Configuration This property is required. ScheduledQuery Notification Configuration - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- Query
String This property is required. string - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - Schedule
Configuration This property is required. ScheduledQuery Schedule Configuration - Configuration block for schedule configuration for the query. See below.
- Target
Configuration This property is required. ScheduledQuery Target Configuration Configuration block for writing the result of a query. See below.
The following arguments are optional:
- Kms
Key stringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - Last
Run List<ScheduledSummaries Query Last Run Summary> - Runtime summary for the last scheduled query run.
- Name string
- Name of the scheduled query.
- Recently
Failed List<ScheduledRuns Query Recently Failed Run> - Runtime summary for the last five failed scheduled query runs.
- Dictionary<string, string>
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - Timeouts
Scheduled
Query Timeouts
- Error
Report Configuration This property is required. ScheduledQuery Error Report Configuration Args - Configuration block for error reporting configuration. See below.
- Execution
Role Arn This property is required. string - ARN for the IAM role that Timestream will assume when running the scheduled query.
- Notification
Configuration This property is required. ScheduledQuery Notification Configuration Args - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- Query
String This property is required. string - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - Schedule
Configuration This property is required. ScheduledQuery Schedule Configuration Args - Configuration block for schedule configuration for the query. See below.
- Target
Configuration This property is required. ScheduledQuery Target Configuration Args Configuration block for writing the result of a query. See below.
The following arguments are optional:
- Kms
Key stringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - Last
Run []ScheduledSummaries Query Last Run Summary Args - Runtime summary for the last scheduled query run.
- Name string
- Name of the scheduled query.
- Recently
Failed []ScheduledRuns Query Recently Failed Run Args - Runtime summary for the last five failed scheduled query runs.
- map[string]string
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - Timeouts
Scheduled
Query Timeouts Args
- error
Report Configuration This property is required. ScheduledQuery Error Report Configuration - Configuration block for error reporting configuration. See below.
- execution
Role Arn This property is required. String - ARN for the IAM role that Timestream will assume when running the scheduled query.
- notification
Configuration This property is required. ScheduledQuery Notification Configuration - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- query
String This property is required. String - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - schedule
Configuration This property is required. ScheduledQuery Schedule Configuration - Configuration block for schedule configuration for the query. See below.
- target
Configuration This property is required. ScheduledQuery Target Configuration Configuration block for writing the result of a query. See below.
The following arguments are optional:
- kms
Key StringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - last
Run List<ScheduledSummaries Query Last Run Summary> - Runtime summary for the last scheduled query run.
- name String
- Name of the scheduled query.
- recently
Failed List<ScheduledRuns Query Recently Failed Run> - Runtime summary for the last five failed scheduled query runs.
- Map<String,String>
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - timeouts
Scheduled
Query Timeouts
- error
Report Configuration This property is required. ScheduledQuery Error Report Configuration - Configuration block for error reporting configuration. See below.
- execution
Role Arn This property is required. string - ARN for the IAM role that Timestream will assume when running the scheduled query.
- notification
Configuration This property is required. ScheduledQuery Notification Configuration - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- query
String This property is required. string - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - schedule
Configuration This property is required. ScheduledQuery Schedule Configuration - Configuration block for schedule configuration for the query. See below.
- target
Configuration This property is required. ScheduledQuery Target Configuration Configuration block for writing the result of a query. See below.
The following arguments are optional:
- kms
Key stringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - last
Run ScheduledSummaries Query Last Run Summary[] - Runtime summary for the last scheduled query run.
- name string
- Name of the scheduled query.
- recently
Failed ScheduledRuns Query Recently Failed Run[] - Runtime summary for the last five failed scheduled query runs.
- {[key: string]: string}
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - timeouts
Scheduled
Query Timeouts
- error_
report_ configuration This property is required. ScheduledQuery Error Report Configuration Args - Configuration block for error reporting configuration. See below.
- execution_
role_ arn This property is required. str - ARN for the IAM role that Timestream will assume when running the scheduled query.
- notification_
configuration This property is required. ScheduledQuery Notification Configuration Args - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- query_
string This property is required. str - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - schedule_
configuration This property is required. ScheduledQuery Schedule Configuration Args - Configuration block for schedule configuration for the query. See below.
- target_
configuration This property is required. ScheduledQuery Target Configuration Args Configuration block for writing the result of a query. See below.
The following arguments are optional:
- kms_
key_ strid - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - last_
run_ Sequence[Scheduledsummaries Query Last Run Summary Args] - Runtime summary for the last scheduled query run.
- name str
- Name of the scheduled query.
- recently_
failed_ Sequence[Scheduledruns Query Recently Failed Run Args] - Runtime summary for the last five failed scheduled query runs.
- Mapping[str, str]
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - timeouts
Scheduled
Query Timeouts Args
- error
Report Configuration This property is required. Property Map - Configuration block for error reporting configuration. See below.
- execution
Role Arn This property is required. String - ARN for the IAM role that Timestream will assume when running the scheduled query.
- notification
Configuration This property is required. Property Map - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- query
String This property is required. String - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - schedule
Configuration This property is required. Property Map - Configuration block for schedule configuration for the query. See below.
- target
Configuration This property is required. Property Map Configuration block for writing the result of a query. See below.
The following arguments are optional:
- kms
Key StringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - last
Run List<Property Map>Summaries - Runtime summary for the last scheduled query run.
- name String
- Name of the scheduled query.
- recently
Failed List<Property Map>Runs - Runtime summary for the last five failed scheduled query runs.
- Map<String>
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - timeouts Property Map
Outputs
All input properties are implicitly available as output properties. Additionally, the ScheduledQuery resource produces the following output properties:
- Arn string
- ARN of the Scheduled Query.
- Creation
Time string - Creation time for the scheduled query.
- Id string
- The provider-assigned unique ID for this managed resource.
- Next
Invocation stringTime - Next time the scheduled query is scheduled to run.
- Previous
Invocation stringTime - Last time the scheduled query was run.
- State string
- State of the scheduled query, either
ENABLEDorDISABLED. - Dictionary<string, string>
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block.
- Arn string
- ARN of the Scheduled Query.
- Creation
Time string - Creation time for the scheduled query.
- Id string
- The provider-assigned unique ID for this managed resource.
- Next
Invocation stringTime - Next time the scheduled query is scheduled to run.
- Previous
Invocation stringTime - Last time the scheduled query was run.
- State string
- State of the scheduled query, either
ENABLEDorDISABLED. - map[string]string
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block.
- arn String
- ARN of the Scheduled Query.
- creation
Time String - Creation time for the scheduled query.
- id String
- The provider-assigned unique ID for this managed resource.
- next
Invocation StringTime - Next time the scheduled query is scheduled to run.
- previous
Invocation StringTime - Last time the scheduled query was run.
- state String
- State of the scheduled query, either
ENABLEDorDISABLED. - Map<String,String>
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block.
- arn string
- ARN of the Scheduled Query.
- creation
Time string - Creation time for the scheduled query.
- id string
- The provider-assigned unique ID for this managed resource.
- next
Invocation stringTime - Next time the scheduled query is scheduled to run.
- previous
Invocation stringTime - Last time the scheduled query was run.
- state string
- State of the scheduled query, either
ENABLEDorDISABLED. - {[key: string]: string}
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block.
- arn str
- ARN of the Scheduled Query.
- creation_
time str - Creation time for the scheduled query.
- id str
- The provider-assigned unique ID for this managed resource.
- next_
invocation_ strtime - Next time the scheduled query is scheduled to run.
- previous_
invocation_ strtime - Last time the scheduled query was run.
- state str
- State of the scheduled query, either
ENABLEDorDISABLED. - Mapping[str, str]
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block.
- arn String
- ARN of the Scheduled Query.
- creation
Time String - Creation time for the scheduled query.
- id String
- The provider-assigned unique ID for this managed resource.
- next
Invocation StringTime - Next time the scheduled query is scheduled to run.
- previous
Invocation StringTime - Last time the scheduled query was run.
- state String
- State of the scheduled query, either
ENABLEDorDISABLED. - Map<String>
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block.
Look up Existing ScheduledQuery Resource
Get an existing ScheduledQuery 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?: ScheduledQueryState, opts?: CustomResourceOptions): ScheduledQuery@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
arn: Optional[str] = None,
creation_time: Optional[str] = None,
error_report_configuration: Optional[ScheduledQueryErrorReportConfigurationArgs] = None,
execution_role_arn: Optional[str] = None,
kms_key_id: Optional[str] = None,
last_run_summaries: Optional[Sequence[ScheduledQueryLastRunSummaryArgs]] = None,
name: Optional[str] = None,
next_invocation_time: Optional[str] = None,
notification_configuration: Optional[ScheduledQueryNotificationConfigurationArgs] = None,
previous_invocation_time: Optional[str] = None,
query_string: Optional[str] = None,
recently_failed_runs: Optional[Sequence[ScheduledQueryRecentlyFailedRunArgs]] = None,
schedule_configuration: Optional[ScheduledQueryScheduleConfigurationArgs] = None,
state: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None,
tags_all: Optional[Mapping[str, str]] = None,
target_configuration: Optional[ScheduledQueryTargetConfigurationArgs] = None,
timeouts: Optional[ScheduledQueryTimeoutsArgs] = None) -> ScheduledQueryfunc GetScheduledQuery(ctx *Context, name string, id IDInput, state *ScheduledQueryState, opts ...ResourceOption) (*ScheduledQuery, error)public static ScheduledQuery Get(string name, Input<string> id, ScheduledQueryState? state, CustomResourceOptions? opts = null)public static ScheduledQuery get(String name, Output<String> id, ScheduledQueryState state, CustomResourceOptions options)resources: _: type: aws:timestreamquery:ScheduledQuery get: id: ${id}- name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
This property is required. - The unique name of the resulting resource.
- id
This property is required. - The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
The following state arguments are supported:
- Arn string
- ARN of the Scheduled Query.
- Creation
Time string - Creation time for the scheduled query.
- Error
Report ScheduledConfiguration Query Error Report Configuration - Configuration block for error reporting configuration. See below.
- Execution
Role stringArn - ARN for the IAM role that Timestream will assume when running the scheduled query.
- Kms
Key stringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - Last
Run List<ScheduledSummaries Query Last Run Summary> - Runtime summary for the last scheduled query run.
- Name string
- Name of the scheduled query.
- Next
Invocation stringTime - Next time the scheduled query is scheduled to run.
- Notification
Configuration ScheduledQuery Notification Configuration - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- Previous
Invocation stringTime - Last time the scheduled query was run.
- Query
String string - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - Recently
Failed List<ScheduledRuns Query Recently Failed Run> - Runtime summary for the last five failed scheduled query runs.
- Schedule
Configuration ScheduledQuery Schedule Configuration - Configuration block for schedule configuration for the query. See below.
- State string
- State of the scheduled query, either
ENABLEDorDISABLED. - Dictionary<string, string>
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - Dictionary<string, string>
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block. - Target
Configuration ScheduledQuery Target Configuration Configuration block for writing the result of a query. See below.
The following arguments are optional:
- Timeouts
Scheduled
Query Timeouts
- Arn string
- ARN of the Scheduled Query.
- Creation
Time string - Creation time for the scheduled query.
- Error
Report ScheduledConfiguration Query Error Report Configuration Args - Configuration block for error reporting configuration. See below.
- Execution
Role stringArn - ARN for the IAM role that Timestream will assume when running the scheduled query.
- Kms
Key stringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - Last
Run []ScheduledSummaries Query Last Run Summary Args - Runtime summary for the last scheduled query run.
- Name string
- Name of the scheduled query.
- Next
Invocation stringTime - Next time the scheduled query is scheduled to run.
- Notification
Configuration ScheduledQuery Notification Configuration Args - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- Previous
Invocation stringTime - Last time the scheduled query was run.
- Query
String string - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - Recently
Failed []ScheduledRuns Query Recently Failed Run Args - Runtime summary for the last five failed scheduled query runs.
- Schedule
Configuration ScheduledQuery Schedule Configuration Args - Configuration block for schedule configuration for the query. See below.
- State string
- State of the scheduled query, either
ENABLEDorDISABLED. - map[string]string
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - map[string]string
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block. - Target
Configuration ScheduledQuery Target Configuration Args Configuration block for writing the result of a query. See below.
The following arguments are optional:
- Timeouts
Scheduled
Query Timeouts Args
- arn String
- ARN of the Scheduled Query.
- creation
Time String - Creation time for the scheduled query.
- error
Report ScheduledConfiguration Query Error Report Configuration - Configuration block for error reporting configuration. See below.
- execution
Role StringArn - ARN for the IAM role that Timestream will assume when running the scheduled query.
- kms
Key StringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - last
Run List<ScheduledSummaries Query Last Run Summary> - Runtime summary for the last scheduled query run.
- name String
- Name of the scheduled query.
- next
Invocation StringTime - Next time the scheduled query is scheduled to run.
- notification
Configuration ScheduledQuery Notification Configuration - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- previous
Invocation StringTime - Last time the scheduled query was run.
- query
String String - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - recently
Failed List<ScheduledRuns Query Recently Failed Run> - Runtime summary for the last five failed scheduled query runs.
- schedule
Configuration ScheduledQuery Schedule Configuration - Configuration block for schedule configuration for the query. See below.
- state String
- State of the scheduled query, either
ENABLEDorDISABLED. - Map<String,String>
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - Map<String,String>
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block. - target
Configuration ScheduledQuery Target Configuration Configuration block for writing the result of a query. See below.
The following arguments are optional:
- timeouts
Scheduled
Query Timeouts
- arn string
- ARN of the Scheduled Query.
- creation
Time string - Creation time for the scheduled query.
- error
Report ScheduledConfiguration Query Error Report Configuration - Configuration block for error reporting configuration. See below.
- execution
Role stringArn - ARN for the IAM role that Timestream will assume when running the scheduled query.
- kms
Key stringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - last
Run ScheduledSummaries Query Last Run Summary[] - Runtime summary for the last scheduled query run.
- name string
- Name of the scheduled query.
- next
Invocation stringTime - Next time the scheduled query is scheduled to run.
- notification
Configuration ScheduledQuery Notification Configuration - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- previous
Invocation stringTime - Last time the scheduled query was run.
- query
String string - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - recently
Failed ScheduledRuns Query Recently Failed Run[] - Runtime summary for the last five failed scheduled query runs.
- schedule
Configuration ScheduledQuery Schedule Configuration - Configuration block for schedule configuration for the query. See below.
- state string
- State of the scheduled query, either
ENABLEDorDISABLED. - {[key: string]: string}
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - {[key: string]: string}
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block. - target
Configuration ScheduledQuery Target Configuration Configuration block for writing the result of a query. See below.
The following arguments are optional:
- timeouts
Scheduled
Query Timeouts
- arn str
- ARN of the Scheduled Query.
- creation_
time str - Creation time for the scheduled query.
- error_
report_ Scheduledconfiguration Query Error Report Configuration Args - Configuration block for error reporting configuration. See below.
- execution_
role_ strarn - ARN for the IAM role that Timestream will assume when running the scheduled query.
- kms_
key_ strid - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - last_
run_ Sequence[Scheduledsummaries Query Last Run Summary Args] - Runtime summary for the last scheduled query run.
- name str
- Name of the scheduled query.
- next_
invocation_ strtime - Next time the scheduled query is scheduled to run.
- notification_
configuration ScheduledQuery Notification Configuration Args - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- previous_
invocation_ strtime - Last time the scheduled query was run.
- query_
string str - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - recently_
failed_ Sequence[Scheduledruns Query Recently Failed Run Args] - Runtime summary for the last five failed scheduled query runs.
- schedule_
configuration ScheduledQuery Schedule Configuration Args - Configuration block for schedule configuration for the query. See below.
- state str
- State of the scheduled query, either
ENABLEDorDISABLED. - Mapping[str, str]
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - Mapping[str, str]
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block. - target_
configuration ScheduledQuery Target Configuration Args Configuration block for writing the result of a query. See below.
The following arguments are optional:
- timeouts
Scheduled
Query Timeouts Args
- arn String
- ARN of the Scheduled Query.
- creation
Time String - Creation time for the scheduled query.
- error
Report Property MapConfiguration - Configuration block for error reporting configuration. See below.
- execution
Role StringArn - ARN for the IAM role that Timestream will assume when running the scheduled query.
- kms
Key StringId - Amazon KMS key used to encrypt the scheduled query resource, at-rest. If not specified, the scheduled query resource will be encrypted with a Timestream owned Amazon KMS key. To specify a KMS key, use the key ID, key ARN, alias name, or alias ARN. When using an alias name, prefix the name with "alias/". If
error_report_configurationusesSSE_KMSas the encryption type, the samekms_key_idis used to encrypt the error report at rest. - last
Run List<Property Map>Summaries - Runtime summary for the last scheduled query run.
- name String
- Name of the scheduled query.
- next
Invocation StringTime - Next time the scheduled query is scheduled to run.
- notification
Configuration Property Map - Configuration block for notification configuration for a scheduled query. A notification is sent by Timestream when a scheduled query is created, its state is updated, or when it is deleted. See below.
- previous
Invocation StringTime - Last time the scheduled query was run.
- query
String String - Query string to run. Parameter names can be specified in the query string using the
@character followed by an identifier. The named parameter@scheduled_runtimeis reserved and can be used in the query to get the time at which the query is scheduled to run. The timestamp calculated according to theschedule_configurationparameter, will be the value of@scheduled_runtimeparamater for each query run. For example, consider an instance of a scheduled query executing on 2021-12-01 00:00:00. For this instance, the@scheduled_runtimeparameter is initialized to the timestamp 2021-12-01 00:00:00 when invoking the query. - recently
Failed List<Property Map>Runs - Runtime summary for the last five failed scheduled query runs.
- schedule
Configuration Property Map - Configuration block for schedule configuration for the query. See below.
- state String
- State of the scheduled query, either
ENABLEDorDISABLED. - Map<String>
- Map of tags assigned to the resource. If configured with a provider
default_tagsconfiguration block present, tags with matching keys will overwrite those defined at the provider-level. - Map<String>
- Map of tags assigned to the resource, including those inherited from the provider
default_tagsconfiguration block. - target
Configuration Property Map Configuration block for writing the result of a query. See below.
The following arguments are optional:
- timeouts Property Map
Supporting Types
ScheduledQueryErrorReportConfiguration, ScheduledQueryErrorReportConfigurationArgs
, ScheduledQueryErrorReportConfigurationArgs
- S3Configuration
This property is required. ScheduledQuery Error Report Configuration S3Configuration - Configuration block for the S3 configuration for the error reports. See below.
- S3Configuration
This property is required. ScheduledQuery Error Report Configuration S3Configuration - Configuration block for the S3 configuration for the error reports. See below.
- s3Configuration
This property is required. ScheduledQuery Error Report Configuration S3Configuration - Configuration block for the S3 configuration for the error reports. See below.
- s3Configuration
This property is required. ScheduledQuery Error Report Configuration S3Configuration - Configuration block for the S3 configuration for the error reports. See below.
- s3_
configuration This property is required. ScheduledQuery Error Report Configuration S3Configuration - Configuration block for the S3 configuration for the error reports. See below.
- s3Configuration
This property is required. Property Map - Configuration block for the S3 configuration for the error reports. See below.
ScheduledQueryErrorReportConfigurationS3Configuration, ScheduledQueryErrorReportConfigurationS3ConfigurationArgs
, ScheduledQueryErrorReportConfigurationS3ConfigurationArgs
- Bucket
Name This property is required. string - Name of the S3 bucket under which error reports will be created.
- Encryption
Option string - Encryption at rest options for the error reports. If no encryption option is specified, Timestream will choose
SSE_S3as default. Valid values areSSE_S3,SSE_KMS. - Object
Key stringPrefix - Prefix for the error report key.
- Bucket
Name This property is required. string - Name of the S3 bucket under which error reports will be created.
- Encryption
Option string - Encryption at rest options for the error reports. If no encryption option is specified, Timestream will choose
SSE_S3as default. Valid values areSSE_S3,SSE_KMS. - Object
Key stringPrefix - Prefix for the error report key.
- bucket
Name This property is required. String - Name of the S3 bucket under which error reports will be created.
- encryption
Option String - Encryption at rest options for the error reports. If no encryption option is specified, Timestream will choose
SSE_S3as default. Valid values areSSE_S3,SSE_KMS. - object
Key StringPrefix - Prefix for the error report key.
- bucket
Name This property is required. string - Name of the S3 bucket under which error reports will be created.
- encryption
Option string - Encryption at rest options for the error reports. If no encryption option is specified, Timestream will choose
SSE_S3as default. Valid values areSSE_S3,SSE_KMS. - object
Key stringPrefix - Prefix for the error report key.
- bucket_
name This property is required. str - Name of the S3 bucket under which error reports will be created.
- encryption_
option str - Encryption at rest options for the error reports. If no encryption option is specified, Timestream will choose
SSE_S3as default. Valid values areSSE_S3,SSE_KMS. - object_
key_ strprefix - Prefix for the error report key.
- bucket
Name This property is required. String - Name of the S3 bucket under which error reports will be created.
- encryption
Option String - Encryption at rest options for the error reports. If no encryption option is specified, Timestream will choose
SSE_S3as default. Valid values areSSE_S3,SSE_KMS. - object
Key StringPrefix - Prefix for the error report key.
ScheduledQueryLastRunSummary, ScheduledQueryLastRunSummaryArgs
, ScheduledQueryLastRunSummaryArgs
- Error
Report List<ScheduledLocations Query Last Run Summary Error Report Location> - S3 location for error report.
- Execution
Stats List<ScheduledQuery Last Run Summary Execution Stat> - Statistics for a single scheduled query run.
- Failure
Reason string - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- Invocation
Time string - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - Query
Insights List<ScheduledResponses Query Last Run Summary Query Insights Response> - Various insights and metrics related to the run summary of the scheduled query.
- Run
Status string - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - Trigger
Time string - Actual time when the query was run.
- Error
Report []ScheduledLocations Query Last Run Summary Error Report Location - S3 location for error report.
- Execution
Stats []ScheduledQuery Last Run Summary Execution Stat - Statistics for a single scheduled query run.
- Failure
Reason string - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- Invocation
Time string - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - Query
Insights []ScheduledResponses Query Last Run Summary Query Insights Response - Various insights and metrics related to the run summary of the scheduled query.
- Run
Status string - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - Trigger
Time string - Actual time when the query was run.
- error
Report List<ScheduledLocations Query Last Run Summary Error Report Location> - S3 location for error report.
- execution
Stats List<ScheduledQuery Last Run Summary Execution Stat> - Statistics for a single scheduled query run.
- failure
Reason String - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- invocation
Time String - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - query
Insights List<ScheduledResponses Query Last Run Summary Query Insights Response> - Various insights and metrics related to the run summary of the scheduled query.
- run
Status String - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - trigger
Time String - Actual time when the query was run.
- error
Report ScheduledLocations Query Last Run Summary Error Report Location[] - S3 location for error report.
- execution
Stats ScheduledQuery Last Run Summary Execution Stat[] - Statistics for a single scheduled query run.
- failure
Reason string - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- invocation
Time string - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - query
Insights ScheduledResponses Query Last Run Summary Query Insights Response[] - Various insights and metrics related to the run summary of the scheduled query.
- run
Status string - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - trigger
Time string - Actual time when the query was run.
- error_
report_ Sequence[Scheduledlocations Query Last Run Summary Error Report Location] - S3 location for error report.
- execution_
stats Sequence[ScheduledQuery Last Run Summary Execution Stat] - Statistics for a single scheduled query run.
- failure_
reason str - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- invocation_
time str - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - query_
insights_ Sequence[Scheduledresponses Query Last Run Summary Query Insights Response] - Various insights and metrics related to the run summary of the scheduled query.
- run_
status str - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - trigger_
time str - Actual time when the query was run.
- error
Report List<Property Map>Locations - S3 location for error report.
- execution
Stats List<Property Map> - Statistics for a single scheduled query run.
- failure
Reason String - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- invocation
Time String - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - query
Insights List<Property Map>Responses - Various insights and metrics related to the run summary of the scheduled query.
- run
Status String - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - trigger
Time String - Actual time when the query was run.
ScheduledQueryLastRunSummaryErrorReportLocation, ScheduledQueryLastRunSummaryErrorReportLocationArgs
, ScheduledQueryLastRunSummaryErrorReportLocationArgs
- S3Report
Locations List<ScheduledQuery Last Run Summary Error Report Location S3Report Location> - S3 location where error reports are written.
- S3Report
Locations []ScheduledQuery Last Run Summary Error Report Location S3Report Location - S3 location where error reports are written.
- s3Report
Locations List<ScheduledQuery Last Run Summary Error Report Location S3Report Location> - S3 location where error reports are written.
- s3Report
Locations ScheduledQuery Last Run Summary Error Report Location S3Report Location[] - S3 location where error reports are written.
- s3_
report_ Sequence[Scheduledlocations Query Last Run Summary Error Report Location S3Report Location] - S3 location where error reports are written.
- s3Report
Locations List<Property Map> - S3 location where error reports are written.
ScheduledQueryLastRunSummaryErrorReportLocationS3ReportLocation, ScheduledQueryLastRunSummaryErrorReportLocationS3ReportLocationArgs
, ScheduledQueryLastRunSummaryErrorReportLocationS3ReportLocationArgs
- Bucket
Name string - S3 bucket name.
- Object
Key string - S3 key.
- Bucket
Name string - S3 bucket name.
- Object
Key string - S3 key.
- bucket
Name String - S3 bucket name.
- object
Key String - S3 key.
- bucket
Name string - S3 bucket name.
- object
Key string - S3 key.
- bucket_
name str - S3 bucket name.
- object_
key str - S3 key.
- bucket
Name String - S3 bucket name.
- object
Key String - S3 key.
ScheduledQueryLastRunSummaryExecutionStat, ScheduledQueryLastRunSummaryExecutionStatArgs
, ScheduledQueryLastRunSummaryExecutionStatArgs
- Bytes
Metered int - Bytes metered for a single scheduled query run.
- Cumulative
Bytes intScanned - Bytes scanned for a single scheduled query run.
- Data
Writes int - Data writes metered for records ingested in a single scheduled query run.
- Execution
Time intIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- Query
Result intRows - Number of rows present in the output from running a query before ingestion to destination data source.
- Records
Ingested int - Number of records ingested for a single scheduled query run.
- Bytes
Metered int - Bytes metered for a single scheduled query run.
- Cumulative
Bytes intScanned - Bytes scanned for a single scheduled query run.
- Data
Writes int - Data writes metered for records ingested in a single scheduled query run.
- Execution
Time intIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- Query
Result intRows - Number of rows present in the output from running a query before ingestion to destination data source.
- Records
Ingested int - Number of records ingested for a single scheduled query run.
- bytes
Metered Integer - Bytes metered for a single scheduled query run.
- cumulative
Bytes IntegerScanned - Bytes scanned for a single scheduled query run.
- data
Writes Integer - Data writes metered for records ingested in a single scheduled query run.
- execution
Time IntegerIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- query
Result IntegerRows - Number of rows present in the output from running a query before ingestion to destination data source.
- records
Ingested Integer - Number of records ingested for a single scheduled query run.
- bytes
Metered number - Bytes metered for a single scheduled query run.
- cumulative
Bytes numberScanned - Bytes scanned for a single scheduled query run.
- data
Writes number - Data writes metered for records ingested in a single scheduled query run.
- execution
Time numberIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- query
Result numberRows - Number of rows present in the output from running a query before ingestion to destination data source.
- records
Ingested number - Number of records ingested for a single scheduled query run.
- bytes_
metered int - Bytes metered for a single scheduled query run.
- cumulative_
bytes_ intscanned - Bytes scanned for a single scheduled query run.
- data_
writes int - Data writes metered for records ingested in a single scheduled query run.
- execution_
time_ intin_ millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- query_
result_ introws - Number of rows present in the output from running a query before ingestion to destination data source.
- records_
ingested int - Number of records ingested for a single scheduled query run.
- bytes
Metered Number - Bytes metered for a single scheduled query run.
- cumulative
Bytes NumberScanned - Bytes scanned for a single scheduled query run.
- data
Writes Number - Data writes metered for records ingested in a single scheduled query run.
- execution
Time NumberIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- query
Result NumberRows - Number of rows present in the output from running a query before ingestion to destination data source.
- records
Ingested Number - Number of records ingested for a single scheduled query run.
ScheduledQueryLastRunSummaryQueryInsightsResponse, ScheduledQueryLastRunSummaryQueryInsightsResponseArgs
, ScheduledQueryLastRunSummaryQueryInsightsResponseArgs
- Output
Bytes int - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- Output
Rows int - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- Query
Spatial List<ScheduledCoverages Query Last Run Summary Query Insights Response Query Spatial Coverage> - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- Query
Table intCount - Number of tables in the query.
- Query
Temporal List<ScheduledRanges Query Last Run Summary Query Insights Response Query Temporal Range> - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- Output
Bytes int - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- Output
Rows int - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- Query
Spatial []ScheduledCoverages Query Last Run Summary Query Insights Response Query Spatial Coverage - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- Query
Table intCount - Number of tables in the query.
- Query
Temporal []ScheduledRanges Query Last Run Summary Query Insights Response Query Temporal Range - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- output
Bytes Integer - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- output
Rows Integer - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- query
Spatial List<ScheduledCoverages Query Last Run Summary Query Insights Response Query Spatial Coverage> - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- query
Table IntegerCount - Number of tables in the query.
- query
Temporal List<ScheduledRanges Query Last Run Summary Query Insights Response Query Temporal Range> - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- output
Bytes number - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- output
Rows number - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- query
Spatial ScheduledCoverages Query Last Run Summary Query Insights Response Query Spatial Coverage[] - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- query
Table numberCount - Number of tables in the query.
- query
Temporal ScheduledRanges Query Last Run Summary Query Insights Response Query Temporal Range[] - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- output_
bytes int - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- output_
rows int - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- query_
spatial_ Sequence[Scheduledcoverages Query Last Run Summary Query Insights Response Query Spatial Coverage] - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- query_
table_ intcount - Number of tables in the query.
- query_
temporal_ Sequence[Scheduledranges Query Last Run Summary Query Insights Response Query Temporal Range] - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- output
Bytes Number - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- output
Rows Number - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- query
Spatial List<Property Map>Coverages - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- query
Table NumberCount - Number of tables in the query.
- query
Temporal List<Property Map>Ranges - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverage, ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageArgs
, ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageArgs
- Maxes
List<Scheduled
Query Last Run Summary Query Insights Response Query Spatial Coverage Maxis> - Insights into the most sub-optimal performing table on the temporal axis:
- Maxes
[]Scheduled
Query Last Run Summary Query Insights Response Query Spatial Coverage Maxis - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
List<Scheduled
Query Last Run Summary Query Insights Response Query Spatial Coverage Maxis> - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
Scheduled
Query Last Run Summary Query Insights Response Query Spatial Coverage Maxis[] - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
Sequence[Scheduled
Query Last Run Summary Query Insights Response Query Spatial Coverage Maxis] - Insights into the most sub-optimal performing table on the temporal axis:
- maxes List<Property Map>
- Insights into the most sub-optimal performing table on the temporal axis:
ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageMaxis, ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageMaxisArgs
, ScheduledQueryLastRunSummaryQueryInsightsResponseQuerySpatialCoverageMaxisArgs
- Partition
Keys List<string> - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- Table
Arn string - ARN of the table which is queried with the largest time range.
- Value double
- Maximum duration in nanoseconds between the start and end of the query.
- Partition
Keys []string - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- Table
Arn string - ARN of the table which is queried with the largest time range.
- Value float64
- Maximum duration in nanoseconds between the start and end of the query.
- partition
Keys List<String> - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- table
Arn String - ARN of the table which is queried with the largest time range.
- value Double
- Maximum duration in nanoseconds between the start and end of the query.
- partition
Keys string[] - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- table
Arn string - ARN of the table which is queried with the largest time range.
- value number
- Maximum duration in nanoseconds between the start and end of the query.
- partition_
keys Sequence[str] - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- table_
arn str - ARN of the table which is queried with the largest time range.
- value float
- Maximum duration in nanoseconds between the start and end of the query.
- partition
Keys List<String> - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- table
Arn String - ARN of the table which is queried with the largest time range.
- value Number
- Maximum duration in nanoseconds between the start and end of the query.
ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRange, ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeArgs
, ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeArgs
- Maxes
List<Scheduled
Query Last Run Summary Query Insights Response Query Temporal Range Maxis> - Insights into the most sub-optimal performing table on the temporal axis:
- Maxes
[]Scheduled
Query Last Run Summary Query Insights Response Query Temporal Range Maxis - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
List<Scheduled
Query Last Run Summary Query Insights Response Query Temporal Range Maxis> - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
Scheduled
Query Last Run Summary Query Insights Response Query Temporal Range Maxis[] - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
Sequence[Scheduled
Query Last Run Summary Query Insights Response Query Temporal Range Maxis] - Insights into the most sub-optimal performing table on the temporal axis:
- maxes List<Property Map>
- Insights into the most sub-optimal performing table on the temporal axis:
ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeMaxis, ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeMaxisArgs
, ScheduledQueryLastRunSummaryQueryInsightsResponseQueryTemporalRangeMaxisArgs
ScheduledQueryNotificationConfiguration, ScheduledQueryNotificationConfigurationArgs
, ScheduledQueryNotificationConfigurationArgs
- Sns
Configuration This property is required. ScheduledQuery Notification Configuration Sns Configuration - Configuration block for details about the Amazon Simple Notification Service (SNS) configuration. See below.
- Sns
Configuration This property is required. ScheduledQuery Notification Configuration Sns Configuration - Configuration block for details about the Amazon Simple Notification Service (SNS) configuration. See below.
- sns
Configuration This property is required. ScheduledQuery Notification Configuration Sns Configuration - Configuration block for details about the Amazon Simple Notification Service (SNS) configuration. See below.
- sns
Configuration This property is required. ScheduledQuery Notification Configuration Sns Configuration - Configuration block for details about the Amazon Simple Notification Service (SNS) configuration. See below.
- sns_
configuration This property is required. ScheduledQuery Notification Configuration Sns Configuration - Configuration block for details about the Amazon Simple Notification Service (SNS) configuration. See below.
- sns
Configuration This property is required. Property Map - Configuration block for details about the Amazon Simple Notification Service (SNS) configuration. See below.
ScheduledQueryNotificationConfigurationSnsConfiguration, ScheduledQueryNotificationConfigurationSnsConfigurationArgs
, ScheduledQueryNotificationConfigurationSnsConfigurationArgs
- Topic
Arn This property is required. string - SNS topic ARN that the scheduled query status notifications will be sent to.
- Topic
Arn This property is required. string - SNS topic ARN that the scheduled query status notifications will be sent to.
- topic
Arn This property is required. String - SNS topic ARN that the scheduled query status notifications will be sent to.
- topic
Arn This property is required. string - SNS topic ARN that the scheduled query status notifications will be sent to.
- topic_
arn This property is required. str - SNS topic ARN that the scheduled query status notifications will be sent to.
- topic
Arn This property is required. String - SNS topic ARN that the scheduled query status notifications will be sent to.
ScheduledQueryRecentlyFailedRun, ScheduledQueryRecentlyFailedRunArgs
, ScheduledQueryRecentlyFailedRunArgs
- Error
Report List<ScheduledLocations Query Recently Failed Run Error Report Location> - S3 location for error report.
- Execution
Stats List<ScheduledQuery Recently Failed Run Execution Stat> - Statistics for a single scheduled query run.
- Failure
Reason string - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- Invocation
Time string - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - Query
Insights List<ScheduledResponses Query Recently Failed Run Query Insights Response> - Various insights and metrics related to the run summary of the scheduled query.
- Run
Status string - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - Trigger
Time string - Actual time when the query was run.
- Error
Report []ScheduledLocations Query Recently Failed Run Error Report Location - S3 location for error report.
- Execution
Stats []ScheduledQuery Recently Failed Run Execution Stat - Statistics for a single scheduled query run.
- Failure
Reason string - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- Invocation
Time string - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - Query
Insights []ScheduledResponses Query Recently Failed Run Query Insights Response - Various insights and metrics related to the run summary of the scheduled query.
- Run
Status string - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - Trigger
Time string - Actual time when the query was run.
- error
Report List<ScheduledLocations Query Recently Failed Run Error Report Location> - S3 location for error report.
- execution
Stats List<ScheduledQuery Recently Failed Run Execution Stat> - Statistics for a single scheduled query run.
- failure
Reason String - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- invocation
Time String - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - query
Insights List<ScheduledResponses Query Recently Failed Run Query Insights Response> - Various insights and metrics related to the run summary of the scheduled query.
- run
Status String - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - trigger
Time String - Actual time when the query was run.
- error
Report ScheduledLocations Query Recently Failed Run Error Report Location[] - S3 location for error report.
- execution
Stats ScheduledQuery Recently Failed Run Execution Stat[] - Statistics for a single scheduled query run.
- failure
Reason string - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- invocation
Time string - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - query
Insights ScheduledResponses Query Recently Failed Run Query Insights Response[] - Various insights and metrics related to the run summary of the scheduled query.
- run
Status string - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - trigger
Time string - Actual time when the query was run.
- error_
report_ Sequence[Scheduledlocations Query Recently Failed Run Error Report Location] - S3 location for error report.
- execution_
stats Sequence[ScheduledQuery Recently Failed Run Execution Stat] - Statistics for a single scheduled query run.
- failure_
reason str - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- invocation_
time str - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - query_
insights_ Sequence[Scheduledresponses Query Recently Failed Run Query Insights Response] - Various insights and metrics related to the run summary of the scheduled query.
- run_
status str - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - trigger_
time str - Actual time when the query was run.
- error
Report List<Property Map>Locations - S3 location for error report.
- execution
Stats List<Property Map> - Statistics for a single scheduled query run.
- failure
Reason String - Error message for the scheduled query in case of failure. You might have to look at the error report to get more detailed error reasons.
- invocation
Time String - InvocationTime for this run. This is the time at which the query is scheduled to run. Parameter
@scheduled_runtimecan be used in the query to get the value. - query
Insights List<Property Map>Responses - Various insights and metrics related to the run summary of the scheduled query.
- run
Status String - Status of a scheduled query run. Valid values:
AUTO_TRIGGER_SUCCESS,AUTO_TRIGGER_FAILURE,MANUAL_TRIGGER_SUCCESS,MANUAL_TRIGGER_FAILURE. - trigger
Time String - Actual time when the query was run.
ScheduledQueryRecentlyFailedRunErrorReportLocation, ScheduledQueryRecentlyFailedRunErrorReportLocationArgs
, ScheduledQueryRecentlyFailedRunErrorReportLocationArgs
- S3Report
Locations List<ScheduledQuery Recently Failed Run Error Report Location S3Report Location> - S3 location where error reports are written.
- S3Report
Locations []ScheduledQuery Recently Failed Run Error Report Location S3Report Location - S3 location where error reports are written.
- s3Report
Locations List<ScheduledQuery Recently Failed Run Error Report Location S3Report Location> - S3 location where error reports are written.
- s3Report
Locations ScheduledQuery Recently Failed Run Error Report Location S3Report Location[] - S3 location where error reports are written.
- s3_
report_ Sequence[Scheduledlocations Query Recently Failed Run Error Report Location S3Report Location] - S3 location where error reports are written.
- s3Report
Locations List<Property Map> - S3 location where error reports are written.
ScheduledQueryRecentlyFailedRunErrorReportLocationS3ReportLocation, ScheduledQueryRecentlyFailedRunErrorReportLocationS3ReportLocationArgs
, ScheduledQueryRecentlyFailedRunErrorReportLocationS3ReportLocationArgs
- Bucket
Name string - S3 bucket name.
- Object
Key string - S3 key.
- Bucket
Name string - S3 bucket name.
- Object
Key string - S3 key.
- bucket
Name String - S3 bucket name.
- object
Key String - S3 key.
- bucket
Name string - S3 bucket name.
- object
Key string - S3 key.
- bucket_
name str - S3 bucket name.
- object_
key str - S3 key.
- bucket
Name String - S3 bucket name.
- object
Key String - S3 key.
ScheduledQueryRecentlyFailedRunExecutionStat, ScheduledQueryRecentlyFailedRunExecutionStatArgs
, ScheduledQueryRecentlyFailedRunExecutionStatArgs
- Bytes
Metered int - Bytes metered for a single scheduled query run.
- Cumulative
Bytes intScanned - Bytes scanned for a single scheduled query run.
- Data
Writes int - Data writes metered for records ingested in a single scheduled query run.
- Execution
Time intIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- Query
Result intRows - Number of rows present in the output from running a query before ingestion to destination data source.
- Records
Ingested int - Number of records ingested for a single scheduled query run.
- Bytes
Metered int - Bytes metered for a single scheduled query run.
- Cumulative
Bytes intScanned - Bytes scanned for a single scheduled query run.
- Data
Writes int - Data writes metered for records ingested in a single scheduled query run.
- Execution
Time intIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- Query
Result intRows - Number of rows present in the output from running a query before ingestion to destination data source.
- Records
Ingested int - Number of records ingested for a single scheduled query run.
- bytes
Metered Integer - Bytes metered for a single scheduled query run.
- cumulative
Bytes IntegerScanned - Bytes scanned for a single scheduled query run.
- data
Writes Integer - Data writes metered for records ingested in a single scheduled query run.
- execution
Time IntegerIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- query
Result IntegerRows - Number of rows present in the output from running a query before ingestion to destination data source.
- records
Ingested Integer - Number of records ingested for a single scheduled query run.
- bytes
Metered number - Bytes metered for a single scheduled query run.
- cumulative
Bytes numberScanned - Bytes scanned for a single scheduled query run.
- data
Writes number - Data writes metered for records ingested in a single scheduled query run.
- execution
Time numberIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- query
Result numberRows - Number of rows present in the output from running a query before ingestion to destination data source.
- records
Ingested number - Number of records ingested for a single scheduled query run.
- bytes_
metered int - Bytes metered for a single scheduled query run.
- cumulative_
bytes_ intscanned - Bytes scanned for a single scheduled query run.
- data_
writes int - Data writes metered for records ingested in a single scheduled query run.
- execution_
time_ intin_ millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- query_
result_ introws - Number of rows present in the output from running a query before ingestion to destination data source.
- records_
ingested int - Number of records ingested for a single scheduled query run.
- bytes
Metered Number - Bytes metered for a single scheduled query run.
- cumulative
Bytes NumberScanned - Bytes scanned for a single scheduled query run.
- data
Writes Number - Data writes metered for records ingested in a single scheduled query run.
- execution
Time NumberIn Millis - Total time, measured in milliseconds, that was needed for the scheduled query run to complete.
- query
Result NumberRows - Number of rows present in the output from running a query before ingestion to destination data source.
- records
Ingested Number - Number of records ingested for a single scheduled query run.
ScheduledQueryRecentlyFailedRunQueryInsightsResponse, ScheduledQueryRecentlyFailedRunQueryInsightsResponseArgs
, ScheduledQueryRecentlyFailedRunQueryInsightsResponseArgs
- Output
Bytes int - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- Output
Rows int - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- Query
Spatial List<ScheduledCoverages Query Recently Failed Run Query Insights Response Query Spatial Coverage> - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- Query
Table intCount - Number of tables in the query.
- Query
Temporal List<ScheduledRanges Query Recently Failed Run Query Insights Response Query Temporal Range> - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- Output
Bytes int - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- Output
Rows int - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- Query
Spatial []ScheduledCoverages Query Recently Failed Run Query Insights Response Query Spatial Coverage - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- Query
Table intCount - Number of tables in the query.
- Query
Temporal []ScheduledRanges Query Recently Failed Run Query Insights Response Query Temporal Range - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- output
Bytes Integer - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- output
Rows Integer - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- query
Spatial List<ScheduledCoverages Query Recently Failed Run Query Insights Response Query Spatial Coverage> - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- query
Table IntegerCount - Number of tables in the query.
- query
Temporal List<ScheduledRanges Query Recently Failed Run Query Insights Response Query Temporal Range> - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- output
Bytes number - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- output
Rows number - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- query
Spatial ScheduledCoverages Query Recently Failed Run Query Insights Response Query Spatial Coverage[] - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- query
Table numberCount - Number of tables in the query.
- query
Temporal ScheduledRanges Query Recently Failed Run Query Insights Response Query Temporal Range[] - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- output_
bytes int - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- output_
rows int - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- query_
spatial_ Sequence[Scheduledcoverages Query Recently Failed Run Query Insights Response Query Spatial Coverage] - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- query_
table_ intcount - Number of tables in the query.
- query_
temporal_ Sequence[Scheduledranges Query Recently Failed Run Query Insights Response Query Temporal Range] - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
- output
Bytes Number - Size of query result set in bytes. You can use this data to validate if the result set has changed as part of the query tuning exercise.
- output
Rows Number - Total number of rows returned as part of the query result set. You can use this data to validate if the number of rows in the result set have changed as part of the query tuning exercise.
- query
Spatial List<Property Map>Coverages - Insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. This information can help you identify areas for improvement in your partitioning strategy to enhance spatial pruning.
- query
Table NumberCount - Number of tables in the query.
- query
Temporal List<Property Map>Ranges - Insights into the temporal range of the query, including the table with the largest (max) time range. Following are some of the potential options for optimizing time-based pruning: add missing time-predicates, remove functions around the time predicates, add time predicates to all the sub-queries.
ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverage, ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageArgs
, ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageArgs
- Maxes
List<Scheduled
Query Recently Failed Run Query Insights Response Query Spatial Coverage Maxis> - Insights into the most sub-optimal performing table on the temporal axis:
- Maxes
[]Scheduled
Query Recently Failed Run Query Insights Response Query Spatial Coverage Maxis - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
List<Scheduled
Query Recently Failed Run Query Insights Response Query Spatial Coverage Maxis> - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
Scheduled
Query Recently Failed Run Query Insights Response Query Spatial Coverage Maxis[] - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
Sequence[Scheduled
Query Recently Failed Run Query Insights Response Query Spatial Coverage Maxis] - Insights into the most sub-optimal performing table on the temporal axis:
- maxes List<Property Map>
- Insights into the most sub-optimal performing table on the temporal axis:
ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageMaxis, ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageMaxisArgs
, ScheduledQueryRecentlyFailedRunQueryInsightsResponseQuerySpatialCoverageMaxisArgs
- Partition
Keys List<string> - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- Table
Arn string - ARN of the table which is queried with the largest time range.
- Value double
- Maximum duration in nanoseconds between the start and end of the query.
- Partition
Keys []string - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- Table
Arn string - ARN of the table which is queried with the largest time range.
- Value float64
- Maximum duration in nanoseconds between the start and end of the query.
- partition
Keys List<String> - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- table
Arn String - ARN of the table which is queried with the largest time range.
- value Double
- Maximum duration in nanoseconds between the start and end of the query.
- partition
Keys string[] - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- table
Arn string - ARN of the table which is queried with the largest time range.
- value number
- Maximum duration in nanoseconds between the start and end of the query.
- partition_
keys Sequence[str] - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- table_
arn str - ARN of the table which is queried with the largest time range.
- value float
- Maximum duration in nanoseconds between the start and end of the query.
- partition
Keys List<String> - Partition key used for partitioning, which can be a default measure_name or a customer defined partition key.
- table
Arn String - ARN of the table which is queried with the largest time range.
- value Number
- Maximum duration in nanoseconds between the start and end of the query.
ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRange, ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeArgs
, ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeArgs
- Maxes
List<Scheduled
Query Recently Failed Run Query Insights Response Query Temporal Range Maxis> - Insights into the most sub-optimal performing table on the temporal axis:
- Maxes
[]Scheduled
Query Recently Failed Run Query Insights Response Query Temporal Range Maxis - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
List<Scheduled
Query Recently Failed Run Query Insights Response Query Temporal Range Maxis> - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
Scheduled
Query Recently Failed Run Query Insights Response Query Temporal Range Maxis[] - Insights into the most sub-optimal performing table on the temporal axis:
- maxes
Sequence[Scheduled
Query Recently Failed Run Query Insights Response Query Temporal Range Maxis] - Insights into the most sub-optimal performing table on the temporal axis:
- maxes List<Property Map>
- Insights into the most sub-optimal performing table on the temporal axis:
ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeMaxis, ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeMaxisArgs
, ScheduledQueryRecentlyFailedRunQueryInsightsResponseQueryTemporalRangeMaxisArgs
ScheduledQueryScheduleConfiguration, ScheduledQueryScheduleConfigurationArgs
, ScheduledQueryScheduleConfigurationArgs
- Schedule
Expression This property is required. string - When to trigger the scheduled query run. This can be a cron expression or a rate expression.
- Schedule
Expression This property is required. string - When to trigger the scheduled query run. This can be a cron expression or a rate expression.
- schedule
Expression This property is required. String - When to trigger the scheduled query run. This can be a cron expression or a rate expression.
- schedule
Expression This property is required. string - When to trigger the scheduled query run. This can be a cron expression or a rate expression.
- schedule_
expression This property is required. str - When to trigger the scheduled query run. This can be a cron expression or a rate expression.
- schedule
Expression This property is required. String - When to trigger the scheduled query run. This can be a cron expression or a rate expression.
ScheduledQueryTargetConfiguration, ScheduledQueryTargetConfigurationArgs
, ScheduledQueryTargetConfigurationArgs
- Timestream
Configuration ScheduledQuery Target Configuration Timestream Configuration - Configuration block for information needed to write data into the Timestream database and table. See below.
- Timestream
Configuration ScheduledQuery Target Configuration Timestream Configuration - Configuration block for information needed to write data into the Timestream database and table. See below.
- timestream
Configuration ScheduledQuery Target Configuration Timestream Configuration - Configuration block for information needed to write data into the Timestream database and table. See below.
- timestream
Configuration ScheduledQuery Target Configuration Timestream Configuration - Configuration block for information needed to write data into the Timestream database and table. See below.
- timestream_
configuration ScheduledQuery Target Configuration Timestream Configuration - Configuration block for information needed to write data into the Timestream database and table. See below.
- timestream
Configuration Property Map - Configuration block for information needed to write data into the Timestream database and table. See below.
ScheduledQueryTargetConfigurationTimestreamConfiguration, ScheduledQueryTargetConfigurationTimestreamConfigurationArgs
, ScheduledQueryTargetConfigurationTimestreamConfigurationArgs
- Database
Name This property is required. string - Name of Timestream database to which the query result will be written.
- Table
Name This property is required. string - Name of Timestream table that the query result will be written to. The table should be within the same database that is provided in Timestream configuration.
- Time
Column This property is required. string - Column from query result that should be used as the time column in destination table. Column type for this should be TIMESTAMP.
- Dimension
Mappings List<ScheduledQuery Target Configuration Timestream Configuration Dimension Mapping> - Configuration block for mapping of column(s) from the query result to the dimension in the destination table. See below.
- Measure
Name stringColumn - Name of the measure column.
- Mixed
Measure List<ScheduledMappings Query Target Configuration Timestream Configuration Mixed Measure Mapping> - Configuration block for how to map measures to multi-measure records. See below.
- Multi
Measure ScheduledMappings Query Target Configuration Timestream Configuration Multi Measure Mappings - Configuration block for multi-measure mappings. Only one of
mixed_measure_mappingsormulti_measure_mappingscan be provided.multi_measure_mappingscan be used to ingest data as multi measures in the derived table. See below.
- Database
Name This property is required. string - Name of Timestream database to which the query result will be written.
- Table
Name This property is required. string - Name of Timestream table that the query result will be written to. The table should be within the same database that is provided in Timestream configuration.
- Time
Column This property is required. string - Column from query result that should be used as the time column in destination table. Column type for this should be TIMESTAMP.
- Dimension
Mappings []ScheduledQuery Target Configuration Timestream Configuration Dimension Mapping - Configuration block for mapping of column(s) from the query result to the dimension in the destination table. See below.
- Measure
Name stringColumn - Name of the measure column.
- Mixed
Measure []ScheduledMappings Query Target Configuration Timestream Configuration Mixed Measure Mapping - Configuration block for how to map measures to multi-measure records. See below.
- Multi
Measure ScheduledMappings Query Target Configuration Timestream Configuration Multi Measure Mappings - Configuration block for multi-measure mappings. Only one of
mixed_measure_mappingsormulti_measure_mappingscan be provided.multi_measure_mappingscan be used to ingest data as multi measures in the derived table. See below.
- database
Name This property is required. String - Name of Timestream database to which the query result will be written.
- table
Name This property is required. String - Name of Timestream table that the query result will be written to. The table should be within the same database that is provided in Timestream configuration.
- time
Column This property is required. String - Column from query result that should be used as the time column in destination table. Column type for this should be TIMESTAMP.
- dimension
Mappings List<ScheduledQuery Target Configuration Timestream Configuration Dimension Mapping> - Configuration block for mapping of column(s) from the query result to the dimension in the destination table. See below.
- measure
Name StringColumn - Name of the measure column.
- mixed
Measure List<ScheduledMappings Query Target Configuration Timestream Configuration Mixed Measure Mapping> - Configuration block for how to map measures to multi-measure records. See below.
- multi
Measure ScheduledMappings Query Target Configuration Timestream Configuration Multi Measure Mappings - Configuration block for multi-measure mappings. Only one of
mixed_measure_mappingsormulti_measure_mappingscan be provided.multi_measure_mappingscan be used to ingest data as multi measures in the derived table. See below.
- database
Name This property is required. string - Name of Timestream database to which the query result will be written.
- table
Name This property is required. string - Name of Timestream table that the query result will be written to. The table should be within the same database that is provided in Timestream configuration.
- time
Column This property is required. string - Column from query result that should be used as the time column in destination table. Column type for this should be TIMESTAMP.
- dimension
Mappings ScheduledQuery Target Configuration Timestream Configuration Dimension Mapping[] - Configuration block for mapping of column(s) from the query result to the dimension in the destination table. See below.
- measure
Name stringColumn - Name of the measure column.
- mixed
Measure ScheduledMappings Query Target Configuration Timestream Configuration Mixed Measure Mapping[] - Configuration block for how to map measures to multi-measure records. See below.
- multi
Measure ScheduledMappings Query Target Configuration Timestream Configuration Multi Measure Mappings - Configuration block for multi-measure mappings. Only one of
mixed_measure_mappingsormulti_measure_mappingscan be provided.multi_measure_mappingscan be used to ingest data as multi measures in the derived table. See below.
- database_
name This property is required. str - Name of Timestream database to which the query result will be written.
- table_
name This property is required. str - Name of Timestream table that the query result will be written to. The table should be within the same database that is provided in Timestream configuration.
- time_
column This property is required. str - Column from query result that should be used as the time column in destination table. Column type for this should be TIMESTAMP.
- dimension_
mappings Sequence[ScheduledQuery Target Configuration Timestream Configuration Dimension Mapping] - Configuration block for mapping of column(s) from the query result to the dimension in the destination table. See below.
- measure_
name_ strcolumn - Name of the measure column.
- mixed_
measure_ Sequence[Scheduledmappings Query Target Configuration Timestream Configuration Mixed Measure Mapping] - Configuration block for how to map measures to multi-measure records. See below.
- multi_
measure_ Scheduledmappings Query Target Configuration Timestream Configuration Multi Measure Mappings - Configuration block for multi-measure mappings. Only one of
mixed_measure_mappingsormulti_measure_mappingscan be provided.multi_measure_mappingscan be used to ingest data as multi measures in the derived table. See below.
- database
Name This property is required. String - Name of Timestream database to which the query result will be written.
- table
Name This property is required. String - Name of Timestream table that the query result will be written to. The table should be within the same database that is provided in Timestream configuration.
- time
Column This property is required. String - Column from query result that should be used as the time column in destination table. Column type for this should be TIMESTAMP.
- dimension
Mappings List<Property Map> - Configuration block for mapping of column(s) from the query result to the dimension in the destination table. See below.
- measure
Name StringColumn - Name of the measure column.
- mixed
Measure List<Property Map>Mappings - Configuration block for how to map measures to multi-measure records. See below.
- multi
Measure Property MapMappings - Configuration block for multi-measure mappings. Only one of
mixed_measure_mappingsormulti_measure_mappingscan be provided.multi_measure_mappingscan be used to ingest data as multi measures in the derived table. See below.
ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMapping, ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs
, ScheduledQueryTargetConfigurationTimestreamConfigurationDimensionMappingArgs
- Dimension
Value Type This property is required. string - Type for the dimension. Valid value:
VARCHAR. - Name
This property is required. string - Column name from query result.
- Dimension
Value Type This property is required. string - Type for the dimension. Valid value:
VARCHAR. - Name
This property is required. string - Column name from query result.
- dimension
Value Type This property is required. String - Type for the dimension. Valid value:
VARCHAR. - name
This property is required. String - Column name from query result.
- dimension
Value Type This property is required. string - Type for the dimension. Valid value:
VARCHAR. - name
This property is required. string - Column name from query result.
- dimension_
value_ type This property is required. str - Type for the dimension. Valid value:
VARCHAR. - name
This property is required. str - Column name from query result.
- dimension
Value Type This property is required. String - Type for the dimension. Valid value:
VARCHAR. - name
This property is required. String - Column name from query result.
ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMapping, ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingArgs
, ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingArgs
- Measure
Value Type This property is required. string - Type of the value that is to be read from
source_column. Valid values areBIGINT,BOOLEAN,DOUBLE,VARCHAR,MULTI. - Measure
Name string - Refers to the value of measure_name in a result row. This field is required if
measure_name_columnis provided. - Multi
Measure List<ScheduledAttribute Mappings Query Target Configuration Timestream Configuration Mixed Measure Mapping Multi Measure Attribute Mapping> - Configuration block for attribute mappings for
MULTIvalue measures. Required whenmeasure_value_typeisMULTI. See below. - Source
Column string - Source column from which measure-value is to be read for result materialization.
- Target
Measure stringName - Target measure name to be used. If not provided, the target measure name by default is
measure_name, if provided, orsource_columnotherwise.
- Measure
Value Type This property is required. string - Type of the value that is to be read from
source_column. Valid values areBIGINT,BOOLEAN,DOUBLE,VARCHAR,MULTI. - Measure
Name string - Refers to the value of measure_name in a result row. This field is required if
measure_name_columnis provided. - Multi
Measure []ScheduledAttribute Mappings Query Target Configuration Timestream Configuration Mixed Measure Mapping Multi Measure Attribute Mapping - Configuration block for attribute mappings for
MULTIvalue measures. Required whenmeasure_value_typeisMULTI. See below. - Source
Column string - Source column from which measure-value is to be read for result materialization.
- Target
Measure stringName - Target measure name to be used. If not provided, the target measure name by default is
measure_name, if provided, orsource_columnotherwise.
- measure
Value Type This property is required. String - Type of the value that is to be read from
source_column. Valid values areBIGINT,BOOLEAN,DOUBLE,VARCHAR,MULTI. - measure
Name String - Refers to the value of measure_name in a result row. This field is required if
measure_name_columnis provided. - multi
Measure List<ScheduledAttribute Mappings Query Target Configuration Timestream Configuration Mixed Measure Mapping Multi Measure Attribute Mapping> - Configuration block for attribute mappings for
MULTIvalue measures. Required whenmeasure_value_typeisMULTI. See below. - source
Column String - Source column from which measure-value is to be read for result materialization.
- target
Measure StringName - Target measure name to be used. If not provided, the target measure name by default is
measure_name, if provided, orsource_columnotherwise.
- measure
Value Type This property is required. string - Type of the value that is to be read from
source_column. Valid values areBIGINT,BOOLEAN,DOUBLE,VARCHAR,MULTI. - measure
Name string - Refers to the value of measure_name in a result row. This field is required if
measure_name_columnis provided. - multi
Measure ScheduledAttribute Mappings Query Target Configuration Timestream Configuration Mixed Measure Mapping Multi Measure Attribute Mapping[] - Configuration block for attribute mappings for
MULTIvalue measures. Required whenmeasure_value_typeisMULTI. See below. - source
Column string - Source column from which measure-value is to be read for result materialization.
- target
Measure stringName - Target measure name to be used. If not provided, the target measure name by default is
measure_name, if provided, orsource_columnotherwise.
- measure_
value_ type This property is required. str - Type of the value that is to be read from
source_column. Valid values areBIGINT,BOOLEAN,DOUBLE,VARCHAR,MULTI. - measure_
name str - Refers to the value of measure_name in a result row. This field is required if
measure_name_columnis provided. - multi_
measure_ Sequence[Scheduledattribute_ mappings Query Target Configuration Timestream Configuration Mixed Measure Mapping Multi Measure Attribute Mapping] - Configuration block for attribute mappings for
MULTIvalue measures. Required whenmeasure_value_typeisMULTI. See below. - source_
column str - Source column from which measure-value is to be read for result materialization.
- target_
measure_ strname - Target measure name to be used. If not provided, the target measure name by default is
measure_name, if provided, orsource_columnotherwise.
- measure
Value Type This property is required. String - Type of the value that is to be read from
source_column. Valid values areBIGINT,BOOLEAN,DOUBLE,VARCHAR,MULTI. - measure
Name String - Refers to the value of measure_name in a result row. This field is required if
measure_name_columnis provided. - multi
Measure List<Property Map>Attribute Mappings - Configuration block for attribute mappings for
MULTIvalue measures. Required whenmeasure_value_typeisMULTI. See below. - source
Column String - Source column from which measure-value is to be read for result materialization.
- target
Measure StringName - Target measure name to be used. If not provided, the target measure name by default is
measure_name, if provided, orsource_columnotherwise.
ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingMultiMeasureAttributeMapping, ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingMultiMeasureAttributeMappingArgs
, ScheduledQueryTargetConfigurationTimestreamConfigurationMixedMeasureMappingMultiMeasureAttributeMappingArgs
- Measure
Value Type This property is required. string - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - Source
Column This property is required. string - Source column from where the attribute value is to be read.
- Target
Multi stringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- Measure
Value Type This property is required. string - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - Source
Column This property is required. string - Source column from where the attribute value is to be read.
- Target
Multi stringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- measure
Value Type This property is required. String - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - source
Column This property is required. String - Source column from where the attribute value is to be read.
- target
Multi StringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- measure
Value Type This property is required. string - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - source
Column This property is required. string - Source column from where the attribute value is to be read.
- target
Multi stringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- measure_
value_ type This property is required. str - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - source_
column This property is required. str - Source column from where the attribute value is to be read.
- target_
multi_ strmeasure_ attribute_ name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- measure
Value Type This property is required. String - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - source
Column This property is required. String - Source column from where the attribute value is to be read.
- target
Multi StringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappings, ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs
, ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsArgs
- Multi
Measure List<ScheduledAttribute Mappings Query Target Configuration Timestream Configuration Multi Measure Mappings Multi Measure Attribute Mapping> - Attribute mappings to be used for mapping query results to ingest data for multi-measure attributes. See above.
- Target
Multi stringMeasure Name - Name of the target multi-measure name in the derived table. This input is required when
measure_name_columnis not provided. Ifmeasure_name_columnis provided, then the value from that column will be used as the multi-measure name.
- Multi
Measure []ScheduledAttribute Mappings Query Target Configuration Timestream Configuration Multi Measure Mappings Multi Measure Attribute Mapping - Attribute mappings to be used for mapping query results to ingest data for multi-measure attributes. See above.
- Target
Multi stringMeasure Name - Name of the target multi-measure name in the derived table. This input is required when
measure_name_columnis not provided. Ifmeasure_name_columnis provided, then the value from that column will be used as the multi-measure name.
- multi
Measure List<ScheduledAttribute Mappings Query Target Configuration Timestream Configuration Multi Measure Mappings Multi Measure Attribute Mapping> - Attribute mappings to be used for mapping query results to ingest data for multi-measure attributes. See above.
- target
Multi StringMeasure Name - Name of the target multi-measure name in the derived table. This input is required when
measure_name_columnis not provided. Ifmeasure_name_columnis provided, then the value from that column will be used as the multi-measure name.
- multi
Measure ScheduledAttribute Mappings Query Target Configuration Timestream Configuration Multi Measure Mappings Multi Measure Attribute Mapping[] - Attribute mappings to be used for mapping query results to ingest data for multi-measure attributes. See above.
- target
Multi stringMeasure Name - Name of the target multi-measure name in the derived table. This input is required when
measure_name_columnis not provided. Ifmeasure_name_columnis provided, then the value from that column will be used as the multi-measure name.
- multi_
measure_ Sequence[Scheduledattribute_ mappings Query Target Configuration Timestream Configuration Multi Measure Mappings Multi Measure Attribute Mapping] - Attribute mappings to be used for mapping query results to ingest data for multi-measure attributes. See above.
- target_
multi_ strmeasure_ name - Name of the target multi-measure name in the derived table. This input is required when
measure_name_columnis not provided. Ifmeasure_name_columnis provided, then the value from that column will be used as the multi-measure name.
- multi
Measure List<Property Map>Attribute Mappings - Attribute mappings to be used for mapping query results to ingest data for multi-measure attributes. See above.
- target
Multi StringMeasure Name - Name of the target multi-measure name in the derived table. This input is required when
measure_name_columnis not provided. Ifmeasure_name_columnis provided, then the value from that column will be used as the multi-measure name.
ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMapping, ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
, ScheduledQueryTargetConfigurationTimestreamConfigurationMultiMeasureMappingsMultiMeasureAttributeMappingArgs
- Measure
Value Type This property is required. string - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - Source
Column This property is required. string - Source column from where the attribute value is to be read.
- Target
Multi stringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- Measure
Value Type This property is required. string - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - Source
Column This property is required. string - Source column from where the attribute value is to be read.
- Target
Multi stringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- measure
Value Type This property is required. String - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - source
Column This property is required. String - Source column from where the attribute value is to be read.
- target
Multi StringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- measure
Value Type This property is required. string - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - source
Column This property is required. string - Source column from where the attribute value is to be read.
- target
Multi stringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- measure_
value_ type This property is required. str - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - source_
column This property is required. str - Source column from where the attribute value is to be read.
- target_
multi_ strmeasure_ attribute_ name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
- measure
Value Type This property is required. String - Type of the attribute to be read from the source column. Valid values are
BIGINT,BOOLEAN,DOUBLE,VARCHAR,TIMESTAMP. - source
Column This property is required. String - Source column from where the attribute value is to be read.
- target
Multi StringMeasure Attribute Name - Custom name to be used for attribute name in derived table. If not provided,
source_columnis used.
ScheduledQueryTimeouts, ScheduledQueryTimeoutsArgs
, ScheduledQueryTimeoutsArgs
- Create string
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- Delete string
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
- Update string
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- Create string
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- Delete string
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
- Update string
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- create String
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- delete String
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
- update String
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- create string
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- delete string
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
- update string
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- create str
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- delete str
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
- update str
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- create String
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
- delete String
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours). Setting a timeout for a Delete operation is only applicable if changes are saved into state before the destroy operation occurs.
- update String
- A string that can be parsed as a duration consisting of numbers and unit suffixes, such as "30s" or "2h45m". Valid time units are "s" (seconds), "m" (minutes), "h" (hours).
Import
Using pulumi import, import Timestream Query Scheduled Query using the arn. For example:
$ pulumi import aws:timestreamquery/scheduledQuery:ScheduledQuery example arn:aws:timestream:us-west-2:012345678901:scheduled-query/tf-acc-test-7774188528604787105-e13659544fe66c8d
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- AWS Classic pulumi/pulumi-aws
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
awsTerraform Provider.
- Example Usage
- Basic Usage
- Multi-step Example
- Step 1. Create the prerequisite infrastructure
- Step 3. Create the scheduled query
- Create ScheduledQuery Resource
- Constructor syntax
- Constructor example
- ScheduledQuery Resource Properties
- Inputs
- Outputs
- Look up Existing ScheduledQuery Resource
- Supporting Types
- Import
- Package Details