[Bug]: Override of `ref` macro does not support packages or the "version" keyword argument

Is there an existing issue for this?

[X] I have searched the existing issues

Current Behavior

The overridden ref macro does not have the correct interface. For example it does not support the "version" keyword argument (only supports "v") and it does not support calling with two positional arguments.

Expected Behavior

The correct way to override the ref macro is documented here.

Steps To Reproduce

No response

Environment

- OS:
- dbt-dremio:
- Dremio Software:
- Dremio Cloud:

Relevant log output