1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
1
Hello Ryan,
Your method of grouping the UserActivityLog message using EventId to relate group of query messages ran by the user in Redshift Editor is correct.
This is by design that when a user runs a query like:
select 1 AS TestMarker_8, *
from
mydb
AS multiline_query_8;
Then the Redshift Service would log 4 messages in CloudWatch as you could observe in your case, this occurred as the query is structured across 4 lines, when the query is executed by the user the logging service will dispatch/publish each line as a separate event to CloudWatch, with EventId in ascending order as they are triggered sequentially during query execution.
Also, if the same query is re-structured as:
select 1 AS TestMarker_8, * from mydb AS multiline_query_8;
Then is such case there will be just one Log event pushed to CloudWatch as the entire query is structured in 1 line.
respondido hace 4 meses
Contenido relevante
- OFICIAL DE AWSActualizada hace 4 años
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 3 años
Assuming that I'm looking at the log entries for a query with multiple lines and aggregating them by the event id, how will I know when I've reached the last line?
I got confirmation that the only way to find the last line was looking for the timestamp and the word log(e.g. [2024-01-04T20:19:26Z UTC][LOG] per support case 170440253001680).