DoubleCloud end-to-end quickstart tutorial

Welcome to DoubleCloud.

In this end-to-end quickstart video, you'll understand how to configure the main parts of our service and connect to them.

We'll start by creating your data warehouse based on ClickHouse. Then we'll configure data ingesting, and build charming analytical dashboards.

Let's get right to it.
CHAPTERS:

00:00 Introduction
00:28 Creating a ClickHouse Cluster
00:58 Installing ClickHouse Client
01:17 Creating a new Database
01:34 Creating a Source Endpoint
01:52 Providing CSV Settings
02:03 Configuring S3 Settings
02:14 Creating a Target Endpoint
02:27 Getting a Cluster ID
02:56 Creating a Transfer
03:20 Creating a Worksheet
03:33 Creating a Connection
04:10 Creating a Dataset
04:40 Creating a Dashboard
04:53 Creating a Chart
05:34 Creating a Demo Workbook

(00:28):
Let's create a ClickHouse cluster first. Click create cluster. Keep the ClickHouse service selected. Change the region to North America, Ohio. Select the first resource preset. Select two replicas for improved reliability and performance and two shards for capacity.

(00:48):
Give a name to your ClickHouse cluster. Let's leave the version as is and click submit. Now you can see that your cluster is creating. Now we need to install the ClickHouse client on the system.

(01:02):
As you can see, your cluster is already alive. This is the information page of your cluster. Look for the native interface string. Click copy. Paste the connection string into the terminal and press enter. Let's create a new database. Let's call it sample-clickhouse-db.

(01:24):
Now, let's list all the databases on the cluster. Now your data warehouse is ready to go. Open the endpoints tab. Click create endpoint source. Our test file is stored at Amazon, so let's select S3 as source type.

(01:44):
Let's name our endpoint S3-source-quickstart. Now let's work on setting. Unfold CSV and provide the CSV settings. Now set up the S3 services. The rest of it will do just fine. Let's click submit. Click create endpoint target.

(02:17):
We want the data to be sent to our cluster, so select ClickHouse as the target type. Let's name it clickhouse-target-quickstart. Let's get the cluster ID. Go back to the cluster info page. Find the cluster ID and click copy. Now, let's paste it here.

(02:39):
Our user and password are from the info page, and our database is called sample-clickhouse-db. The rest of the settings are good as they are. Let's click submit. Our target endpoint is ready.

(02:56):
Let's go to the transfers tab and click create transfer. Under endpoints, select your source and target endpoint. Let's name our transfer transfer-quickstart. All the other settings are good by default. Click submit.

(03:13):
Open the context menu and click activate. When it's finished, the status will change to done. Go to visualization. Click create workbook. Let's call it booking demo workbook. Click create. Let's fetch the data from your database into our workbook.

(03:34):
Create a connection. Our cluster is ClickHouse. Let's call it Sample ClickHouse DB. Let's get the name of the host from our cluster. Open the host tab. Copy the name of the first host on the list. Let's paste that into the host field. HTTP interface port is 8443. Username is admin. Password comes from the cluster info page.

(04:04):
Let's check our connection. Nice, it's all good. Click create. We need a dataset to organise and prepare the data for visualization. Click create dataset. Look, there's our table in the table section. Drag it to the work area of the dataset.

(04:27):
As you can see, the preview of the fields appear below. Let's name our dataset and click create. Now it's time to start visualizing. Let's create a dashboard on which to place our charts and diagrams. Click create dashboard. Let's call it Booking Dashboard. Click create.

(04:53):
Let's create a chart. Click add chart. Select the stacked area chart type from the list of types, and select our dataset from the list of datasets. Let's use booking start date field as our timeline. Let's use booking price as our parameter.

(05:15):
Now, let's repaint the chart to make it look prettier. Here you go. Click save. Let's name it Booking Price, and we're done. Let's customise the chart appearance. It's a timeline, so let's make it wider. When you have finished, click save.

(05:35):
Let's create a demo of what you can do with DoubleCloud. Click add demo workbook. Call it DoubleCloud Demo. Click done. Here you are. There's some pretty cool stuff in there. This concludes our quickstart tutorial. Keep exploring.

Видео DoubleCloud end-to-end quickstart tutorial канала DoubleCloud