tap-sqlalchemy

tap-sqlalchemy is a Singer tap for SQLAlchemy.

Built with the Meltano Tap SDK for Singer Taps.

Installation

pipx install git+https://github.com/MeltanoLabs/tap-sqlalchemy.git

Configuration

Accepted Config Options

• database_url

A full list of supported settings and capabilities for this tap is available by running:

tap-sqlalchemy --about

Source Authentication and Authorization

Authentication is performed using AWS credentials, as provided from config settings descried above.

Usage

You can easily run tap-sqlalchemy by itself or in a pipeline using Meltano.

Executing the Tap Directly

tap-sqlalchemy --version
tap-sqlalchemy --help
tap-sqlalchemy --config CONFIG --discover > ./catalog.json

Developer Resources

Initialize your Development Environment

pipx install poetry
poetry install

Create and Run Tests

Create tests within the tap_sqlalchemy/tests subfolder and then run:

poetry run pytest

You can also test the tap-sqlalchemy CLI interface directly using poetry run:

poetry run tap-sqlalchemy --help

Testing with Meltano

Note: This tap will work in any Singer environment and does not require Meltano. Examples here are for convenience and to streamline end-to-end orchestration scenarios.

Your project comes with a custom meltano.yml project file already created. Open the meltano.yml and follow any "TODO" items listed in the file.

Next, install Meltano (if you haven't already) and any needed plugins:

# Install meltano
pipx install meltano
# Initialize meltano within this directory
cd tap-sqlalchemy
meltano install

Now you can test and orchestrate using Meltano:

# Test invocation:
meltano invoke tap-sqlalchemy --version
# OR run a test `elt` pipeline:
meltano elt tap-sqlalchemy target-jsonl

SDK Dev Guide

See the dev guide for more instructions on how to use the SDK to develop your own taps and targets.