# Structural process overview for Amazon Redshift

The following high-level diagram describes how Tonic orchestrates the processing and moving of data in Amazon Redshift during data generation.

<figure><img src="/files/wg211afN5V8JcL5a9aAu" alt=""><figcaption><p>Data generation process flow for Amazon Redshift</p></figcaption></figure>

This diagram specifically shows the Amazon Redshift data generation process. For the Structural architecture diagram, go to [Structural architecture](/app/admin/architecture-diagram.md).

Structural orchestrates the moving and transforming of data between Amazon Redshift databases. To do this, Structural uses Amazon S3.

Structural manages the lifetimes of data and resources used in AWS. It only requires you to assign the necessary permissions to the IAM role that Structural uses.

At a high level, the process is:

1. Structural copies the table data into Amazon S3 as CSV files. You specify the S3 bucket path in the Structural workspace configuration. Within the S3 bucket, the data files are copied into an `input` folder.
2. After it transforms the data in a file, Structural copies the transformed file to the `output` folder in the configured S3 bucket.
3. After it processes all of the files for a table, Structural copies the output data back into Amazon Redshift, into the destination database.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tonic.ai/app/setting-up-your-database/amazon-redshift/redshift-tonic-process-overview.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.