COPY TO External Data Store Statements

  • Capella Columnar
  • reference
    +
    This topic describes how you use COPY TO statements to structure and write the results of a query—​or a copy of an entire collection—​out to an external data store such as Amazon S3 and GCS.

    Structuring the data in the external store is useful when you plan to query it later using dynamic prefixes for better performance.

    To be able to read or write data to or from external cloud storage exclusive permissions are required. For more information see Cloud Read/Write Permissions.

    Following are the supported output formats: