I'm trying to connect ClickHouse Open Source to Looker Studio. I'm currently running ClickHouse via Docker Compose with the following setup:
# ClickHouse - Setup clickhouse: image: clickhouse/clickhouse-server:24.8-alpine container_name: clickhouse ports: - "8123:8123" - "9000:9000" - "9004:9004" volumes: - /cdp-data/data/clickhouse:/var/lib/clickhouse - /cdp-data/logs/clickhouse:/var/log/clickhouse-server environment: CLICKHOUSE_USER: default CLICKHOUSE_PASSWORD: default CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT: 1 CLICKHOUSE_LOG_LEVEL: information CLICKHOUSE_LISTEN_HOST: "0.0.0.0" deploy: resources: limits: memory: 32G cpus: '8' reservations: memory: 16G cpus: '4' healthcheck: test: ["CMD", "wget", "--spider", "-q", "
http://localhost:8123/ping"] interval: 30s timeout: 10s retries: 5 start_period: 60s restart: unless-stopped networks: - data-pipeline-network clickhouse-keeper: image: clickhouse/clickhouse-keeper:24.8-alpine container_name: clickhouse-keeper ports: - "9181:9181" volumes: - /cdp-data/data/clickhouse-keeper:/var/lib/clickhouse-keeper - ./clickhouse/keeper_config.xml:/etc/clickhouse-keeper/keeper_config.xml restart: unless-stopped networks: - data-pipeline-network deploy: resources: limits: memory: 2G cpus: '2'
I followed all the steps in the official guide for on-prem setup:
Clickhouse+LookerStudio Integration Guide However, when connecting using the
MySQL Connector in Looker Studio, I keep encountering this error:
"Sorry, we encountered an error and were unable to complete your request. Error ID: 066ba20a"
it's connecting to tableau via clickhouse 8123 port. as well as mysql connector on 9004 port, but fails do connect with same credentials on lookerstudio.
Has anyone faced a similar issue or knows how to resolve it? Any help would be greatly appreciated!
Thanks in advance!
LinkedIn
Twitter
