Skip to content
Katalyze announces $10.5M seed round. Read the press release
ConnectorsData platforms

Amazon Redshift

Available

Give analytical data its process context.

Use relevant Redshift information alongside operational documents and scientific sources to investigate manufacturing questions.

  • reads
  • moves
  • publishes
Amazon Redshift
BatchesBatch genealogyCertificatesTest results
BR-0410Lot 2231-A0088Titer comparable
BR-0412Lot 2231-B0091Titer lower
BR-0415Lot 2231-B0091Titer comparable
BR-0421Lot 2231-B0091Titer lower
In the Context LayerBatch BR-0412
From Amazon Redshift
Test result
Titer lower
Feed lot
2231-B
From Document Intelligence
Feed 3
11:40, planned 09:00
Deviation noted
DV-0088
Document IntelligenceBR-0412 feeding record
The connection

What the connection makes available.

  1. 01

    Reads tables where they are

    Schemas, tables and views you grant, read in place through a read-only role. Nothing is migrated.

  2. 02

    Reads datashares live

    A datashare from another cluster or account is read as it stands, with no copy made on either side.

  3. 03

    Brings in new rows

    New and corrected rows are picked up on each run, so a comparison always uses the current results.

  4. 04

    Joins results to the batch

    A test result and the batch record it describes resolve to the same batch in the Context Layer.

Plan the connection

Plan the connection around the work.

Review what the connection reads, the information your team needs, and the access the job requires.

KindData platforms
StateAvailable
Doesreads
DirectoryConnectors directory
Prepare for setup

Identify the source and the people responsible.

  1. 01The data sourceIdentify the Redshift environment and the information relevant to the job.
  2. 02The data ownerInvolve the people responsible for access and the meaning of the data.
  3. 03The operational comparisonDefine the process, measure, and question the data should help explain.
Information scope

The information available through this connection.

Use this information to build operational context, with pointers to its original sources.

  • 01

    Batches

    BR-0410 to BR-0421

  • 02

    Batch genealogy

    Each batch to its feed lot

  • 03

    Certificates

    0088 for 2231-A, 0091 for 2231-B

  • 04

    Test results

    Titer lower on BR-0412 and BR-0421

  • 05

    Schemas

    Manufacturing, quality, supply

  • 06

    Views

    Titer by batch, lots by batch

  • 07

    Materialized views

    Batch and lot summaries

  • 08

    Datashares

    Read live where they are shared

Questions

Questions about Amazon Redshift.

Discuss the information you need and how your team will use it.

Book a Demo
Book a demo

Turn time spent finding information into time spent moving forward.

Bring the job you want to move forward and the records you'd like connected. Thirty minutes on how Katalyze would do the work, and where your experts come in.

Or, just a quick chat to run through the product, your call.