# Using AWS Redshift with Dagster

> Use Redshift’s data warehousing capabilities in Dagster workflows.

Source: https://dagster.io/integrations/dagster-aws-redshift
Category: Storage

## About this integration

Using this integration, you can connect to an AWS Redshift cluster and issue queries against it directly from your Dagster assets. This allows you to seamlessly integrate Redshift into your data pipelines, leveraging the power of Redshift's data warehousing capabilities within your Dagster workflows.

## Installation

```bash
pip install dagster-aws
```

## Examples

```python
from dagster import Definitions, asset, EnvVar
from dagster_aws.redshift import RedshiftClientResource


@asset
def example_redshift_asset(context, redshift: RedshiftClientResource):
    result = redshift.get_client().execute_query("SELECT 1", fetch_results=True)
    context.log.info(f"Query result: {result}")


redshift_configured = RedshiftClientResource(
    host="my-redshift-cluster.us-east-1.redshift.amazonaws.com",
    port=5439,
    user="dagster",
    password=EnvVar("DAGSTER_REDSHIFT_PASSWORD"),
    database="dev",
)

defs = Definitions(
    assets=[example_redshift_asset],
    resources={"redshift": redshift_configured},
)
```

## About AWS Redshift

**AWS Redshift** is a fully managed, petabyte-scale data warehouse service in the cloud. You can start with just a few hundred gigabytes of data and scale to a petabyte or more. This enables you to use your data to acquire new insights for your business and customers. Redshift offers fast query performance using SQL-based tools and business intelligence applications, making it a powerful tool for data warehousing and analytics.