Add Database

This section provides you with the steps to add and configure a database in the web console.

Exasol SaaS Standard edition only supports two databases. With Enterprise edition you can add up to five databases. If you need more than five databases, please send a support request. To send a support request, click Help and then click Support. For more information, see Editions Overview.

Add New Database

  1. In the web console, click Databases Databases.
  2. On the Databases page, click Add database.
  3. In the first dialog box, enter a name for the new database and select a cluster region, then click Next to continue to the next step.
    • Database name: A unique name to identify the database. The name can only contain the characters a-z (lower case), A–Z (upper case), numbers, hyphens, periods, and underscores (_).
    • Region: The region in which you want to create the main cluster.
    • Add database 1

  4. In the second dialog box, enter a name for the new cluster, choose a cluster size, and configure auto-stop settings.

    • Cluster name: A unique name for the main cluster. The name can contain letters a-z (lower and upper case), numbers, hyphen, dot, and underscores (_).
    • Cluster size: Choose the cluster size based on your requirements. By default, the cluster size XSmall is selected.
    • Auto-Stop settings: To save unwanted charges, by default, all clusters are automatically stopped after being idle for two hours. You can change or turn off these settings. For more information, see Change Auto-Stop Settings.
    • Add database 2

  5. Check that the estimated hourly, weekly, and monthly costs for your cluster meet your expectations. If needed, you can change the Cluster size and see the new estimated costs.
  6. Click Add database to create the database.

You will be redirected back to the Databases page where you can view the database you created. The database status is Creating until it is ready for use. Depending on the cluster size and storage, this process can take several minutes. Once the database is ready for use, the status will change to Running.

View Databases and Clusters

The Databases page in the web console displays information about all databases and clusters that you have configured. For each database, the current status and the cluster region are shown. For clusters, the current status and cluster size are shown.

When you add a database, it includes a MAIN cluster by default. Click Show Clusters to view the cluster(s) for the database. To learn how to add clusters, see Add Cluster.

Show clusters

Database Actions

Click Moreto open a drop-down menu with actions that you can perform on each database.

  • Add cluster: Provides you with the option to add clusters to the database. For detailed steps, see Add Cluster
  • Stop all clusters: Stops the running cluster. If the cluster you stop is the MAIN cluster, this will stop the database and all the clusters for this database. For detailed steps, see Start and Stop All Clusters.
  • Rename: This lets you rename the database. For detailed steps, see Rename Database.
  • Connect to Keboola: This lets you connect to Keboola for ETL Operations. For more information, see Loading Data using Keboola
  • Delete database: This lets you delete the database. For detailed steps, see Delete Database.

Database Details

To view details about the database, click the information icon.

Database details

  • AWS Region ID: Lists the AWS region ID selected when you created the database.

  • Database ID: Lists the database ID generated by SaaS when the database was created.

  • Keboola integration: States whether the database is connected via Keboola. For more information, see Loading Data using Keboola.