How can I export model to a csv file?

Is there a way to materialize a model into a local csv file?

I don’t think so. Whereas dbt seeds do the oppsite operation (creating a model and uploading data from a CSV file), (as of today) there’s no way in dbt to do what you’re suggesting.

there is a COPY sql query which can download data, but dbt does not seem to like it. I would like the ETL to end with a file.