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.