Lakehouse Connection Tips

Step 1: Install the Skill and Lakehouse connection

1. After entering the link in the dialog box, let SingWork execute the download.

download this skills of Lakehouse and install it,<https://github.com/clickzetta/clickzetta-skills>

2. Enter the following parameters and connect to Lakehouse

service = "Your API service address eg:ap-southeast-1-alicloud.api.singdata.com"
instance = "instance_id eg：1d8401a4"
workspace = "your workspace"
schema = "your schema"
vcluster = "Your cluster"
username = "your username"
password = "your password"
Create a new connection. This is related to this matter.

Step 2: Feature Testing

1. Connection Test

2. Join Local File with Lakehouse Table

Question

Answer

Sample Data After Integration

Original Table Structure

Test Excel Data