---
title: Using Databend with Fastly Object Storage
summary: null
url: >-
  https://www.fastly.com/documentation/guides/platform/object-storage/object-storage-databend
---

Fastly [Object Storage](https://docs.fastly.com/products/object-storage) works with the S3-compatible API to store and access large files from Fastly. This same API can be used with [Databend](https://www.databend.com), the open-source Cloud Data Warehouse, to remotely load files from Fastly into Databend using their [Cloud Bucket](https://docs.databend.com/guides/load-data/load/s3) feature.

## Prerequisites

To remotely load files from Fastly Object Storage into Databend, you will need to create an [Object Storage access key](https://www.fastly.com/documentation/guides/platform/object-storage/working-with-object-storage#creating-an-object-storage-access-key) used to authenticate against the S3-compatible API and [create a table in Databend](https://docs.databend.com/sql/sql-commands/ddl/table/ddl-create-table) that matches the [format](https://docs.databend.com/sql/sql-reference/file-format-options) of the data file you want to load.

## Using Databend with Fastly Object Storage

Use the Databend [`COPY INTO`](https://docs.databend.com/sql/sql-commands/dml/dml-copy-into-table) command to load the data out of Fastly Object Storage, setting the [`CONNECTION`](https://docs.databend.com/sql/sql-reference/connect-parameters) parameters as follows:

- `access_key` and `secret_access_key`: enter the appropriate values generated from the [Object Storage access key](https://www.fastly.com/documentation/guides/platform/object-storage/working-with-object-storage#creating-an-object-storage-access-key) you created.
- `region`: enter the [Fastly data storage region](https://www.fastly.com/documentation/guides/platform/object-storage/working-with-object-storage#working-with-the-s3-compatible-api) you want to use (e.g. `us-west-1`).
- `endpoint_url`: enter `<region>.object.fastlystorage.app` where `<region>` matches the region value above.
- `enable_virtual_host_style`: enter `FALSE`

**Example:**

```sql
CONNECTION = (
    access_key_id = 'AKIAIOSFODNN7EXAMPLE',
    secret_access_key = 'wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY',
    region = 'us-west-1',
	endpoint_url = 'us-west-1.object.fastlystorage.app',
	enable_virtual_host_style = FALSE
)
```