# CopyStorm/View

Welcome to the CopyStorm/View Learning Center.

In this area you will find articles explaining how to quickly create a database combining one or more tables from multiple CopyStorm backups.

## Overview

![](/files/lvZL3b4QoprCQ6H15kAi)

CopyStorm/View builds SQL which combines tables from multiple CopyStorm backups into a new database built from database views.

For example:

* Suppose an organization has three divisions: Americas, Europe, and South America. Each division has its own Salesforce instance, using CopyStorm for backups.
* The CEO is asking for daily reports on opportunity generation and wants to see it across all divisions.

CopyStorm/View helps solve this problem by creating a single database including data from all three divisions by creating views for selected tables that look like:

`CREATE VIEW Opportunity( CopStormDatabase, Id, Name, …) AS SELECT ‘Americas’, Id, Name, … FROM AmericasBackup UNION ALL SELECT ‘Europe’, Id, Name, … FROM EuropeAmericasBackup UNION ALL SELECT ‘SouthAmerica’, Id, Name, … FROM SouthAmericaAmericasBackup`

This makes finding the answer for the CEO as simple as:

`SELECT CopyStormDatabase AS Division, Name, Amount WHERE CreatedDate >= TODAY`


---

# 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://learn.capstorm.com/reference/copystorm-view.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.