Skip to main content

A Django app to integrate Apache Superset dashboards into a Django application

Project description

django-superset-integration

PyPI - Version GitHub Issues or Pull Requests

Monthly Downloads Total Downloads

django-superset-integration is a Django app to integration Apache Superset dashboards into a Django application.

Quick start

  1. Add django_superset_integration to your INSTALLED_APPS setting like this:
INSTALLED_APPS = [
    ...,
    "django_superset_integration",
    ...,
]
  1. Include the superset-integration URLconf in your project urls.py like this:
path("superset_integration/", include("django_superset_integration.urls")),
  1. You will need a cryptography Fernet key, so you need to install cryptography:
pip install cryptography
  1. Generate a Fernet key in a python terminal:
from cryptography.fernet import Fernet
FERNET_KEY = Fernet.generate_key()
  1. The result is a bytestring like b'jozEHFGLKJHEFUIHEZ4'. Copy ONLY the content of the string, not the b nor the quotation marks

  2. In your env variables, create a variable FERNET_KEY with the copied content as value

  3. By default, all dashboard data will be displayed. You can override this by creating your own filtering function and adding it in your settings.py:

RLS_FUNCTION = "my_app.my_module.create_rls_clause"

Your function must take a parameter user and return a SQL rls clause like this : [{"clause": "1=1"}] (where you replace 1=1 by the clause you want).

See Superset documentation for more information

  1. Make sure that your Superset instance parameter GUEST_TOKEN_JWT_EXP_SECONDS is more than 300 (5 minutes). Otherwise it will expire before it can be refreshed. For example, set it to 600 (10 minutes).

  2. In the template where you want to integrate the dashboard, add the following in your <head>:

<link href="{% static 'css/ponctual-rejects.css' %}" rel="stylesheet"/>
  1. Then add the following at the emplacement where you want the dashboard:
{% load static %}

...

{% include "django_superset_integration/superset-integration.html" %}
  1. Run python manage.py migrate to create the models.

  2. Start the development server and visit the admin site to create a SupersetInstance object.

  3. After you have created a SupersetInstance object, create a SupersetDashboard object.

  4. In the view where you want to integrate the dashboard, in get_context_data, add the following:

def get_context_data(self, **kwargs):
    context = super().get_context_data(**kwargs)

    ...

    dashboard_name = "THE NAME OF YOUR DASHBOARD FROM STEP 13"
    dashboard = SupersetDashboard.objects.get(name__iexact=dashboard_name)
    context["dashboard_integration_id"] = dashboard.integration_id
    context["dashboard_id"] = dashboard.id
    context["superset_domain"] = dashboard.domain.address

    ...

    return context
  1. That should be it!

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django_superset_integration-0.1.5.tar.gz (9.2 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

django_superset_integration-0.1.5-py3-none-any.whl (10.5 kB view details)

Uploaded Python 3

File details

Details for the file django_superset_integration-0.1.5.tar.gz.

File metadata

  • Download URL: django_superset_integration-0.1.5.tar.gz
  • Upload date:
  • Size: 9.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/2.1.2 CPython/3.10.17 Linux/6.8.0-1021-azure

File hashes

Hashes for django_superset_integration-0.1.5.tar.gz
Algorithm Hash digest
SHA256 ca8a6c0b79e5e071573b4127a8ee33da07ad5a81e4fb6d3bc2b051dbd54b0858
MD5 6f9b06fa6376b3300620b70d04c5f971
BLAKE2b-256 e8cc24f2cdcd4bed448ba3bf110e63c4221c7ee4610b461b1b661171767f926c

See more details on using hashes here.

File details

Details for the file django_superset_integration-0.1.5-py3-none-any.whl.

File metadata

File hashes

Hashes for django_superset_integration-0.1.5-py3-none-any.whl
Algorithm Hash digest
SHA256 18539a69bca4e0aa5f6e18234c8eba83446966e14106c82f9b5b5f43286df9bf
MD5 a98232c66384ca92e46e30e4dd2441a6
BLAKE2b-256 1393894f481359ed885e482a6ce0c7015da7c06b841d35c6f1ecfae4c20a54b3

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page