Ability to load CloudWatch Logs query into Pandas

[CaseyBurnsSv]

It would be great to have the ability to load a pandas data frame from a CloudWatch Insights Query.

[igorborgest]

Hi @CaseyBurnsSv!

Sounds like a awesome plan, I will do that!

Thank you!

[igorborgest]

Hey @CaseyBurnsSv!

I'm happy to say that we already have the support for CloudWatch Insights Query in the new 0.0.1 version.

Now you can get a Pandas Dataframe with the result:

session = awswrangler.Session()

dataframe = session.pandas.read_log_query(
    log_group_names=[LOG_GROUP_NAME],
    query="fields @timestamp, @message | sort @timestamp desc | limit 5",
)

Or you also can get the raw result if you prefer:

session = awswrangler.Session()

results = session.cloudwatchlogs.query(
    log_group_names=[LOG_GROUP_NAME],
    query="fields @timestamp, @message | sort @timestamp desc | limit 5",
)

I hope you enjoy it!

[igorborgest]

Hi @CaseyBurnsSv,

I will close this issue by inactivity. Please, open a new one if you have more issues.

[CaseyBurnsSv]

Thanks @igorborgest