How to create BYOC Warehouse on GCP
Preparations
- Add users to the organization and authorize them
- Prepare a VPC and subnet
- Learn about Resource Orchestration
Create a BYOC Warehouse on AWS
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.
Fill in the following information to start creating warehouse.
| Parameters | Description |
|---|---|
| Warehouse Name | Required. Unique within the organization, no more than 32 characters in length, supports English letters, Chinese, numbers, -, _, and the combination of them. |
| Warehouse Mode | Select BYOC |
| Cloud Platform | Select GCP |
| Region | us-west1 is supported |
| Core Version | Select available version |
| VPC | When you create a new BYOC warehouse for the first time, the "New VPC" is selected by default. The subsequent steps will guide you to select the VPC in the cloud environment to complete the new warehouse creation. If you have created a BYOC warehouse in a VPC before, you can directly select this VPC and create a new warehouse. |
Click the "Next" button to proceed to the next step.
GCP Preparation
Before officially creating, please refer to the document to complete the following preparation:
- Add users to the organization and authorize them
- Prepare a VPC and subnet
- Learn about Resource Orchestration
Click Done to proceed to the next step.
Cloud Resource Configuration
Copy the command and Click "Open CloudShell".
To deploy VeloDB Cloud BYOC warehouse in Google Cloud, select your project correctly, then paste the command and execute.
Fill in the following information to execute shell.
| Parameters | Description |
|---|---|
| VPC name | The VPC name created in the previous step |
| Subnet name | The Subnet name created in the previous step |
| Zone ID | us-west1-a |
Wait for the script to complete, then return to the velodb page, and wait for the "Warehouse Initialization" step to complete.
Once Warehouse Initialization is complete, VeloDB Cloud will establish a connection with the BYOC warehouse. Subsequently, you can enter the warehouse and create clusters.
Open public network connection and access
Reserve External IP Address
1. Copy Master Private IP
Go to VeloDB Cloud (opens in a new tab), Click Connect and copy Master IP.
Enter GCP VM Instances (opens in a new tab), Search the IP above.
Enter the instance and confirm VPC.
2. Reserve External IP Address
Enter GCP IP Address (opens in a new tab), Click RESERVE EXTERNAL STATIC IP ADDRESS.
Input Name. Select Premium for Network Service Tier. Select IPv4 for IP version. Select Regional for Type.
Select Region where your byoc warehouse is. Attach to the instance above where master ip is corresponding.
Click RESERVE.
Create Firewall Policy
Enter GCP Firewall Policy (opens in a new tab) . Click Create Firewall Policy.
Enter Policy name. Select Global for Deployment scope. Click CONTINUE.
Click CREATE FIREWALL RULE. Input Priority. Select Ingress for Direction of traffic. Select Allow for Action on match.
Select Apply to all for Target. Select IPv4 for IP type. Input 0.0.0.0/0 or pulic IP you want to access the warehouse.
Select Specified protocols and ports for Protocols and ports.
Select TCP and input 8080,8088,9030. Click CREATE.
Check the rule you just created. Click CONTINUE.
Click ASSOCIATE. Check the VPC where your byoc warehouse is. Click ASSOCIATE.
Click Create.
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.