The problem I’m having
dbt run fails with the example from the tutorial
The context of why I’m trying to do this
Learn by replicating [Quickstart for dbt Cloud and Amazon Athena | dbt Developer Hub]. I am at step 8
What I’ve already tried
I tried to understand better. From the Athena side, I see the query arriving with a wrong SQL syntax it seems.
Some example code or error messages
The content on dbt side (excerpt)
with customers as (
select
id as customer_id,
first_name,
last_name
from xgi_dbt_tour.jaffle_shop_customers
)
and how it arrives on the Athena side:
-- /* {"app": "dbt", "dbt_version": "2025.4.7+8c17c1e", "profile_name": "user", "target_name": "default", "node_id": "model.my_new_project.customers"} */
create or replace view
"awsdatacatalog"."dbt_xgiannak"."customers"
as
with customers as (
select
id as customer_id,
first_name,
last_name
from xgi_dbt_tour.jaffle_shop_customers
)
It seems the double as as with customers as
creates an error.
By having the following syntax:
create or replace view
"awsdatacatalog"."dbt_xgiannak"."customers"
as (
select
id as customer_id,
first_name,
last_name
from xgi_dbt_tour.jaffle_shop_customers
)
the view is created normally. I’m a total noob on dbt, did I miss something?
Best regards, xgiannak