CrateDB

cratedb (cratedb variant)🥇

CrateDB is a distributed and scalable multi-model SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.

The cratedb utility is a containerized single-node instance of CrateDB useful for local development.

Getting Started

Prerequisites

If you haven't already, follow the initial steps of the Getting Started guide:

  1. Install Meltano
  2. Create your Meltano project

Dependencies

CrateDB is packaged as an OCI image so you must have Docker or Podman installed before running the plugin.

Installation and configuration

  1. Add the cratedb utility to your project using
    meltano add
    :
  2. meltano add cratedb
  3. Configure the cratedb settings using
    meltano config
    :
  4. meltano config cratedb set --interactive

Next steps

  1. Launch CrateDB:

    meltano invoke --containers cratedb:start
    

    Connect with your PostgreSQL client at postgresql://crate:crate@localhost:15432/, use SQLAlchemy with crate://crate:crate@localhost:4200/, or use CrateDB shell like crash --host localhost:4200.

If you run into any issues, learn how to get help.

Capabilities

This plugin currently has no capabilities defined. If you know the capabilities required by this plugin, please contribute!

Settings

This plugin currently has no settings defined. If you know the settings required by this plugin, please contribute!

Commands

The cratedb utility supports the following commands that can be used with
meltano invoke
:

start

  • Equivalent to: start

meltano invoke cratedb:start [args...]

Something missing?

This page is generated from a YAML file that you can contribute changes to.

Edit it on GitHub!

Looking for help?

If you're having trouble getting the cratedb utility to work, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the
#plugins-general
channel.
Meltano Community Connector

CrateDB is built and maintained by the Meltano community. For connectors that are built, tested, and supported by the Meltano team, explore Meltano Cloud.

  • Expert support — get support from experts who build and support connectors on Meltano Cloud
  • Tested daily — daily monitoring catches issues before they hit your pipelines
  • Low maintenance — API changes, schema drift and breaking changes handled for you

Install

meltano add cratedb

Maintenance Status

  • Maintenance Status
  • Built with the Meltano SDK

Repo

https://github.com/crate/crate
  • Stars
  • Forks
  • Last Commit Date
  • Open Issues
  • Open PRs
  • Contributors
  • License

Maintainer

  • CrateDB

Keywords

  • meltano_sdkreal-timesearchaicratedbwarehouse