dbt-mindsdb
dbt-mindsdb copied to clipboard
Change the way to use predictor
Change the way of using predictor from dbt
From:
{{ config(materialized='table', predictor_name='TEST_PREDICTOR_NAME', integration='int1') }}
select a, bc from ddd where name > latest
To:
{{ config(materialized='table') }}
select p.a, t.bc from int1.table1 t
join TEST_PREDICTOR_NAME p
where name > latest
It would be more agile way to select and name projection fileds for store into table