# Moving Data Across Workspaces

You can only share data or attach databases within a single workspace group, not across groups. There is no direct method of moving tables or databases betweenworkspace groups currently available in SingleStore Helios.

To move data between workspace groups, you can use one of the following methods:

## Move a Table or a Subset of Data (ETL via Object Storage)

This method involves the following steps:

1. **Export from the source workspace group**: From a workspace in the source workspace group, write the table to S3/GCS/Azure Blob using `SELECT ... INTO`. For example:
   ```sql
   SELECT * FROM src_db.src_table
     INTO S3 's3://my-bucket/my-prefix/'
     CONFIG     '{...}'
     CREDENTIALS '{...}';
   ```
   Variants exist for `INTO AZURE`, `INTO GCS`, etc. for details refer [SELECT](https://docs.singlestore.com/cloud/query-data/select.md)

2. **Re-create the schema in target workspace group**: In a workspace in the destination workspace group, create the destination table with matching DDL.

3. **Load into target workspace group**: In the destination workspace group, use a **Pipeline** (recommended) or `LOAD DATA` from that bucket to load into the new table.
   ```sql
   CREATE PIPELINE p_move_table AS
     LOAD DATA S3 's3://my-bucket/my-prefix/'
     CONFIG     '{...}'
     CREDENTIALS '{...}'
     INTO TABLE dest_db.dest_table;

   START PIPELINE p_move_table;
   ```
   For details on options available refer:

   [CREATE PIPELINE](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands/create-pipeline.md)

   [Load Data with SingleStore Flow on Helios](https://docs.singlestore.com/cloud/load-data/load-data-with-singlestore-flow-on-helios.md)

   [LOAD DATA](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/load-data.md)

## Move an Entire Database

If you want to move a whole database across workspace groups, you can:

Run [BACKUP DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/backup-database.md) from a workspace in the source workspace group to object storage.

Run [RESTORE DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/restore-database.md) from a workspace in the destination workspace group, pointing at that backup.

***

Modified at: May 13, 2026

Source: [/cloud/manage-data/moving-data/moving-data-across-workspaces/](https://docs.singlestore.com/cloud/manage-data/moving-data/moving-data-across-workspaces/)

(An index of the documentation is available at /llms.txt)