A map transformer to duplicate, filter, hash, mask and do many more small transformations in your extract & load pipelines. Implements the Stream Maps
capability.
This mapper plugin is fully compliant with the Singer Spec and can be placed in between any Singer tap and target.
For a collection of examples, take a look at examples/README.md.
Here's one of them!:
-
Add this plugin to your Meltano project
meltano add mapper meltano-map-transformer
-
Install the plugin
meltano install
-
Configure the plugin
# meltano.yml plugins: mappers: - name: meltano-map-transformer pip_url: "git+https://github.com/MeltanoLabs/meltano-map-transform.git" executable: meltano-map-transform mappings: - name: hash_email config: stream_maps: customers: email: null # drop the PII field from RECORD and SCHEMA messages email_domain: email.split('@')[-1] email_hash: md5(config['hash_seed'] + email) __else__: null # drop all other fields stream_map_config: hash_seed: 01AWZh7A6DzGm6iJZZ2T
-
Use the plugin in your pipelines
meltano run tap-csv hash_email target-sqlite
stream-maps
Setting | Required | Default | Description |
---|---|---|---|
stream_maps | True | None | Stream maps |
A full list of supported settings and capabilities is available by running: meltano-map-transformer --about
We recommend using GitHub release tags when installing with pip
. We also recommend using pipx
or meltano
instead of installing with pip
directly.
You can see a full list of published releases here.
For example:
# Update the below with the latest published release:
# https://github.com/MeltanoLabs/meltano-map-transform/releases
# Install with pip, ideally in a new virtual environment to avoid conflicts:
pip install git+https://github.com/MeltanoLabs/meltano-map-transform.git@v0.0.1
# Or better yet, use `pipx` so that virtual environments are managed automatically:
pipx install git+https://github.com/MeltanoLabs/meltano-map-transform.git@v0.0.1