Skip to content

Cloud Storage

Note

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

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

Configuration

  1. As an administrator, go to Settings -> Administration -> Server Configuration.
  2. In the Configuration section, enable the relevant cloud service provider.
  3. Save the changes.

  4. Set up the cloud service provider:

Tip

Use preconfigured authentication, like AWS OpenID, to simplify access. In the CloudBeaver AWS Edition, you can use default instance credentials. For more details, see AWS Settings.

Cloud storage

After configuring your cloud 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

Cloud Storage allows you to work with .sql files. Double-click a file to open it in the SQL editor, where you can:

  • View and edit the script.
  • Execute SQL statements.
  • Save changes directly back to Cloud Storage.

Work with data files

You can also open and query data files stored in your cloud buckets, such as .csv, .json, .xlsx, .xml, and .parquet. These files can be connected as data sources directly in CloudBeaver.

For details, see:

Tip

Files like .csv, .json, .xlsx, .xml, and .parquet opened from Cloud Storage using the Open button create temporary Multi Source connections. These connections disappear after you log out.

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.