This article will guide you to get started quickly with Kyligence Cloud on AWS platform. And Chrome (64.0.* or higher version) is recommended.
Kyligence Cloud requires authorization to operate your cloud resources. Please refer to Prerequisites to get accounts and permissions prepared.
- Region to deploy: The AWS region to deploy Kyligence Cloud
- Access Key ID: Please create an Access Key under your AWS account, and provide its Access Key ID
- Secret Access Key: Please provide the Secret Access Key of the above Access Key
- Create Stack Name: We use AWS CloudFormation service to deploy Kyligence Cloud, please name your CloudFormation stack
- EC2 Type: The EC2 type to deploy Kyligence Cloud
- Key Pair: With which to securely login into your EC2 instance with SSH
- RDS Type: Used to store metadata of Kyligence Cloud
After completing the information, please click Deploy to start the deployment and jump to the progress page of the deployment process.
Kyligence Cloud will automatically create the required resources and services in your AWS region. The entire process takes about 20 minutes, and the duration may vary due to different network conditions.
If you are trying Kyligence Cloud for the first time, you can apply for a trial license at Kyligence official website, and then download you in Trial Welcome Email Trial License File
After Kyligence Cloud was deployed, you need to create a workspace to connect datasource and speed up queries.
You need to fill the following information on the create workspace page:
If you use Snowflake as your data source, you need to enter the username, password and JDBC connection string, for example:
jdbc: snowflake: //demo.snowflakecomputing.com/? db = demo & warehouse = demo
After completing the cluster information form, click Submit and Start, Kyligence Cloud will automatically create the clusters. The creation process takes about 5-10 minutes.
Now sample data is only available with Amazon S3 data source. If you use Snowflake as the datasource, please refer to Snowflake Datasource Document to add data source.
There is a built-in sample dataset about NYC_Taxi in Kyligence Cloud, which includes green taxi travel data in January 2019. In the Data Source page, click Add Table, select Import Sample Table, and import the sample table and model. To learn about the schema, please refer to Sample Model document.
When the prompt “Import successfully” appears on the page, please go to the model interface and click the Aggregation Index-Build Index button under the nyc_taxi_green_trip model to load data for the model for analysis.
It takes about 5-8 minutes to build index. You can check the progress on the Job page, and use the data set for analysis after the build is completed.
Kyligence Insight is an out-of-box visualization tool in Kyligence Cloud. Use that as an example.
On the BI Tools page, click “Install and start” under the built-in Kyligence Insight, and wait for the installation to enable Kyligence Insight.
Drag the desired model to the right in Define Relationships and click Next.
- Click the edit button on the right of the dimension to change the dimension name, for example, rename PICKUP_DATETIME in the GREEN_TRIP_DATA table to “PICKUP_TIME”.
- Click the edit button on the right of the measure to change the measure name.
- Click the +Add Hierarchy button to create a hierarchy.
- Click the +Calculated Measure button and enter Calculated Measure Name and Expression to create a calculated measure.
Once all the definitions have been completed, click the Submit button to save the data set.
Click Chart from the navigation bar, then click the +Chart button, select the new Nyc_Taxi dataset, and click Submit to start visualization.
Drag dimensions and measures to the right panel, then click Run Query to execute the query and render the chart.
Take this as an example, first click the Click to change visualization type button in the page and select the visualization type as Bar Chart. Drag “PYAMENT_TYPE_TYPE” as the dimension, drag “GREEN_TRIP_DATA_TOTAL_AMOUNT_SUM” as the measure, then you can get the total order amount of each payment type.
Once you have the chart, you can save your chart by clicking the Save button on the page, or you can download the query result set by clicking the Export CSV button.