This topic describes how to add a Serverless Spark data source to connect Quick BI to an Alibaba Cloud Serverless Spark database. Once connected, you can use Quick BI to analyze and visualize your data.
Prerequisites
You have created an Alibaba Cloud E-MapReduce Serverless Spark database. For more information, see EMR Serverless Spark.
Procedure
Add IP addresses to the whitelist.
To connect to an Alibaba Cloud E-MapReduce Serverless Spark database over the public network, you must add the IP addresses of Quick BI to the database whitelist. For more information, see Set a whitelist.
Log on to the Quick BI console.
Go to the page for creating a data source. For more information, see Create a data source.
On the Alibaba Cloud Databases tab, select the E-MapReduce Serverless Spark data source.
In the Configure Connection dialog box, you can configure the following settings according to your business scenario.
Name
Description
Display Name
The display name for the data source in the data source configuration list.
Enter a standard name. Do not use special characters. The name cannot contain leading or trailing spaces.
Database Address
The public endpoint used to access the E-MapReduce Serverless Spark database. Currently, you can connect to E-MapReduce Serverless Spark only over the public network.
Log on to the E-MapReduce console. On the Overview page of the Kyuubi Gateway page, obtain the endpoint. Example: emr-xxxxxxxxxxxxxxxxx.aliyuncs.com.
Port
The port number of the database.
Database
The name of the database to which you want to connect.
Data Catalog Type
The type of data catalog where the E-MapReduce Serverless Spark database is located. You can select DLF Data Catalog or Other.
Username/Token Name
If you set Data Catalog Type to DLF Data Catalog, enter the Resource Access Management (RAM) user or RAM role that you added in the RAM console. You must grant permissions to the RAM user or RAM role before you use it.
NoteMake sure the user has the create, insert, update, and delete permissions on the tables in the database. For more information, see Manage permissions on DLF data using a Kyuubi token.
If you set Data Catalog Type to Other, enter the name of the token used to access the EMR Serverless Spark database. Log on to the E-MapReduce console. On the Token page of the Gateway page, obtain the name.
Token
The token used to access the E-MapReduce Serverless Spark database.
Log on to the E-MapReduce console. On the Token page of the Gateway page, obtain the token.
Init SQL
If you enable this feature, you can configure the SQL statements that are executed for initialization after the data source is connected.
The SQL statements are executed for initialization each time the data source is connected. Only SET statements are allowed. Separate multiple statements with a semicolon (;).
Click Test Connection to verify the connection to the data source.
After the test succeeds, click OK to add the data source.
What to do next
After you add the data source, you can create a dataset and analyze the data.
To create a dataset from a data table in the Alibaba Cloud E-MapReduce Serverless Spark database or from a custom SQL statement, see Create a dataset.
To create charts for data visualization and analysis, see Create a dashboard and Overview of charts.
To drill down into data for in-depth analysis, see Step 3: Configure and view drill-down settings.