Skip to main content

​
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 [email protected].
  2. BlockDB creates a datashare (e.g., blockdb_archive_share) and associates it with your namespace.
  3. In your account, run:
CREATE DATABASE blockdb_prod FROM DATASHARE blockdb_archive_share OF ACCOUNT '123456789012';
  1. 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 expectations.
  • If you require extra datasets or regions, coordinate with BlockDB—shares can span multiple AWS regions with AWS RAM.
For workloads that also need streaming CDC, combine the Redshift share with Real Time Channels so inserts land in your lakehouse or event bus.