dbt run fails when the select returns zero rows

`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!

The issue names dbt run, automated schema inference, and Apache Hudi but no files or tests. Start by reproducing a zero-row model with the dbt-glue adapter and compare it with the explicitly defined Hudi schema case; done means the model creates an empty table without failing.

Written by the indexing model from the issue text.