ETL::Yertl::Help::Cookbook - Some recipies for common ETL tasks
version 0.034
This document describes how to do some common ETL tasks
When you've got serialized JSON in a database field, you can use jq to deserialize it:
jq
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
Doug Bell <preaction@cpan.org>
This software is copyright (c) 2016 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.
To install ETL::Yertl, copy and paste the appropriate command in to your terminal.
cpanm
cpanm ETL::Yertl
CPAN shell
perl -MCPAN -e shell install ETL::Yertl
For more information on module installation, please visit the detailed CPAN module installation guide.