Define encoding in redshift

[night-fury-web]

I have my source table with columns in zstd encoding.

After running dbt, the output column is using az64 encoding.

How can I keep zstd encoding after dbt run?

[joellabes]

@night-fury-web this isn't possible in dbt, have a look at dbt-labs/dbt-core#1016 for a deeper dive into why. In short, Redshift doesn't support specifying column encoding in a create table as select statement which is how dbt builds all its models.