athena-struct-parser
v1.1.0
Published
Parser for AWS Athena's structs
Downloads
1,429
Readme
athena-struct-parser
A small utility to parse out structs returned by AWS Athena. Tools such as athena-express
do a great job at querying Athena, however there's no easy way to get freeform JSON out of it. This tool allows one to parse the Athena's structs & Arrays into JS objects.
Problem
Let's take the following code as an example:
const results = await athenaExpress.query('SELECT struct, foo, bar FROM my_table');
// `results` is:
// {
// "Items": [
// {
// "struct": "{foo=bar, baz=[{foe=moe}]}",
// "foo": "baz",
// "bar": zab
// }
// ]
// }
It's not easy to get the data out of that struct
column, even if that's pretty common way to store data (as JSON blobs). One could try to use a rudimentary parser, but it might trip up on un-escaped characters.
Usage
Install the library via:
npm i athena-struct-parser
import parseStruct from 'athena-struct-parser';
const results = await athenaExpress.query('SELECT struct, foo, bar FROM my_table');
results.Items.map(result => {
result.struct = parseStruct(result.struct);
return result;
});
// `results.struct` now contains JS object with data from the struct:
// {
// "Items": [
// {
// "struct": {
// "foo": "bar",
// "baz": [
// {
// "foe": "moe"
// }
// ]
// }",
// "foo": "baz",
// "bar": zab
// }
// ]
// }