hyperdx_ingest user requires CREATE DATABASE permission

[kirik]

Hi, I'm trying to run Hyperdx in standalone mode (hyperdx and otel-collector only, mongo&CH are self-hosted).

As per https://clickhouse.com/docs/en/use-cases/observability/clickstack/ingesting-data/otel-collector#creating-an-ingestion-user we need only following grants: GRANT SELECT, INSERT, CREATE TABLE, CREATE VIEW ON otel.* TO hyperdx_ingest; But with this grants otel_collector will not start (unexpected exit in logs with "Will restart in a bit..." message).

It's required to provide hyperdx_ingest CH user with CREATE DATABASE grant also.

This could be either changed in docs, or in otel-collector init script.

Thanks!