NAME
ETL::Yertl::Help::Cookbook - Some recipies for common ETL tasks
VERSION
version 0.044
DESCRIPTION
This document describes how to do some common ETL tasks
EMBEDDED DOCUMENTS
When you've got serialized JSON in a database field, you can use jq
to deserialize it:
ysql TESTDB 'SELECT json_field FROM table' # Query the database
| yto json # Convert to JSON for jq
| js '.json_field | fromjson' # Inflate the JSON
| yfrom json # Convert back to Yertl
AUTHOR
Doug Bell <preaction@cpan.org>
COPYRIGHT AND LICENSE
This software is copyright (c) 2018 by Doug Bell.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.