search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
16.19k stars 4.14k forks source link

[source-clickhouse] read only connection #46535

Open YannikVossSKOPOS opened 1 month ago

YannikVossSKOPOS commented 1 month ago

Connector Name

source-clickhouse

Connector Version

0.2.2.

What step the error happened?

Configuring a new connector

Relevant information

I created a Clickhouse user which is able to select a few tables. Because of security reasons we have to restrict the user to a read only user with the following SQL: ALTER USER readonly_user SETTINGS readonly = 1

This restriction leads to the following error when trying to set up a Clickhouse source in Airbyte: java.sql.SQLException: Cannot change the setting on a read-only connection

Is there any possibility to fix that problem?

Relevant log output

java.sql.SQLException: Cannot change the setting on a read-only connection

Contribute

marcosmarxm commented 1 day ago

I've added the issue to the connector backlog, but it won't be prioritized for now. If this issue is affecting you, please comment or give it a 👍. This helps the team understand the number of users facing the same problem so that high-impact issues can be prioritized.