dbt run fails when the select returns zero rows

[nandubatchu]

dbt run for specific models fail as we are employing automated schema inference from the SQL output. How can we create tables with zero/empty rows using dbt-glue adapter?

I have checked that we can create empty tables in Apache HUDI by defining schema explicitly!

[zhangyuan]

Could you use the model like the below to create empty model?

{{ config(
  materialized='table',
)}}

select 1 as id -- cast the type if the default one doesn't make sense
where 1 = 2