我想在dbt模型customer.sql文件中声明并插入一个变量。我使用关键字DECLARE来声明变量,就像BigQuery文档建议的那样,但是我得到了Syntax error on DECLARE关键字。
代码:
DECLARE myDate VARCHAR DEFAULT '2021-01-01';
with order_bis as (
select
order_id
from
order
where
customer_date > myDate
)
select * from order_bis错误:Syntax error: Expected "(" or keyword SELECT or keyword WITH but got keyword DECLARE ...
https://stackoverflow.com/questions/70274718
复制相似问题