<p align="center">
<img src="https://raw.githubusercontent.com/dbt-labs/dbt/ec7dee39f793aa4f7dd3dae37282cc87664813e4/etc/dbt-logo-full.svg" alt="dbt logo" width="500"/>
<br/><br/>
<img src="https://github.com/user-attachments/assets/70485bb9-9809-46ce-a189-858676780b2b" alt="dbt logo" width="500"/>
</p>
<p align="center">
<a href="https://github.com/crate/dbt-cratedb2/actions/workflows/unit-tests.yml">
<img src="https://github.com/crate/dbt-cratedb2/actions/workflows/unit-tests.yml/badge.svg?event=push" alt="CI Badge » Unit Tests"/>
</a>
<a href="https://github.com/crate/dbt-cratedb2/actions/workflows/integration-tests.yml">
<img src="https://github.com/crate/dbt-cratedb2/actions/workflows/integration-tests.yml/badge.svg?event=push" alt="CI Badge » Integration Tests"/>
</a>
</p>
# dbt-cratedb2
[![Bluesky][badge-bluesky]][project-bluesky]
[![Release Notes][badge-release-notes]][project-release-notes]
[![Downloads per month][badge-downloads-per-month]][project-downloads]
[![Package version][badge-package-version]][project-pypi]
[![License][badge-license]][project-license]
[![Status][badge-status]][project-pypi]
[![Supported Python versions][badge-python-versions]][project-pypi]
» [Documentation]
| [Changelog]
| [PyPI]
| [Issues]
| [Source code]
| [License]
| [CrateDB]
| [Community Forum]
The `dbt-cratedb2` package contains all the code enabling [dbt] to work with
[CrateDB Self-Managed] or [CrateDB Cloud].
**[dbt]** enables data analysts and engineers to transform their data using the
same practices that software engineers use to build applications.
dbt is the T in ELT. Organize, cleanse, denormalize, filter, rename, and
pre-aggregate the raw data in your warehouse so that it's ready for analysis.
**[CrateDB]** is a distributed and scalable 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.
## Installation
Install the most recent version of dbt-cratedb2.
```shell
pip install --upgrade dbt-cratedb2
```
## Getting started
- [Install dbt](https://docs.getdbt.com/docs/core/installation-overview).
- Read the dbt [introduction](https://docs.getdbt.com/docs/introduction/) and
[viewpoint](https://docs.getdbt.com/community/resources/viewpoint).
- Read about how to [use dbt with CrateDB].
## What's Inside
CrateDB is PostgreSQL-compatible, that's why dbt-cratedb2
heavily builds upon the canonical [dbt-postgres] adapter.
For more information on using dbt with CrateDB,
consult [the docs].
### `psycopg2`
By default, `dbt-cratedb2` installs `psycopg2-binary`.
For more information, please visit [psycopg2 notes].
## Project Information
### Acknowledgements
Kudos to the authors of all the many software components this library is
inheriting from and building upon, most notably the [dbt-postgres]
package, and [dbt][dbt-core] itself.
### Contributing
The `dbt-cratedb2` package is an open source project, and is
[managed on GitHub]. We appreciate contributions of any kind.
- Want to report a bug or request a feature? Let us know by [opening an issue].
- Want to help us build dbt-cratedb2? Check out the [contributing guide].
- Join the community on the [CrateDB Community Discourse].
### License
The project uses the Apache Software License, like the dbt-postgres project
it is deriving from.
### Code of Conduct
Everyone interacting with Crate.io's codebases, issue trackers, chat rooms, and
mailing lists, please follow the [CrateDB Code of Conduct].
[contributing guide]: https://github.com/crate/dbt-cratedb2/blob/main/CONTRIBUTING.md
[CrateDB]: https://cratedb.com/database
[CrateDB Cloud]: https://cratedb.com/database/cloud
[CrateDB Self-Managed]: https://cratedb.com/database/self-managed
[CrateDB Code of Conduct]: https://github.com/crate/crate/blob/master/CODE_OF_CONDUCT.md
[CrateDB Community Discourse]: https://community.cratedb.com/
[dbt]: https://www.getdbt.com/
[dbt-core]: https://pypi.org/project/dbt-core/
[dbt-postgres]: https://pypi.org/project/dbt-postgres/
[opening an issue]: https://github.com/crate/dbt-cratedb2/issues/new
[psycopg2 notes]: https://github.com/crate/dbt-cratedb2/blob/genesis/docs/psycopg2.md
[the docs]: https://docs.getdbt.com/docs/core/connect-data-platform/cratedb-setup
[use dbt with CrateDB]: https://cratedb.com/docs/guide/integrate/dbt/
[Changelog]: https://github.com/crate/dbt-cratedb2/blob/main/CHANGELOG.md
[Community Forum]: https://community.cratedb.com/
[Documentation]: https://cratedb.com/docs/guide/integrate/dbt/
[Issues]: https://github.com/crate/dbt-cratedb2/issues
[License]: https://github.com/crate/dbt-cratedb2/blob/main/LICENSE
[managed on GitHub]: https://github.com/crate/dbt-cratedb2
[PyPI]: https://pypi.org/project/dbt-cratedb2/
[Source code]: https://github.com/crate/dbt-cratedb2
[badge-bluesky]: https://img.shields.io/badge/Bluesky-0285FF?logo=bluesky&logoColor=fff&label=Follow%20%40CrateDB
[badge-downloads-per-month]: https://pepy.tech/badge/dbt-cratedb2/month
[badge-license]: https://img.shields.io/github/license/crate/dbt-cratedb2.svg
[badge-package-version]: https://img.shields.io/pypi/v/dbt-cratedb2.svg
[badge-python-versions]: https://img.shields.io/pypi/pyversions/dbt-cratedb2.svg
[badge-release-notes]: https://img.shields.io/github/release/crate/dbt-cratedb2?label=Release+Notes
[badge-status]: https://img.shields.io/pypi/status/dbt-cratedb2.svg
[project-bluesky]: https://bsky.app/search?q=cratedb
[project-downloads]: https://pepy.tech/project/dbt-cratedb2/
[project-license]: https://github.com/crate/dbt-cratedb2/blob/main/LICENSE
[project-pypi]: https://pypi.org/project/dbt-cratedb2
[project-release-notes]: https://github.com/crate/dbt-cratedb2/releases
Raw data
{
"_id": null,
"home_page": null,
"name": "dbt-cratedb2",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.9.0",
"maintainer_email": "\"Crate.io\" <office@crate.io>",
"keywords": "adapter, adapters, cratedb, database, dbt, dbt-adapter, dbt-core, elt, postgresql",
"author": null,
"author_email": "\"Crate.io\" <office@crate.io>",
"download_url": "https://files.pythonhosted.org/packages/53/25/a7c7b86a97a1c9be927d3bac98ed39063565c5d1db3ac2691f3c2390dc75/dbt_cratedb2-0.1.0.tar.gz",
"platform": null,
"description": "<p align=\"center\">\n <img src=\"https://raw.githubusercontent.com/dbt-labs/dbt/ec7dee39f793aa4f7dd3dae37282cc87664813e4/etc/dbt-logo-full.svg\" alt=\"dbt logo\" width=\"500\"/>\n <br/><br/>\n <img src=\"https://github.com/user-attachments/assets/70485bb9-9809-46ce-a189-858676780b2b\" alt=\"dbt logo\" width=\"500\"/>\n</p>\n<p align=\"center\">\n <a href=\"https://github.com/crate/dbt-cratedb2/actions/workflows/unit-tests.yml\">\n <img src=\"https://github.com/crate/dbt-cratedb2/actions/workflows/unit-tests.yml/badge.svg?event=push\" alt=\"CI Badge \u00bb Unit Tests\"/>\n </a>\n <a href=\"https://github.com/crate/dbt-cratedb2/actions/workflows/integration-tests.yml\">\n <img src=\"https://github.com/crate/dbt-cratedb2/actions/workflows/integration-tests.yml/badge.svg?event=push\" alt=\"CI Badge \u00bb Integration Tests\"/>\n </a>\n</p>\n\n# dbt-cratedb2\n\n[![Bluesky][badge-bluesky]][project-bluesky]\n[![Release Notes][badge-release-notes]][project-release-notes]\n[![Downloads per month][badge-downloads-per-month]][project-downloads]\n\n[![Package version][badge-package-version]][project-pypi]\n[![License][badge-license]][project-license]\n[![Status][badge-status]][project-pypi]\n[![Supported Python versions][badge-python-versions]][project-pypi]\n\n\u00bb [Documentation]\n| [Changelog]\n| [PyPI]\n| [Issues]\n| [Source code]\n| [License]\n| [CrateDB]\n| [Community Forum]\n\nThe `dbt-cratedb2` package contains all the code enabling [dbt] to work with\n[CrateDB Self-Managed] or [CrateDB Cloud].\n\n**[dbt]** enables data analysts and engineers to transform their data using the\nsame practices that software engineers use to build applications.\ndbt is the T in ELT. Organize, cleanse, denormalize, filter, rename, and\npre-aggregate the raw data in your warehouse so that it's ready for analysis.\n\n**[CrateDB]** is a distributed and scalable SQL database for storing and\nanalyzing massive amounts of data in near real-time, even with complex queries.\nIt is PostgreSQL-compatible, and based on Lucene.\n\n## Installation\nInstall the most recent version of dbt-cratedb2.\n```shell\npip install --upgrade dbt-cratedb2\n```\n\n## Getting started\n\n- [Install dbt](https://docs.getdbt.com/docs/core/installation-overview).\n- Read the dbt [introduction](https://docs.getdbt.com/docs/introduction/) and\n [viewpoint](https://docs.getdbt.com/community/resources/viewpoint).\n- Read about how to [use dbt with CrateDB].\n\n## What's Inside\n\nCrateDB is PostgreSQL-compatible, that's why dbt-cratedb2\nheavily builds upon the canonical [dbt-postgres] adapter.\nFor more information on using dbt with CrateDB,\nconsult [the docs].\n\n### `psycopg2`\nBy default, `dbt-cratedb2` installs `psycopg2-binary`.\nFor more information, please visit [psycopg2 notes].\n\n\n## Project Information\n\n### Acknowledgements\nKudos to the authors of all the many software components this library is\ninheriting from and building upon, most notably the [dbt-postgres]\npackage, and [dbt][dbt-core] itself.\n\n### Contributing\nThe `dbt-cratedb2` package is an open source project, and is\n[managed on GitHub]. We appreciate contributions of any kind.\n\n- Want to report a bug or request a feature? Let us know by [opening an issue].\n- Want to help us build dbt-cratedb2? Check out the [contributing guide].\n- Join the community on the [CrateDB Community Discourse].\n\n### License\nThe project uses the Apache Software License, like the dbt-postgres project\nit is deriving from.\n\n### Code of Conduct\nEveryone interacting with Crate.io's codebases, issue trackers, chat rooms, and\nmailing lists, please follow the [CrateDB Code of Conduct].\n\n\n[contributing guide]: https://github.com/crate/dbt-cratedb2/blob/main/CONTRIBUTING.md\n[CrateDB]: https://cratedb.com/database\n[CrateDB Cloud]: https://cratedb.com/database/cloud\n[CrateDB Self-Managed]: https://cratedb.com/database/self-managed\n[CrateDB Code of Conduct]: https://github.com/crate/crate/blob/master/CODE_OF_CONDUCT.md\n[CrateDB Community Discourse]: https://community.cratedb.com/\n[dbt]: https://www.getdbt.com/\n[dbt-core]: https://pypi.org/project/dbt-core/\n[dbt-postgres]: https://pypi.org/project/dbt-postgres/\n[opening an issue]: https://github.com/crate/dbt-cratedb2/issues/new\n[psycopg2 notes]: https://github.com/crate/dbt-cratedb2/blob/genesis/docs/psycopg2.md\n[the docs]: https://docs.getdbt.com/docs/core/connect-data-platform/cratedb-setup\n[use dbt with CrateDB]: https://cratedb.com/docs/guide/integrate/dbt/\n\n[Changelog]: https://github.com/crate/dbt-cratedb2/blob/main/CHANGELOG.md\n[Community Forum]: https://community.cratedb.com/\n[Documentation]: https://cratedb.com/docs/guide/integrate/dbt/\n[Issues]: https://github.com/crate/dbt-cratedb2/issues\n[License]: https://github.com/crate/dbt-cratedb2/blob/main/LICENSE\n[managed on GitHub]: https://github.com/crate/dbt-cratedb2\n[PyPI]: https://pypi.org/project/dbt-cratedb2/\n[Source code]: https://github.com/crate/dbt-cratedb2\n\n[badge-bluesky]: https://img.shields.io/badge/Bluesky-0285FF?logo=bluesky&logoColor=fff&label=Follow%20%40CrateDB\n[badge-downloads-per-month]: https://pepy.tech/badge/dbt-cratedb2/month\n[badge-license]: https://img.shields.io/github/license/crate/dbt-cratedb2.svg\n[badge-package-version]: https://img.shields.io/pypi/v/dbt-cratedb2.svg\n[badge-python-versions]: https://img.shields.io/pypi/pyversions/dbt-cratedb2.svg\n[badge-release-notes]: https://img.shields.io/github/release/crate/dbt-cratedb2?label=Release+Notes\n[badge-status]: https://img.shields.io/pypi/status/dbt-cratedb2.svg\n[project-bluesky]: https://bsky.app/search?q=cratedb\n[project-downloads]: https://pepy.tech/project/dbt-cratedb2/\n[project-license]: https://github.com/crate/dbt-cratedb2/blob/main/LICENSE\n[project-pypi]: https://pypi.org/project/dbt-cratedb2\n[project-release-notes]: https://github.com/crate/dbt-cratedb2/releases\n",
"bugtrack_url": null,
"license": null,
"summary": "dbt adapter for CrateDB 5.x, derived from dbt-postgres",
"version": "0.1.0",
"project_urls": {
"Changelog": "https://github.com/crate/dbt-cratedb2/blob/main/CHANGELOG.md",
"Documentation": "https://cratedb.com/docs/guide/integrate/dbt/",
"Downloads": "https://pypi.org/project/dbt-cratedb2/#files",
"Homepage": "https://github.com/crate/dbt-cratedb2",
"Issues": "https://github.com/crate/dbt-cratedb2/issues",
"Release Notes": "https://github.com/crate/dbt-cratedb2/releases",
"Repository": "https://github.com/crate/dbt-cratedb2",
"Source Code": "https://github.com/crate/dbt-cratedb2"
},
"split_keywords": [
"adapter",
" adapters",
" cratedb",
" database",
" dbt",
" dbt-adapter",
" dbt-core",
" elt",
" postgresql"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "7b250a224c54b5cc8ccdf13ef58252e9d79375591791ca233c68aa63e482315a",
"md5": "76abf04233616ddc2aec4c86d5dae528",
"sha256": "1c3e5b374c6d65552c92e7e3a5de198246c4e11f2388cc9c1597f1ca682a47d2"
},
"downloads": -1,
"filename": "dbt_cratedb2-0.1.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "76abf04233616ddc2aec4c86d5dae528",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9.0",
"size": 23085,
"upload_time": "2024-12-22T02:45:11",
"upload_time_iso_8601": "2024-12-22T02:45:11.126752Z",
"url": "https://files.pythonhosted.org/packages/7b/25/0a224c54b5cc8ccdf13ef58252e9d79375591791ca233c68aa63e482315a/dbt_cratedb2-0.1.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "5325a7c7b86a97a1c9be927d3bac98ed39063565c5d1db3ac2691f3c2390dc75",
"md5": "bfbfb56a7d51995b84c38b0a0770776c",
"sha256": "51b88b8c38cab1a8c3634fdcecaa3b0c810bfba4f9fb8d1929221f197a7966fd"
},
"downloads": -1,
"filename": "dbt_cratedb2-0.1.0.tar.gz",
"has_sig": false,
"md5_digest": "bfbfb56a7d51995b84c38b0a0770776c",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9.0",
"size": 18721,
"upload_time": "2024-12-22T02:45:09",
"upload_time_iso_8601": "2024-12-22T02:45:09.925439Z",
"url": "https://files.pythonhosted.org/packages/53/25/a7c7b86a97a1c9be927d3bac98ed39063565c5d1db3ac2691f3c2390dc75/dbt_cratedb2-0.1.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-12-22 02:45:09",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "crate",
"github_project": "dbt-cratedb2",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "dbt-cratedb2"
}
JSON
