dbt show uses limit 5 at the end

[Anteus]

Describe the bug

dbt show --select "<model_name>"

error as it adds limit 5 at the end of the query which the db doesn't support. Straight swap to sample 5 or add top 5 in the select.

Steps To Reproduce

In as much detail as possible, please provide steps to reproduce the issue. Sample data that triggers the issue, example model code, etc is all very helpful here.

Expected behavior

A clear and concise description of what you expected to happen.

Screenshots and log output

If applicable, add screenshots or log output to help explain your problem.

The output of dbt --version:

<output goes here>

The operating system you're using:

The output of python --version:

Additional context

Add any other context about the problem here.

[tallamohan]

@Anteus, this issue will be fixed in the next release of dbt-teradata 1.7.x

[tallamohan]

Fix will be available in dbt-teradata 1.7.x

[Anteus]

Thanks it works fine!

For those still with the issue using dbt Power User under extension settings there's a setting Dbt: Query Template that you can set to: select top {limit} * from {{query}} as query