I get the error message as below when i execute my query having jinja syntax. what is causing this?. I already have ‘test’ model in my database which is being created by running my modle in dbt. The error message: ora-0093 : SQL command not properly ended .
details : {“code”: -1, “message”: SQL command not properly ended\n}
Here is my model:
with first as
(select * from {{ ref("test") }} )
select * from first
compiled to :
with first as
(select * from my-user-name.test )
select * from first
Note: When i run the compiled querry in sql developer , it works but it gives me error message if i run it in vscode with dbt power user extention or Jinja-sql. if i try to run it with oracle pl/sql , it does not recognise the syntax