dbt-mindsdb icon indicating copy to clipboard operation
dbt-mindsdb copied to clipboard

Change the way to use predictor

Open ea-rus opened this issue 2 years ago • 1 comments

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

ea-rus avatar Jul 19 '22 12:07 ea-rus