[Yandex DataLens] ClickHouse® user must be correctly configured to use readonly 1 option (see docs). For other readonly options user should have parameter readonly set to 0 or 2

ERR.DS_API.DB.CH.READONLY_USER

This error occurs because of restrictions in the ClickHouse® user profile or because the server-side readonly setting does not match the DataLens connection setting.

To fix this error:

• For data reads, set Readonly to 2 in advanced connection settings.
• If Readonly is set to 1, the ClickHouse® administrator should configure the user as described in this guide.
• For data writes, use a user with proper permissions and set Readonly to 0 in advanced connection settings.
• In other cases, remove write operations.