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.

preguntada hace un año204 visualizaciones
1 Respuesta
1
Respuesta aceptada

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 pictureAWS
EXPERTO
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas