i've been struggling with an issue and finally fig...
# troubleshooting
s
i've been struggling with an issue and finally figured out the reason for it. with a
tap-google-sheets
source, i have had issues with columns just not appearing in the target. it turns out that
tap-google-sheets
 will sometimes issue schema defs like the following, and 
pipelinewise-target-snowflake
 doesn't know how to handle that:
Copy code
"schema": {
   "properties": {
       "period_start_date": {"anyOf": [{"type": ["null", "string"], "format": "date"}
        ...
    }
}
my question is - is
anyof
valid singer spec? trying to understand whether this is an issue on the target side or tap side. https://github.com/transferwise/pipelinewise/issues/449#issuecomment-682120934
I created an issue if anyone is interested in 👍 ing it https://github.com/transferwise/pipelinewise-target-snowflake/issues/228