By using AWS re:Post, you agree to the Terms of Use
AWS re:Postre:Post

How to get glue to discover an eventbridge payload for use in CDK gluetable deployment?

0

New to glue and athena.

I have a great toy example by an AWS community builder working. But in my real use case, I want to capture all the fields from an eventbridge event 'detail' section and have columns created. This is nested multiple levels. I can't figure out the schema discovery process. Tried to post a text file to S3 and have a glue crawler work on it but no luck.

Thanks in advance.

Topics
AnalyticsDatabase
Tags
Amazon AthenaAnalyticsAWS GlueExtract Transform & Load Data
Language
English
Vince_bighire_tools
asked 13 days ago10 views
1 Answer
1
Accepted Answer

The crawler is for data, not likely to work well on metadata like that.
You could for instance run an AWS Lambda that reads the json event using pandas (which will infer the schema).

However, my advice is not to deploy tables (at least tables that evolve) using CDK, let the code/crawlers maintain it. What it sounds you are trying to do (coordinate CDK deployments with tables changes is going to be problematic)

profile picture
AWS
Gonzalo Herreros
answered 13 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content