> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blockdb.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Amazon Redshift Share

> Access BlockDB blockchain archives via Redshift Serverless data sharing — no file handling or ETL required.

## Overview

Redshift data sharing gives you ready-to-query BlockDB tables inside your AWS account. BlockDB operates a producer cluster that exposes schemas (blocks, transactions, pricing, etc.) to your Redshift workgroups, keeping them synchronized without manual ETL.

## Getting Access

1. Provide your AWS account ID and Redshift namespace/ workgroup name to [support@blockdb.io](mailto:support@blockdb.io).
2. BlockDB creates a datashare (e.g., `blockdb_archive_share`) and associates it with your namespace.
3. In your account, run:

```sql theme={null}
CREATE DATABASE blockdb_prod FROM DATASHARE blockdb_archive_share OF ACCOUNT '123456789012';
```

4. Grant usage to teams/roles that need the data.

## Table Details

* Tables mirror the schemas in `/BlockDb.Postgres.Tables.Public` including `_tracing_id`.
* Views are provided for common aggregations (e.g., daily price bars) so you can query immediately.
* Because the data lives in the producer account, you only pay for compute when you query it.

## Operational Considerations

* Use materialized views or `COPY` into your own schemas if you need write access or to join with private data.
* Track freshness with queries against `_updated_at`; compare against [Data Freshness](/data-catalog/overview/data-freshness) expectations.
* If you require extra datasets or regions, coordinate with BlockDB—shares can span multiple AWS regions with AWS RAM.

<Callout icon="lightbulb" color="#3B82F6" iconType="regular">
  For workloads that also need streaming CDC, combine the Redshift share with [Real Time Channels](/user-guide/real-time-delivery/introduction) so inserts land in your lakehouse or event bus.
</Callout>