dpguthrie / dpguthrie/dbt-multi-tenant-example

union_source() doesn't return anything

Open
#3 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
No language data
Stars
8
Forks
1
PR merge metrics
No merged PRs in 30d

Description

Would you please help me with that?

```
06:56:41 Database Error in model stg_tpch_orders (models/staging/tpch/stg_tpch_orders.sql)
06:56:41 syntax error at or near ")"
06:56:41 LINE 16: ),
06:56:41 ^
06:56:41 compiled Code at target/run/IO/models/staging/tpch/stg_tpch_orders.sql
```

when I look at the compiled stg_tpch_orders.sql I see that source was not defined at all for some reason and I can't understand why
```
with source as (

),

cleanup as (

select

*,
REGEXP_SUBSTR(_customer_schema, '[0-9]+')::integer as comp_id

from source

)

select * from cleanup
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.