Unable to configure PDC with Vertica Grafana datasource

Grafana Plugin Development
1

I am working on enabling PDC on vertica-grafana-datasource and using vertica-sql-go driver to connect with Vertica DB. I have followed the link PDC integration guide to enable PDC feature to Vertica connector.

I have faced a challenge to implement PDC with Vertica and unable to pass dialectContext to the Vertica connection because Vertica Go driver used default net.Dial and unable to pass dialectContext of PDC to Vertica connection. Please help us to resolve this issue and is there any other way to use PDC with Vertica?

Below are the details:

  1. Deployed latest version of Grafana on premise and used Vertica sql go version 1.3.3(" GitHub - vertica/vertica-sql-go: Official native Go client for the Vertica Analytics Database. ").
  2. I am successfully configured frontend to enable or disable PDC.
  3. I have faced an issue with data source implementation. I have followed above document to enable PDC and create a dailContext for the same for proxy. But Vertica sql go driver just support sql.Open(connStr) and unable to pass dialContext to the connection. Vertica sql go driver does not support sql.OpenDB(connection) due to this unable to assign dialContext to the connection.
2

:wave: Hello, thanks for reaching out! You have two options:

  1. Add support to vertica/vertica-sql-go to support OpenDB where you can pass in a different Dialer (docs)
  2. If vertica supports specifying a proxy in the connection string itself you can follow the implementation in MySQL