This topic describes how to add a Log Service SLS data source.
Prerequisites
You have created a Project in Log Service SLS.
You have enabled and configured an index. For more information, see Create an index.
Limitations
You can add Log Service SLS as a data source only in the public cloud.
Procedure
Log on to the Quick BI console.
Go to the data source creation page from an entry point for creating data sources.
On the Alibaba Cloud databases tab, click Log Service SLS.
In the Configure Connection dialog box, configure the parameters.
Parameter
Description
Display name
The display name of the data source in the configuration list. Enter a compliant name that does not contain special characters or leading or trailing spaces.
Endpoint
The access endpoint (domain name) for Log Service SLS.
For more information, see Service endpoints.
NoteUse an internal endpoint for all regions except for the following, which support public endpoints:
China (Nanjing)
China (Fuzhou)
Philippines (Manila)
South Korea (Seoul)
Thailand (Bangkok)
Port
The port number used to connect to the data source. The default value is 10005.
Project name
A Project is a resource management unit in Log Service SLS used for resource isolation and access control.
For more information, see Manage a Project.
AccessKey ID and AccessKey Secret
The AccessKey ID and AccessKey Secret for an account authorized to access the data source.
Log on to the RAM console to obtain an AccessKey ID and an AccessKey Secret.
Click Test Connection to verify the connection.
After the data source passes the connectivity test, click OK to add the data source.
Queries against a Log Service SLS data source must include the __date__ or __time__ field in the WHERE clause to limit the time range. For example:
__date__ > '2017-08-07 00:00:00' and __date__ < '2017-08-08 00:00:00'
__time__ > 1502691923 and __time__ < 1502692923You can implement this by setting filter conditions, parameters, or placeholders when you create a dataset.
If this condition is not included, only data from the last 15 minutes is returned by default.
For more information, see Connect over JDBC.
Next steps
After you create the data source, you can create a dataset and analyze your data.
Create a dataset from your Log Service SLS data source by adding a table or using a custom SQL query. For more information, see Create a dataset.
Create a visualization chart to analyze data. For more information, see Create a dashboard and Overview of visualization charts.
Use the drill-down feature for in-depth data analysis. For more information, see Step 3: Configure and use the drill-down feature.