# Superset
## Start Superset with Docker Image
Start running [Superset Image](https://hub.docker.com/repository/docker/apachepinot/pinot-superset) with pre-built Superset Pinot connector.
{% tabs %}
{% tab title="Docker" %}
1\. Run below command to start a standalone Superset deployment
```
docker run \
--network pinot-demo \
--name=superset \
-p 8088:8088 \
-d apachepinot/pinot-superset:latest
```
2.1. (First time) Setup Admin account by running below command and follow instructions to set password.
```
docker exec -it superset superset fab create-admin \
--username admin \
--firstname Superset \
--lastname Admin \
--email admin@superset.com \
--password admin
```
2.2. (First time) DB upgrade and Initialize Superset
```
docker exec -it superset superset db upgrade
docker exec -it superset superset init
```
3\. Import Pre-defined Pinot Datasources and Dashboard
```
docker exec \
-t superset \
bash -c 'superset import_datasources -p /etc/examples/pinot/pinot_example_datasource_quickstart.yaml && \
superset import_dashboards -p /etc/examples/pinot/pinot_example_dashboard.json'
```
4\. Go to SuperSet UI: to play around with dashboard.
{% endtab %}
{% endtabs %}
## Advanced Setup
### Adding Pinot Database
In order to add Pinot cluster as a database, a SQLAlchemy URI is required.
The format of URI is:
`pinot://:?controller=:`
E.g.
> `pinot://pinot-broker:8099/query/sql?controller=http://pinot-controller:9000/`
Below is an example for the QuickStart cluster, you can click `TEST CONNECTION` button to check if Pinot cluster is successfully connected.
### Adding Pinot Table
User can add an existing table into Superset:
User can edit table/column definition by clicking the `edit` button left to the table name.
### Configuring time column
User can configure an existing column `mergedTimeMillis` as temporal and set `Datetime Format` accordingly.
### Adding a derived column
User can also add a new column by setting the expression.
Another example:
