LookML error "Can't construct persistent derived table"

I created datagroup and persistent derived table as below. but it keeps giving me an error. 

model
```

connection: "chai_redshift_production"

include: "views/**/*.view.lkml"

datagroup: hourly_datagroup {
  max_cache_age: "2 hours"
  sql_trigger: "SELECT EXTRACT(HOUR FROM NOW())" ;;
  description: "cache data for max 2 hours and refersh it every 1 hour"
}
```

view
```

# If necessary, uncomment the line below to include explore_source.
include: "/V1/production/card/redshift/production_card_redshift.model.lkml"

view: prejoined_payment_pdt {
  derived_table: {
    datagroup_trigger: hourly_datagroup
    distribution_style: all
    explore_source: prejoined_payment {

...

```

error msg
```

There are serious errors with this LookML code that could prevent queries from running.

Can't construct persistent derived table prejoined_payment_pdt, connection chai_redshift_production could not be registered

prejoined_payment_pdt.view:5 production_card_redshift:prejoined_payment_pdt

```

1 0 1,060
0 REPLIES 0
Top Labels in this Space
Top Solution Authors