target-mysql
target-mysql
is a Singer target for MySQL.
(forked from radbrt/target-oracle)
Build with the Meltano Target SDK.
Configuration
Accepted Config Options
A full list of supported settings and capabilities for this
target is available by running:
target-mysql --about
Configure using environment variables
This Singer target will automatically import any environment variables within the working directory's
.env
if the --config=ENV
is provided, such that config values will be considered if a matching
environment variable is set either in the terminal context or in the .env
file.
Source Authentication and Authorization
Usage
You can easily run target-mysql
by itself or in a pipeline using Meltano.
Executing the Target Directly
target-mysql --version
target-mysql --help
tap-carbon-intensity | target-mysql --config /path/to/target-mysql-config.json
Developer Resources
Follow these instructions to contribute to this project.
Initialize your Development Environment
pipx install poetry
poetry install
Create and Run Tests
Create tests within the target_mysql/tests
subfolder and
then run:
poetry run pytest
You can also test the target-mysql
CLI interface directly using poetry run
:
poetry run target-mysql --help
Note: This target will work in any Singer environment and does not require Meltano.
Examples here are for convenience and to streamline end-to-end orchestration scenarios.
Next, install Meltano (if you haven't already) and any needed plugins:
pipx install meltano
cd target-mysql
meltano install
Now you can test and orchestrate using Meltano:
meltano invoke target-mysql --version
meltano elt tap-carbon-intensity target-mysql
SDK Dev Guide
See the dev guide for more instructions on how to use the Meltano Singer SDK to
develop your own Singer taps and targets.