Add support for the "connection impersonation" Metabase feature

[phil-schreiber]

Hey,
we're running an instance of metabase pro version
v1.47.8

We using clickhouse driver version:
1.2.4

On clickhouse databases the data access option Impersonated does not show up. On postgres sources the option does show up.

Any idea why we might not see the option for clickhouse?
It's a crucial feature for us and the main reason we bought into metabase pro.

[slvrtrn]

Unfortunately, I had to roll back the support of it because of #192

[phil-schreiber]

Unfortunately, I had to roll back the support of it because of #192

@slvrtrn Is it planned to fix it? Any ETA? Thanks in advance

[slvrtrn]

Apologies for the late reply. We are currently discussing whether it will be possible to memorize the session settings within the underlying JDBC driver, so it will not trigger the issues with the clustered on-premise deployments.
Please stay tuned.

[slvrtrn]

@phil-schreiber, if everything goes well with the Java driver experiment, the ETA might be ClickHouse 24.3, best case scenario 24.2 - we will still need to make a minor adjustment to how the HTTP interface works.

[slvrtrn]

@phil-schreiber, sincere apologies for the delay. Here's an update.

• We have merged a new ClickHouse HTTP interface feature that allows to properly set a role for a particular statement, and that was the main blocker: Add role query parameter to the HTTP interface ClickHouse#62669
• Here's the PR for the JDBC driver feature (Feature: Persist effect of "SET ROLE" queries.  clickhouse-java#1569), which relies on the changeset above
• I am going to finalize my testing with clusters with the updated JDBC driver and the latest ClickHouse build. There is a significant chance that everything will finally work with the impersonation feature and roles setting on the cluster setups.
• If all is good, this feature will work with ClickHouse 24.4+.

[slvrtrn]

Added in 1.5.0.