Superset

​

Superset Access Setup

​

Step 1: Confirm Superset URL

Provide us with your Superset instance URL:

• Example: https://superset.yourcompany.com
• Or your internal/VPN URL

​

Step 2: Create a Pavo User Account

Create a dedicated user account for Pavo in Superset:

1. Go to Settings → List Users → + Add
2. Fill in:
   • Username: pavo-integration
   • Email: A service account email (e.g. pavo-integration@yourcompany.com)
   • Password: Generate a secure password
3. Click Save

​

Step 3: Assign Viewer Role/Permissions

Add the Pavo user to a role with read-only permissions: Option A: Use built-in “Gamma” role (simplest)

• Assign the Gamma role to the Pavo user
• Gamma provides read-only access to dashboards and charts

Option B: Create custom “Pavo Viewer” role (more control)

​

Step 4: Enable API Access

Superset supports two authentication methods for API access: Option A: Username/Password (Basic Auth)

• Simply share the username and password created in Step 2
• We’ll authenticate via /api/v1/security/login

Option B: API Token (if enabled)

1. Log in as the Pavo user
2. Go to Settings → User → Security
3. Generate an API token (if available in your Superset version)

​

Step 5: Add the Connector in Pavo

Navigate to Settings → Data sources and click Add source. Select Superset from the connector list. Enter the connection details: Click Connect. Pavo will verify connectivity and begin syncing.