Superset
Superset is an app made for the cloud with an easy-to-use interface for making interactive dashboards & visualising datasets. It has a lightweight semantic layer which empowers data analysts to quickly define their dimensions and metrics. It is now integrated with Amorphic IDP to provide seamless use. For more information refer to the Superset Documentation.
How to Create App?
In order to create an app, Apps should be enabled in the environment and the user would require to fill the below information:
| Property | Description |
|---|---|
| App Code | Select 'Apache Superset' to view the necessary configuration for creating a Superset application. |
| Version | View the available versions of Superset that Amorphic supports and select the appropriate one. |
| Internet Facing Enabled | Lists two options: Enabled and Disabled. Selecting Enabled will allow access to Superset via the Internet. If Disabled is selected, then Superset can only be accessed in the Amorphic private environment. |
| ACM Certificate ARN | Create an ACM certificate in the AWS account and provide it here. This certificate will be used for HTTPS verification. Please contact the administrator for more information. |
| Domain Name | Provide the domain name that should be associated with Superset. |
Please contact the administrator to add the DNS CNAME entry between the AppUrl and LoadBalancer URL.
App details
Once the app creation is triggered, the app details will appear in the page in this format.
To use Superset features on Amorphic data, users need to create a connection. To do this, select the 'Add Superset Databases' icon in the top right corner. Enter the user's DWH password to create the connection.
To create an S3 Athena connection to use S3 Athena Amorphic datasets, a PAT token needs to be provided instead of a DWH password. For more information about PAT tokens, please refer to PAT Tokens.
Connection creation can sometimes time out and cause an error. Try again after a while and retry creating the connection.
'AppUrl', a load balancer URL, can be used to sign into the app. When clicked, the user will be directed to the following page. Then, provide the necessary credentials to sign in to the Superset app.
To register Amorphic datasets with Superset and perform analysis and operations, navigate to the Datasets page in the Superset console and click the + Dataset button in the top right corner, as shown in the image below.
In the dialogue box that appears, select the appropriate values based on the description provided in the image. This will create a dataset which can be queried and analyzed further.