rill
rill copied to clipboard
ClickHouse Incremental Model file name must match output
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