when i create a query with a “Custom Column”, metabase creates a query like
SELECT source
.id
AS id
,
…
FROM (SELECT analytics
.tablename
.id
, …) source
When I use more than 30 columns I get an error -
ClickHouse exception, code: 47, host: 194.182.175.90, port: 8123; Code: 47, e.displayText() = DB::Exception: Missing columns:
Only for the first 30 columns the alias “source” is used
SELECT source
.id
AS id
,
…
analytics
.tablename
.column1
AS column1
FROM (SELECT analytics
.tablename
.id
,
…
analytics
.tablename
.column1
.) source
I don’t know if it is a problem with the clickhouse driver or a general problem