exporter/clickhouse cannot operate without create database, create table permissions

[earwin]

Component(s)

exporter/clickhouse

What happened?

Description

1. exporter/clickhouse unconditionally runs CREATE DATABASE IF NOT EXISTS, CREATE TABLE IF NOT EXISTS on target DB;
2. In production environment you normally have service users heavily restricted and all required databases and tables pre-created;
3. ClickHouse verifies CREATE DATABASE and CREATE TABLE permissions before checking for the db/table presence, so exporter/clickhouse fails with "Not enough privileges" even if CREATE would be a noop.

Collector version

0.99.0

Environment information

No response

OpenTelemetry Collector configuration

No response

Log output

No response

Additional context

No response

[github-actions]

Pinging code owners:

• exporter/clickhouse: @hanjm @dmitryax @Frapschen @SpencerTorres

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[mshustov]

@SpencerTorres should be fixed by #32282?

[SpencerTorres]

Yes, absolutely fixed by #32282. We can close this @dmitryax 👍

[github-actions]

This issue has been inactive for 60 days. It will be closed in 60 days if there is no activity. To ping code owners by adding a component label, see Adding Labels via Comments, or if you are unsure of which component this issue relates to, please ping @open-telemetry/collector-contrib-triagers. If this issue is still relevant, please ping the code owners or leave a comment explaining why it is still relevant. Otherwise, please close it.

Pinging code owners:

• exporter/clickhouse: @hanjm @dmitryax @Frapschen @SpencerTorres

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[SpencerTorres]

This can be closed @crobert-1

[crobert-1]

Thanks for following up @SpencerTorres, really appreciate it!

Fixed by #32282