[Bug]: Validation of view sql failed. Version context for table nessie.names must be specified using AT SQL syntax

[ahmedshamma2008]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

I receive the following Error Message in Dremio while trying to create a view from a query that connect to Nessie
Err: Validation of view sql failed. Version context for table nessie.names must be specified using AT SQL syntax
I was following the following steps:
https://www.linkedin.com/pulse/creating-local-data-lakehouse-using-alex-merced%3FtrackingId=owFrZg3DS7Ot0LnLS6Oz7A%253D%253D/?trackingId=owFrZg3DS7Ot0LnLS6Oz7A%3D%3D

Expected Behavior

Creating a view

Steps To Reproduce

Validation of view sql failed. Version context for table nessie.names must be specified using AT SQL syntax

Environment

- OS:linux/x86_64
- dbt-dremio:dremio/dremio-oss
- Dremio Software:    container_name: dremio
- Dremio Cloud:N/A

Relevant log output

Validation of view sql failed. Version context for table nessie.names must be specified using AT SQL syntax

[doernemt]

Hello,
while searching for a solution to the issue, I found that there's something in Dremio's community forum: https://community.dremio.com/t/how-work-with-branch-using-dbt-dremio-nessie/11792/2

I've applied the macro quick-fix in my setup, but would highly appreciate a fix in the adapter itself.

Thanks, Tim