VeloDB Cloud
Management Guide
Azure

How to create BYOC Warehouse on Azure

Preparations

Create a BYOC Warehouse on Azure

Create warehouse configuration

On the warehouse creation guide page or the warehouse list in the upper left corner, click New Warehouse to enter the warehouse configuration page and fill in the form to create it.

ParameterDescription
Warehouse NameRequired. Unique within the organization, no more than 32 characters in length, supports English letters, Chinese, numbers, -, _, and the combination of them.
Warehouse ModeSelect BYOC
Cloud PlatformSelect Azure
Regionwestus3 is supported
ZoneSelect the zone where you want to deploy the data warehouse. It is recommended to choose the same zone as that of your application/client. VeloDB Cloud will expand its supported zones based on user needs.
Core VersionVeloDB Core 2.0 and the later versions support the separation of storage and computing. Storage is billed based on actual usage, and there is no need to pre-configure storage space.

This table lists the Azure Regions and Availability Zones where VeloDB Cloud BYOC Warehouse can be deployed, along with the associated Availability Zone IDs. You will need this information to choose an available subnet when setting up Azure Development Stacks.

Cloud PlatformRegionAvailability Zone ID
Azurewestus3unlimited

Click Next to proceed to the next step.

Azure Preparation

Before officially creating, please refer to the document to complete the following preparation:

Click Done to proceed to the next step.

Enter Azure Subscription ID

Enter Azure Subscription ID, Click Next. You can find subscription id in azure console.

Cloud resource configuration process

VeloDB Cloud will use Azure' Deployment Stacks service to complete the deployment of private warehFouses within the user's VNet.

Copy the token which will be used in next step.

Click Open Azure Resource Manager.

Select Resource Group for Create in option.

Fill in the Stack name.

Select Delete Resources for Action on unmanage option.

Click Next.

Select Subscription,Resource Group,Region.

Paste the token copied in the previous step.

Select VNet and Subnet.

Click Review + Create.

Warehouse initialization

The system will initialize the warehouse, which takes about 5-10 minutes. If the warehouse initialization takes more than 30 minutes, or other situations that cannot be continued, please Get Help.

Create a new cluster

On the new cluster page or cluster overview page, click Create a new cluster to enter the cluster configuration page. For detailed operations, please refer to Create a new cluster.

Open public network connection and access

After the warehouse is created, if you need to connect to the warehouse on the public network, access the WebUI, etc., you need to bind the public IP address and set up a security group on AWS

Notice: Please use an Azure user with permissions to perform the operation or ask the administrator to help you complete the following operations.

Allocate Public IP

1. Copy Master Private IP

Go to VeloDB Cloud (opens in a new tab), Click Connect and copy Master IP.

Enter Azure Portal (opens in a new tab), Search the IP above.

Enter the virtual machine and confirm VNet.

2. Associate public IP address

Click Networking > Network settings on the left, Click Configure for Public IP address.

Check sdb-ip-config, check Associate public IP address, and select a Public IP address. If you don’t have one yet, create one first.

Click Save.

Set Security Group

Click the Network Security Group.

Click Settings > Inbound security rules. Click Add. Input 8080,9030,8088 for Destination port ranges. Input Name.

Click Save.

Return to the VeloDB Cloud connection page and click the Master IP public network refresh icon.

At this point, you can access the WebUI and connect to the warehouse through the public network.

Warehouse Usage

For warehouse usage operations and if you need to delete a warehouse, please refer to the document Warehouse Usage.