Hi, When i am trying to connect pinot through superset dashboard and enabled username and password in pinot datastore, will the connection string will include username and password . if anyone have such experience. Please help me.

Yes the connection string should include username and password.

Can you give me any example for format reference ?

Hi @Vivek Vikash We can use the following format of connection URL : pinot://admin:XXXXXXXXXX@<broker host>:8099/query/sql?controller=http%3A%2F%2F<controller host>:9000%2F&verify_ssl=true had to read the driver level code for this😅

This info is also part of the Pinot python library documentation: https://pypi.org/project/pinotdb/

If you have basic auth:

pinot+https://<my-user>:<my-password>@<pinot-broker-host>:<pinot-broker-port><pinot-broker-path>?controller=https://<pinot-controller-host>:<pinot-controller-port>/[&&verify_ssl=<true/false>]
E.g. pinot+<https://my-user>:my-password@my-secure-pinot-broker:443/query/sql?controller=<https://my-secure-pinot-controller/&&verify_ssl=true>.