QueryStringProps Struct
Properties for a QueryString.
Example
new logs.QueryDefinition(this, 'QueryDefinition', {
queryDefinitionName: 'MyQuery',
queryString: new logs.QueryString({
fields: ['@timestamp', '@message'],
parseStatements: [
'@message "[*] *" as loggingType, loggingMessage',
'@message "<*>: *" as differentLoggingType, differentLoggingMessage',
],
filterStatements: [
'loggingType = "ERROR"',
'loggingMessage = "A very strange error occurred!"',
],
statsStatements: [
'count(loggingMessage) as loggingErrors',
'count(differentLoggingMessage) as differentLoggingErrors',
],
sort: '@timestamp desc',
limit: 20,
}),
});
logs.QueryDefinition(self, "QueryDefinition",
query_definition_name="MyQuery",
query_string=logs.QueryString(
fields=["@timestamp", "@message"],
parse_statements=["@message \"[*] *\" as loggingType, loggingMessage", "@message \"<*>: *\" as differentLoggingType, differentLoggingMessage"
],
filter_statements=["loggingType = \"ERROR\"", "loggingMessage = \"A very strange error occurred!\""
],
stats_statements=["count(loggingMessage) as loggingErrors", "count(differentLoggingMessage) as differentLoggingErrors"
],
sort="@timestamp desc",
limit=20
)
)
QueryDefinition.Builder.create(this, "QueryDefinition")
.queryDefinitionName("MyQuery")
.queryString(QueryString.Builder.create()
.fields(List.of("@timestamp", "@message"))
.parseStatements(List.of("@message \"[*] *\" as loggingType, loggingMessage", "@message \"<*>: *\" as differentLoggingType, differentLoggingMessage"))
.filterStatements(List.of("loggingType = \"ERROR\"", "loggingMessage = \"A very strange error occurred!\""))
.statsStatements(List.of("count(loggingMessage) as loggingErrors", "count(differentLoggingMessage) as differentLoggingErrors"))
.sort("@timestamp desc")
.limit(20)
.build())
.build();
// Install: dotnet add package Amazon.CDK.Lib
new QueryDefinition(this, "QueryDefinition", new QueryDefinitionProps {
QueryDefinitionName = "MyQuery",
QueryString = new QueryString(new QueryStringProps {
Fields = new [] { "@timestamp", "@message" },
ParseStatements = new [] { "@message \"[*] *\" as loggingType, loggingMessage", "@message \"<*>: *\" as differentLoggingType, differentLoggingMessage" },
FilterStatements = new [] { "loggingType = \"ERROR\"", "loggingMessage = \"A very strange error occurred!\"" },
StatsStatements = new [] { "count(loggingMessage) as loggingErrors", "count(differentLoggingMessage) as differentLoggingErrors" },
Sort = "@timestamp desc",
Limit = 20
})
});
// Install: go get github.com/aws/aws-cdk-go/awscdk/v2
logs.NewQueryDefinition(this, jsii.String("QueryDefinition"), &QueryDefinitionProps{
QueryDefinitionName: jsii.String("MyQuery"),
QueryString: logs.NewQueryString(&QueryStringProps{
Fields: []*string{
jsii.String("@timestamp"),
jsii.String("@message"),
},
ParseStatements: []*string{
jsii.String("@message \"[*] *\" as loggingType, loggingMessage"),
jsii.String("@message \"<*>: *\" as differentLoggingType, differentLoggingMessage"),
},
FilterStatements: []*string{
jsii.String("loggingType = \"ERROR\""),
jsii.String("loggingMessage = \"A very strange error occurred!\""),
},
StatsStatements: []*string{
jsii.String("count(loggingMessage) as loggingErrors"),
jsii.String("count(differentLoggingMessage) as differentLoggingErrors"),
},
Sort: jsii.String("@timestamp desc"),
Limit: jsii.Number(20),
}),
})
Properties
displayoptionalstringdisplayoptionalstrdisplayoptionalStringDisplayoptionalstringDisplayoptional*string#Default: no display in QueryString
fieldsoptionalstring[]fieldsoptionaltyping.List[str]fieldsoptionalList<String>Fieldsoptionalstring[]Fieldsoptional*[]*string#Default: no fields in QueryString
filteroptionalstringfilteroptionalstrfilteroptionalStringFilteroptionalstringFilteroptional*stringdeprecated#Default: no filter in QueryString
filterStatementsoptionalstring[]filter_statementsoptionaltyping.List[str]filterStatementsoptionalList<String>FilterStatementsoptionalstring[]FilterStatementsoptional*[]*string#Default: no filter in QueryString
Each provided statement generates a separate filter line in the query string.
Note: If provided, this property overrides any value provided for the filter property.
limitoptionalnumberlimitoptionalint | floatlimitoptionalNumberLimitoptionaldoubleLimitoptional*float64#Default: no limit in QueryString
parseoptionalstringparseoptionalstrparseoptionalStringParseoptionalstringParseoptional*stringdeprecated#Default: no parse in QueryString
parseStatementsoptionalstring[]parse_statementsoptionaltyping.List[str]parseStatementsoptionalList<String>ParseStatementsoptionalstring[]ParseStatementsoptional*[]*string#Default: no parse in QueryString
Each provided statement generates a separate parse line in the query string.
Note: If provided, this property overrides any value provided for the parse property.
Default: no sort in QueryString
statsoptionalstringstatsoptionalstrstatsoptionalStringStatsoptionalstringStatsoptional*stringdeprecated#Default: no stats in QueryString
statsStatementsoptionalstring[]stats_statementsoptionaltyping.List[str]statsStatementsoptionalList<String>StatsStatementsoptionalstring[]StatsStatementsoptional*[]*string#Default: no stats in QueryString
notes
CloudWatch Logs Insights supports up to two stats commands in a single query. Each provided statement generates a separate stats line in the query string.
Note: If provided, this property overrides any value provided for the stats property.