Connecting ChistaDATA Cloud for ClickHouse with Ruby

Introduction

Database as a Service (DBaaS) is a managed service offered by the cloud that allows access to databases without the demand for physical hardware setup, software installation, or database setup. The ChistaDATA Cloud (DBaaS) for ClickHouse aims to provide users fast, reliable, and functional solutions.

In this blog post, we would like to explain, with examples, how to connect to the ClickHouse cluster created in ChistaDATA Cloud with JAVA.

Prerequisites

Before we get started, make sure you have the following prerequisites:

  1. Ruby is installed on your machine.
  2. ChistaDATA Cloud for Clickhouse account with a database set up.

Install the required gem

To connect to ClickHouse Cloud, we need to use a Ruby gem called clickhouse-ruby. To install the gem, open your terminal and run the following command:

gem install clickhouse

Import the required libraries

In your Ruby script, import the necessary libraries:

require 'clickhouse'
require 'json'

Configure the ClickHouse connection

First Login ChistaDATA Cloud. Enter your ClickHouse Cluster. On the right panel, you will see the “Connect” button. Click on it, and you will see your cloud login information.

Next, configure the connection to your ChistaDATA Cloud database by specifying the hostname, port, username, and password. You can obtain these details from your ChistaDATA Cloud dashboard.

connection = Clickhouse.connection(
  url: 'https://your-chistadata-cloud-url',
  port: '9440',
  user: 'your-username',
  password: 'your-password',
  database: 'your-database-name',
  secure: true
)

Execute queries

Once the connection is established, you can execute queries using the execute method. Here’s an example of executing a simple SELECT query:

result = connection.execute('SELECT * FROM your_table')
puts result.to_a

Perform data insertion

To insert data into ClickHouse Cloud, you can use the insert Method. Here’s an example of inserting data into a table:

data = [
  { column1: 'value1', column2: 123 },
  { column1: 'value2', column2: 456 }
]

connection.insert('your_table', data)

Close the connection

After you have finished working with ChistaDATA Cloud for Clickhouse, closing the connection to free up resources is essential. Use the close method to close the connection:

connection.close

Conclusion

This blog post taught us how to connect to ChistaDATA DBaaS using the Ruby programming language. Following the above-mentioned steps, you can establish a connection, execute queries, and perform data insertion effortlessly. ClickHouse’s scalability and powerful analytics capabilities, combined with Ruby’s simplicity, make it a potent data analysis and processing combination.

Remember to consult the official documentation of the clickhouse-ruby gem for further information and advanced usage scenarios. Happy coding and analyzing with ClickHouse and Ruby!

To know more about ChistaDATA Cloud, do consider reading the following articles:

About Can Sayn 36 Articles
Can Sayın is experienced Database Administrator in open source relational and NoSql databases, working in complicated infrastructures. Over 5 years industry experience, he gain managing database systems. He is working at ChistaDATA Inc. His areas of interest are generally on open source systems.
Contact: Website