[BUG] previewing 0 query results says there's a query error

[graciegoheen]

Describe the bug

If I preview a model that returns 0 rows, we say there's a query error:

Even though dbt show for this model, shows a table with 0 entries:

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

To reproduce

Preview this model using the VSCE:

select * from {{ ref('my_first_model') }}
where time_column in ('20240101')

[emerson-paiva]

This should've been fixed with this issue.

[fa-assistant]

🧹 Stale Issue Detected

This issue has had no meaningful activity for 138 days.

If this is still relevant, please:

• Comment with an update, or
• Add the cleanup/keep label to exempt it from future cleanup scans.

If no action is taken within 30 days, this issue will be scheduled for auto-close with a 7-day grace period.

cc @emerson-paiva — as assignee(s), can you confirm whether this is still active?

---

This notice was posted by the Fusion Issue Cleanup workflow.

[davidharting]

The current empty state is much improved:

Shows a 0 row count and the column headers. Room for improvement here, but considering this closed in terms of major papercuts ahead of GA.