Hi, is it the expected behavior for a source, to ingest all data into a single column

_airbyte_data

instead of putting into the respective column names? I know that it expands into columns when I enable Basic Normalization, but I would like to know if it doesn't expand by default without normalization.

It won't expand by default without normalization. There are a few destinations where this is the exception since normaliation isn't available, like S3 csv, and a couple others like GCS flatfile. (?)

Other example is Bigquery denormalized