After investigation and identification, this incident has been resolved. As noted previously, this new permissions checking in ClickHouse 23.9 is a better and more proper method of ensuring grants on these uses of asynchronous inserts and dictionaries. In order to properly apply these grants, please refer to the following ClickHouse Knowledge Base (KB) article:https://clickhouse.com/docs/knowledgebase/ingest-failures-23-9-release

We apologize for any interruption from this change in behavior, as it should have been better communicated prior to the release. If you require any additional assistance with updating your user grants in ClickHouse Cloud, please reach out to ClickHouse Support via a new case or chat:https://clickhouse.cloud/support

As noted, the workaround for this new behavior in ClickHouse 23.9 is described in more detail in the following KB article:https://clickhouse.com/docs/knowledgebase/ingest-failures-23-9-release

If you require any additional assistance in updating your user grants in ClickHouse Cloud, please reach out to ClickHouse Support via a new case or chat:https://clickhouse.cloud/support

The root cause of these permissions errors has been identified and is due to more strict checking of grants for asynchronous inserts and dictionaries in the 23.9 release. If you are using a non-default user with limited permissions to perform asynchronous inserts or dictionary creation, you must apply additional grants to this user.

The workaround for this issue is described in more detail in the following KB article: https://clickhouse.com/docs/knowledgebase/ingest-failures-23-9-release