Skip to content

Cloud Storage

Note

This feature is available in Enterprise, AWS, and GCP editions only.

Cloud storage lets you manage files and work with .sql scripts in Amazon S3 and Google Cloud Storage.

Cloud configuration

  1. As an administrator, go to Settings -> Administration -> Server Configuration
  2. In the Configuration section, enable the cloud providers you need: Cloud (AWS) or Cloud (Google)
  3. Enable Cloud storage to allow file management
  4. Save the changes.

Tip

Cloud storage supports Pass-Through Authentication - once you log in with your identity provider, no additional credentials are needed to access cloud databases. For more details, see Pass-Through Authentication. In the CloudBeaver AWS Edition, you can use default instance credentials.

Amazon Web Services

To use Cloud storage with AWS, make sure:

  • An AWS-compatible Identity Provider is configured. For available options, see Authentication Methods.
  • the AWS regions where your databases are located are selected AWS Settings

Google Cloud Platform

To use Cloud storage with GCP, configure Google as an Identity Provider.

Info

For setup instructions, see Google authentication.

Cloud storage

Once you have configured your identity provider, you can work with the data files. Navigate to Tools -> Cloud storage to access it.

In the Cloud storage you can manage files like in a regular file system. Right-click a file or folder to open the context menu and access options such as:

  • upload files from your local storage to a bucket
  • download files to your local storage
  • delete or rename files
  • drag and drop files between buckets or file systems

Tip

Use the Settings button for additional configuration options. For more details, see the Settings menu.

Work with SQL scripts

Double-click a .sql or .ddl file to open its contents in a new SQL Editor tab. There, you can:

  • view and edit the script
  • execute SQL statements
  • save changes directly back to Cloud storage
  • download the script directly to Cloud storage Learn more

Work with data files

Double-click a .csv, .json, .parquet, .xlsx, or .xml file to choose how to open it:

  • Open as Database creates a temporary file-based database connection and opens the file as a data source.
  • Open in SQL Editor opens the file contents in a new SQL Editor tab.

For details, see:

To create a permanent connection:

  1. Click Copy URI for the file you need

  2. Create a new connection and select the matching file type (for example, CSV or JSON)

  3. Paste the copied URI into the Database field.