[BUG] [LSP] Preview CTE with ephemeral model raises 'show' error

[jtcohen6]

Describe the bug
A clear and concise description of what the bug is.

What version of dbt Fusion is this bug in? (find out by running dbt --version)

2.0.0-beta.15

Is this a discrepancy between the dbt Fusion Engine and dbt Core? Check one.

• YES
• NO

To Reproduce
Please submit one of the following

-- models/model_a.sql
{{ config(materialized = 'ephemeral') }}
select 1 as id

-- models/model_b.sql
# Preview CTE
with model_a as (
    select * from {{ ref('model_a') }}
)
select * from model_a

Try "Preview CTE" in model_b: Query error: Finished 'show' with 1 error in 12s 712ms 639us
Try previewing all of model_b: Works returning one row (id: 1)

Expected behavior

"Preview CTE" should be able to preview CTEs that select from / depend on ephemeral models

Screenshots

Operating System and CPU Type (please complete the following information):

• Mac

[drewbanin]

I can reproduce this one, but when I use the same code, I actually see a parser error coming from the LSP!

dbt0214: Table '__DBT__CTE__TEST_1' not found
  --> models/staging/test_2.sql:3:19

The compiled code looks reasonable to me, so I am not sure what the issue could be. We will investigate!

[ChenyuLInx]

@drewbanin I unassigned me and zhong for now, feel free to re-assign this as we find out more!

[akbog]

@graciegoheen to triage and let us know how well ephemeral models are handled in the vsce today :)

[graciegoheen]

Here's where we're at.

I created an ephemeral model in my project:

-- models/model_a.sql
{{ config(materialized = 'ephemeral') }}
select 1 as id

and then another model that depends directly on that ephemeral model:

-- models/model_b.sql
with model_a as (
    select * from {{ ref('model_a') }}
)
select * from model_a

@akbog I see two issues, detailed below.

Preview CTE issue

When I try to "Preview CTE" in model_b I get a query error.

LSP Parsing Error

On the reference to ephemeral model (model_a) in model_b I see a parser error.

Interestingly, that error seems to go away once I "Preview" the contents of the ephemeral model (model_a).