---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/copy-to.md
cuppy_section: docs
cuppy_doc: MXJ4-NV1K
cuppy_doc_uuid: 35f04945-a7b0-48ea-8b64-b52c6101b8f4
cuppy_permalink: https://cuppy.io/salesforce/d/MXJ4-NV1K
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/copy-to
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: c7ac7e2d5238008330e44c8df3f80aef6401ad62665c163efdaad7a6a86418b1
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/copy-to.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

## COPY TO

**Applies to:** ❌ Data 360 SQL ✅ Tableau Hyper API

Copy data from a SQL query to a file.

where `<option>` can be one of:

`COPY TO` copies the content of a Hyper database table to one or more files, overriding existing files if there are any.

If a column list is specified, only those specified columns will be written, in the order they appear in the column list.

Depending on the target location, Hyper will write data, e.g., to a local file or an AWS S3 bucket. More information on the available locations can be found in [External Locations](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/external-location.html).

`<table_name>`
The name (optionally database- or schema-qualified) of an existing table.

`<column_name>`
An optional list of columns to be copied. If no column list is specified, all columns of the table will be copied.

`<query>`
A [SELECT](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/select.html) command, [VALUES](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/values.html) command or any other SQL query.

`<target_location>`
Location to write the data to. See [External Location](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/external-location.html) documentation for more information.

`FORMAT => format_name`
Selects the data format to be written. This option can be omitted in case the format can be inferred from the file extension. Supported formats are depicted in detail in [External Formats](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/external-formats.html).

`format_specific_option => value`
A format-specific option. The available options for each respective format can be found in [External Formats](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/external-formats.html).

Copy a table to a CSV file in the working directory of the Hyper server, having a custom delimiter. The schema of the CSV file will be the same as the schema of the table `products`:

Same but writing to multiple CSV files (assume the table `products` is large enough so that the resulting CSV file will be larger than 500000 bytes):

Copy to an Apache Parquet file to Amazon S3 using empty credentials and inferring the bucket region. The file format is inferred from the file extension:

Same but with explicit Amazon S3 credentials and bucket region:

Instead of copying the table `products` as a whole, use a query instead to do whatever operation is needed:

Files named in a `COPY` command are written directly by the server, not by the client application. Therefore, they must reside on or be accessible to the database server machine, not the client. They must be accessible to and writable by the Hyper user (the user ID the server runs as), not the client.

`COPY` input and output is affected by [date_style](https://tableau.github.io/hyper-db/docs/hyper-api/connection/#date_style).

`COPY` stops operation at the first error.

Hyper also supports the PostgreSQL syntax of the `COPY` command, which is slightly different from the syntax depicted here. This is only supported for PostgreSQL compatibility. When writing SQL for Hyper, we recommend using the syntax documented here.


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->