DEV Community

loading...
Crate.io

Try CrateDB Cloud for free 🐐

carlotasoto profile image Carlota Soto Originally published at crate.io ・4 min read

CrateDB is an open-source project, so using our database on-premise has always been an option. However, more and more users want to start building in the cloud straight awayβ€”so we are happy to announce that now you can also sign up for a CrateDB Cloud free trial!

  • You will get a 3-node cluster active for 14 days, with 96 GB of storage and enough power to ingest thousands of metrics per second
  • You can populate CrateDB Cloud with tens of millions of records
  • No credit card needed

In this post, I will guide you through the first steps to get CrateDB Cloud running, including how to quickly import a time series dataset into your cluster. You will also find all this information in our docs though, which I highly recommend you explore.

How to get started

Click here and fill out the form. Once you're registered, you will be re-directed to the page below, where you can set up a username and password to access the Cloud Console:

Alt Text

A verification email will be sent to your inbox. Once your email is verified, the Console home page will pop up:

Alt Text

Choose "Username & Password". You will be automatically redirected to CrateDB Cloud. Welcome!

Alt Text

Deploy your free trial cluster

To continue, insert a name for your organization and click "Create organization". When the screen below displays, click on "Launch free 14-day trial cluster".

Alt Text

The next page will open up. Insert a name for your project, and press "Next".

Alt Text

Now, define a name for your cluster. Use a URL-safe name, i.e., avoiding spaces and special characters, and set up a username and password for this particular cluster.

Hint: click on "Auto-generate password" if you don't want to come up with the 24-character password yourself. You will have the chance to view and copy the password later. You can change it anytime.

Alt Text

A summary screen, similar to the one below, will display next. If everything looks good, press "Deploy".

Alt Text

Congratulations, you've deployed your first CrateDB Cloud cluster -- although it will take some minutes for your cluster to be available! When it's is ready, you'll see how the cluster status has changed to "Available", showing a screen similar to the one below.

Alt Text

Import some time series data: the NYC cabs dataset

The last step is to import a time series dataset into your cluster, so you can start experimenting with CrateDB right away.

In the "Overview" page, if you scroll down a little, you will see a button that says, "Cluster Demo Data: Learn how to import data to your cluster". Click there.

Alt Text

This will display:

Alt Text

The first command will create a table so you can organize, query, and store your data with SQL. (For more info about creating tables in CrateDB, check our docs). The second command will import the NYC cabs dataset into your cluster.

If you click "Execute create table", you will be directed to the CrateDB Admin UI – but first, you will be asked for the username and password to access your cluster. This is the username attached to the 24-character password you have defined (or auto-generated) earlier on.

If you don’t remember those credentials, don’t worry. On the Overview page, click on the β€œSettings” button under your cluster name. A screen will display showing you the username and password to access your cluster.

Alt Text

Alt Text

When the Admin UI opens up, the command will be automatically copied in the console:

Alt Text

Click "Execute query". If everything goes well, a message saying "CREATE TABLE OK" will display.

Next, import your data. In the CrateDB Cloud Console, click "Execute copy from". A screen like the following will pop up. Click "Execute query"

Alt Text

Wait some minutes for your data to ingest (it might take up to 40 minutes). Once everything is ready, you will have a database populated with 40 million records πŸŽ‰

Alt Text

Have fun! If you have any questions or feedback, please reach out to our team. We love talking to users! You can also find us on:

Until next time πŸ‘‹

Discussion (0)

pic
Editor guide