First Steps in Exasol SaaS

This article explains how to sign up for an Exasol SaaS trial and create your first database.

Sign up

To get started with Exasol SaaS, sign up for a free trial account on https://cloud.exasol.com/signup. You will then receive a verification email to finish setting up your account and create a secure password. After setting up your account, you will receive another email with your account details and can sign in.

When you log in to your Exasol SaaS environment, your user account is assigned the Owner role, which allows you to perform all administrative actions on the account. Only users with the Owner role can create databases.

For more information about user accounts and access management, see Access Management.

Add your first database

The first time you sign in to Exasol SaaS, you will be asked to add a new database.

add database dialog

  1. Select the AWS region where your new database will be deployed. If you are unsure, select the region that is closest to your location.

  2. Enter a name for the database.

  3. Enter a name for the cluster and choose an instance type from the dropdown menu.

    The optimal cluster size for an Exasol database is based on usage patterns. As a rule of thumb, start with a RAM size that corresponds to about 10 percent of the size of your raw data. For example, if you want to process about 1 TiB of raw data, the cluster size Small may be a good starting point.

    Depending on your workload, you may need a larger cluster size to use additional CPU and memory. Sometimes, a smaller cluster may however also meet your requirements and be more cost effective. You can dynamically test which size best fits your needs by resizing a cluster.

  4. You can set a timeout value for the Cluster auto-stop feature, which automatically stops the cluster after a period of inactivity. The default value is 120 minutes. You can also disable the auto-stop feature.

    Disabling the auto-stop feature may result in increased cloud resource usage.

  5. When you have set the desired options for your database, click on Add database.

    On the Databases page, the new database and cluster will have the status Creating until they are ready for use. The creation process will take about 15 minutes to complete. You will receive an email when your database is ready for use.

    Database being created

    Database running

To learn more about how to create and manage databases and clusters in Exasol SaaS, see Database Management.

Connect your database

Exasol SaaS offers easy integration with cloud services for data replication, machine learning, analytics, and ETL/ELT from our partners. You can add integrations with one or more of these services before you continue, or you can choose to add them later from the web console.

You can also choose to populate your new database with sample data to evaluate Exasol SaaS. The sample data set consists of a schema containing the sample sales data that is used in the EXAcademy training courses.

add integrations and sample data

To continue without adding integrations or sample data, click on Close.

Run your first query

When your database is running you can run SQL queries in the web console using Worksheets. For more information, see Worksheets.

worksheet example

You can also connect to your SaaS database using any compatible database client or BI tool. For more information about using external tools with Exasol SaaS, see Connect to Exasol.