Extracts
Read from various data sources.
Transforms
Shape and optimize for your needs.
Loads
Store and secure in one of many available data sinks.
Examples:
Code
<?php
declare(strict_types=1);
use function Flow\ETL\DSL\{array_entry, data_frame, from_rows, int_entry, ref, row, rows, to_stream};
require __DIR__ . '/../../../autoload.php';
data_frame()
->read(from_rows(rows(
row(int_entry('id', 1), array_entry('array', ['a' => 1, 'b' => 2, 'c' => 3])),
)))
->withEntry('array_size', ref('array')->size())
->write(to_stream(__DIR__ . '/output.txt', truncate: false))
->run();
Output
+----+---------------------+------------+
| id | array | array_size |
+----+---------------------+------------+
| 1 | {"a":1,"b":2,"c":3} | 3 |
+----+---------------------+------------+
1 rows