Case is the following: "For some reason, the Change Data Feed feature recognizes DEFAULT columns from the source but does not enable this property when creating a _cdc table.": 

So it uses the following DDL that is impossible to execute: 

Instead of this one: 

As a workaround , prior to run streaming queries I create a cdc table myself

I was just wondering whether there is any other way without explicitly running DDL for _cdc table myself.