Heya, Ive setup Salesforce as a Source and Bigquery As a destination with normalization enabled. But it seems that all Date fields are omitted

All date fields are omitted

Do you see these date fields in the catalog screen (when selecting which tables and columns are going to be replicated?)

Hey Chris,

Ok then I think because it is detected and noted as an object, it is not picked up by the basic normalization process since it doesn't know the data type that it should use and is omitted

Im running datform

1. Yes you are right, at the moment you could write your own SQL query to parse the json and extract those columns (which is not ideal) We have a tutorial on how to retrieve the SQL airbyte generates to do this instead of going from scratch if you'd like... 2. In the meantime, we have to change in airbyte how we deal with columns we don't know the datatypes so they can still be exposed and you don't have to do step 1: It could either by: • supporting more data types • supporting custom types provided by user • unknown types exposed as simple strings that you can cast yourself afterward

could you link me the tutorial?

Hmm

Would that work out for you as a quick fix for the moment?

I think ill put in a feature request to provide better control over normalization in Airbyte

Yes definitely, we'll work on that in the near future so it should be helpful to drive towards the right direction