Superset
Welcome to the installation guide for integrating Apache Superset with Peaka. As a leading data platform, Peaka provides seamless integration with various business intelligence and data visualization platforms, including Apache Superset. This document will guide you through the step-by-step process to set up this integration, enabling you to unlock the full potential of your data. Please follow each step carefully to ensure a successful setup.
You need 2 steps to complete setup:
- Generate Peaka API Key
- Add Peaka as Database Connection
Generate API Key
After you create your project, setup connections and create your catalogs in Peaka, you need to generate a Peaka API Key to use it with Superset. Check out Peaka Documentation for creating your API Key and follow detailed instructions by clicking here.
Add Peaka as Database Connection
- Adding Peaka as Database Connection to Superset is so easy. In your main dashboard in Superset, click Setting and then click Database Connections. Then in the next screen click Database button on the top right corner of your screen.
- Connect a database window will open. In supported databases select Trino.
- In the next screen you need to enter Display Name and SQL Alchemy URI. You can enter anything you like for the Display Name.The SQL Alchemy URI format is like below:
trino://dbc.peaka.studio:4567/<catalog>/<schema>?http_scheme=https&extra_credential=[[”peakaKey”,”<YOUR_API_KEY>”]]&access_token=trueYou need to fill<catalog>,<schema>and<YOUR_API_KEY>. For example if I want to see work on the tables under stripe catalog and payment schema created in Peaka with API Keyabc, then my SQL Alchemy URI would look like below:trino://dbc.peaka.studio:4567/stripe/payment?http_scheme=https&extra_credential=[[”peakaKey”,”abc”]]&access_token=trueThen clickTest Connectionbutton to test the connection and if the connection is ok, then clickConnectbutton.
Installation is complete you should be able to see Peaka in Database Connections List. You can start using Peaka with Superset.