<p align="center">
<img src="https://raw.githubusercontent.com/dbt-labs/dbt/ec7dee39f793aa4f7dd3dae37282cc87664813e4/etc/dbt-logo-full.svg" alt="dbt logo" width="500"/>
</p>
<p align="center">
<a href="https://github.com/dbt-labs/dbt-spark/actions/workflows/main.yml">
<img src="https://github.com/dbt-labs/dbt-spark/actions/workflows/main.yml/badge.svg?event=push" alt="Unit Tests Badge"/>
</a>
<a href="https://circleci.com/gh/dbt-labs/dbt-spark/?branch=main">
<img src="https://circleci.com/gh/dbt-labs/dbt-spark/tree/main.svg?style=shield" alt="Integration Tests Badge"/>
</a>
</p>
**[dbt](https://www.getdbt.com/)** 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.
## dbt-spark
The `dbt-ocean-spark` package contains all of the code enabling dbt to work with Apache Spark on Ocean. For
more information, consult [the docs](https://docs.getdbt.com/docs/profile-spark).
## Getting started
- [Install dbt](https://docs.getdbt.com/docs/installation)
- Read the [introduction](https://docs.getdbt.com/docs/introduction/) and [viewpoint](https://docs.getdbt.com/docs/about/viewpoint/)
## Running locally
A `docker-compose` environment starts a Spark Thrift server and a Postgres database as a Hive Metastore backend.
Note: dbt-spark now supports Spark 3.1.1 (formerly on Spark 2.x).
The following command would start two docker containers
```
docker-compose up -d
```
It will take a bit of time for the instance to start, you can check the logs of the two containers.
If the instance doesn't start correctly, try the complete reset command listed below and then try start again.
Create a profile like this one:
```
spark_testing:
target: local
outputs:
local:
type: ocean_spark
method: http
host: api.spotinst.io
port: 443
cluster: osc-[clusterId]
account: acc-[accountId]
app: spark-hive-[appId]
schema: analytics
connect_retries: 5
connect_timeout: 60
retry_all: true
```
Connecting to the local spark instance:
* The Spark UI should be available at [http://console.spotinst.com/ocean/spark/cluster/{clusterId}/app/{appId}/sparkUI/jobs](http://localhost:4040/sqlserver/)
* The endpoint for SQL-based testing is at `http://localhost:10000` and can be referenced with the Hive or Spark JDBC drivers using connection string `jdbc:hive2://localhost:10000` and default credentials `dbt`:`dbt`
Note that the Hive metastore data is persisted under `./.hive-metastore/`, and the Spark-produced data under `./.spark-warehouse/`. To completely reset you environment run the following:
```
docker-compose down
rm -rf ./.hive-metastore/
rm -rf ./.spark-warehouse/
```
### Reporting bugs and contributing code
- Want to report a bug or request a feature? Let us know on [Slack](http://slack.getdbt.com/), or open [an issue](https://github.com/fishtown-analytics/dbt-spark/issues/new).
## Code of Conduct
Everyone interacting in the dbt project's codebases, issue trackers, chat rooms, and mailing lists is expected to follow the [PyPA Code of Conduct](https://www.pypa.io/en/latest/code-of-conduct/).
## Join the dbt Community
- Be part of the conversation in the [dbt Community Slack](http://community.getdbt.com/)
- Read more on the [dbt Community Discourse](https://discourse.getdbt.com)
## Reporting bugs and contributing code
- Want to report a bug or request a feature? Let us know on [Slack](http://community.getdbt.com/), or open [an issue](https://github.com/dbt-labs/dbt-spark/issues/new)
- Want to help us build dbt? Check out the [Contributing Guide](https://github.com/dbt-labs/dbt/blob/HEAD/CONTRIBUTING.md)
## Code of Conduct
Everyone interacting in the dbt project's codebases, issue trackers, chat rooms, and mailing lists is expected to follow the [dbt Code of Conduct](https://community.getdbt.com/code-of-conduct).
Raw data
{
"_id": null,
"home_page": "https://github.com/sigmarkarl/dbt-ocean-spark",
"name": "dbt-ocean-spark",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": "",
"keywords": "",
"author": "dbt Labs",
"author_email": "info@dbtlabs.com",
"download_url": "",
"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</p>\n<p align=\"center\">\n <a href=\"https://github.com/dbt-labs/dbt-spark/actions/workflows/main.yml\">\n <img src=\"https://github.com/dbt-labs/dbt-spark/actions/workflows/main.yml/badge.svg?event=push\" alt=\"Unit Tests Badge\"/>\n </a>\n <a href=\"https://circleci.com/gh/dbt-labs/dbt-spark/?branch=main\">\n <img src=\"https://circleci.com/gh/dbt-labs/dbt-spark/tree/main.svg?style=shield\" alt=\"Integration Tests Badge\"/>\n </a>\n</p>\n\n**[dbt](https://www.getdbt.com/)** enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.\n\ndbt 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.\n\n## dbt-spark\n\nThe `dbt-ocean-spark` package contains all of the code enabling dbt to work with Apache Spark on Ocean. For\nmore information, consult [the docs](https://docs.getdbt.com/docs/profile-spark).\n\n## Getting started\n\n- [Install dbt](https://docs.getdbt.com/docs/installation)\n- Read the [introduction](https://docs.getdbt.com/docs/introduction/) and [viewpoint](https://docs.getdbt.com/docs/about/viewpoint/)\n\n## Running locally\nA `docker-compose` environment starts a Spark Thrift server and a Postgres database as a Hive Metastore backend.\nNote: dbt-spark now supports Spark 3.1.1 (formerly on Spark 2.x).\n\nThe following command would start two docker containers\n```\ndocker-compose up -d\n```\nIt will take a bit of time for the instance to start, you can check the logs of the two containers.\nIf the instance doesn't start correctly, try the complete reset command listed below and then try start again.\n\nCreate a profile like this one:\n\n```\nspark_testing:\n target: local\n outputs:\n local:\n type: ocean_spark\n method: http\n host: api.spotinst.io\n port: 443\n cluster: osc-[clusterId]\n account: acc-[accountId]\n app: spark-hive-[appId]\n schema: analytics\n connect_retries: 5\n connect_timeout: 60\n retry_all: true\n```\n\nConnecting to the local spark instance:\n\n* The Spark UI should be available at [http://console.spotinst.com/ocean/spark/cluster/{clusterId}/app/{appId}/sparkUI/jobs](http://localhost:4040/sqlserver/)\n* The endpoint for SQL-based testing is at `http://localhost:10000` and can be referenced with the Hive or Spark JDBC drivers using connection string `jdbc:hive2://localhost:10000` and default credentials `dbt`:`dbt`\n\nNote that the Hive metastore data is persisted under `./.hive-metastore/`, and the Spark-produced data under `./.spark-warehouse/`. To completely reset you environment run the following:\n\n```\ndocker-compose down\nrm -rf ./.hive-metastore/\nrm -rf ./.spark-warehouse/\n```\n\n### Reporting bugs and contributing code\n\n- Want to report a bug or request a feature? Let us know on [Slack](http://slack.getdbt.com/), or open [an issue](https://github.com/fishtown-analytics/dbt-spark/issues/new).\n\n## Code of Conduct\n\nEveryone interacting in the dbt project's codebases, issue trackers, chat rooms, and mailing lists is expected to follow the [PyPA Code of Conduct](https://www.pypa.io/en/latest/code-of-conduct/).\n\n## Join the dbt Community\n\n- Be part of the conversation in the [dbt Community Slack](http://community.getdbt.com/)\n- Read more on the [dbt Community Discourse](https://discourse.getdbt.com)\n\n## Reporting bugs and contributing code\n\n- Want to report a bug or request a feature? Let us know on [Slack](http://community.getdbt.com/), or open [an issue](https://github.com/dbt-labs/dbt-spark/issues/new)\n- Want to help us build dbt? Check out the [Contributing Guide](https://github.com/dbt-labs/dbt/blob/HEAD/CONTRIBUTING.md)\n\n## Code of Conduct\n\nEveryone interacting in the dbt project's codebases, issue trackers, chat rooms, and mailing lists is expected to follow the [dbt Code of Conduct](https://community.getdbt.com/code-of-conduct).\n",
"bugtrack_url": null,
"license": "",
"summary": "The Apache Spark adapter plugin for dbt",
"version": "1.6.2",
"project_urls": {
"Homepage": "https://github.com/sigmarkarl/dbt-ocean-spark"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "c842e28112168ecee8a6a2c1c8bf243f66f83faa30d142047842d885851293ae",
"md5": "f6f58772b9f9a6212b68e4f8565ad84e",
"sha256": "2cadab32c24c3230dddd6c82080b6c6b0aecc974306c30d48bf7140b7ce74194"
},
"downloads": -1,
"filename": "dbt_ocean_spark-1.6.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "f6f58772b9f9a6212b68e4f8565ad84e",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 45241,
"upload_time": "2023-10-11T16:31:18",
"upload_time_iso_8601": "2023-10-11T16:31:18.717821Z",
"url": "https://files.pythonhosted.org/packages/c8/42/e28112168ecee8a6a2c1c8bf243f66f83faa30d142047842d885851293ae/dbt_ocean_spark-1.6.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-10-11 16:31:18",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "sigmarkarl",
"github_project": "dbt-ocean-spark",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"circle": true,
"requirements": [],
"tox": true,
"lcname": "dbt-ocean-spark"
}
JSON
