rill icon indicating copy to clipboard operation
rill copied to clipboard

ClickHouse Incremental Model file name must match output

Open royendo opened this issue 11 months ago • 0 comments

Describe the bug When creating an incremental model using Clickhouse as the OLAP engine, the output name of the model (in Clickhouse) must match the name in Rill.

If not, when selecting "Generate metrics with AI" it will load forever. Selecting "simple" will fail.

To Reproduce Using the below YAML, create a file with a name different than AdBids_csv.yaml and try to create a metrics with AI

type: model
materialize: true
incremental: true

sql: >
  SELECT timestamp, id, bid_price, domain, publisher
  FROM gcs('https://storage.googleapis.com/playwright-gcs-qa/AdBids_csv.csv',
          'CSV', 'timestamp DateTime, id UInt32, bid_price Double, domain String, publisher String'
        )
  {{ if dev }} LIMIT 100 {{ end }}

output:
  table: AdBids_csv
  engine: MergeTree

Expected behavior Regardless of the name of the file in Rill, this should be able to generate the metrics with AI.

Screenshots https://www.loom.com/share/319dfeda04384cd7a7652b29c1da3f16?from_recorder=1&focus_title=1

royendo avatar Jan 07 '25 23:01 royendo