Introducing Rill and BI as Code with CrateDB Cloud

In the world of data analytics, Rill represents a revolutionary approach to Business Intelligence (BI), championing the concept of BI as code. This methodology allows for the versioning, tracking, and collaboration on BI projects using code, which can be more efficient and scalable than traditional BI tools. By leveraging Rill in conjunction with CrateDB Cloud, you can harness the power of distributed SQL database technology for real-time analytics at scale.

Creating a Free Tier Cluster on CrateDB Cloud

To begin setting up your CrateDB Cloud Free tier cluster, follow these steps:

  1. Navigate to the CrateDB Cloud Console at
  2. Click on “Deploy Cluster.”
  3. Choose your desired region from the list provided.
  4. Select the “CRFEE” plan for the Free tier option.
  5. Enter a unique name for your cluster, such as “rilldata.”
  6. Click on “Deploy Cluster” to initiate the setup.

After initiating the cluster deployment, you will be directed to a screen where you can copy your username and password. Please ensure you save these credentials securely. The cluster setup usually completes in less than 5 minutes.

Connecting to Your Cluster:

Once your cluster is ready, the next step involves connecting to it:

  • Go to the “Connecting to your cluster” section and scroll down to find the “psycopg3-sync” part.
  • Copy the Postgres formatted DB-URI provided, which looks similar to this:
  • Replace <PASSWORD> with the password you saved earlier, resulting in a connection string like:

Setting Up Rill

To integrate Rill with your CrateDB Cloud cluster:

  1. Install Rill by executing the shell install script:
curl | sh
  1. Navigate to the directory where you wish to create your Rill project:
cd ~/my-rill-projects/
  1. Initiate a new Rill project named my-cratedb-rill-project:
rill start my-cratedb-rill-project

This action should open a browser window at http://localhost:9009/welcome, allowing you to begin adding data.

When adding data, select PostgreSQL as your data source.

Enter the following details:

SQL Query (or your own query):

SELECT classification, country, first_ascent, height, mountain, prominence, region FROM sys.summits



Postgres Connection String (Use the connection string you formed earlier)


:partying_face: Congratulations! You’re now ready to explore Rill with your CrateDB Cloud cluster. :bar_chart: