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.
The optimal cluster size is based on usage patterns. As a rule of thumb, start with a RAM size that corresponds to about 10% of your raw data. For example, if you want to process about 1TB of raw data, then the cluster size Small may be a good starting point. Depending on your workload, you may need a larger cluster to use additional CPU and memory. Sometimes, a smaller cluster may also meet your requirements and be more cost-effective. You can dynamically test which size best fits your needs by resizing a cluster. For more information, see Resize Cluster.
Add New Database
- In the web console, click Databases.
- On the Databases page, click Add database.
- In the first window, enter a name for the new database and select a cluster region, then click Next to continue to the next step.
In the second window, 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.
- 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.
- 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 to view the cluster(s) for the database. To learn how to add clusters, see Add Cluster.
To view details about the database, click the information icon.
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.