Thanks Robin and Aniket for the suggestions you have given.
Will try and update on the same.
Thanks,
Elakiya
On Fri, Oct 20, 2023 at 2:34 AM Robin Moffatt wrote:
> CTEs are supported, you can see an example in the docs [1] [2]. In the
> latter doc, it also says
>
> > CTEs are supported in View
CTEs are supported, you can see an example in the docs [1] [2]. In the
latter doc, it also says
> CTEs are supported in Views, CTAS and INSERT statement
So I'm just guessing here, but your SQL doesn't look right.
The CTE needs to return a column called `pod`, and the `FROM` clause for
the `SELECT
Hello,
I have been able to use queries with cte in this syntax –
INSERT INTO t1
WITH cte1 AS (SELECT
),
cte2 AS (SELECT
)
(SELECT
*
FROM