Lever allows you to have confidential requisitions postings and opportunities (any opportunity attached to a confidential posting) these postings and opportunities currently are not being posted to snowflake. My best guess is this is because they have to be specifically requested using a parameter confidentiality=all when making the request. Confidential data is documented here https://hire.lever.co/developer/documentation#confidential-data, however it does not provide the details about this parameter and by default confidential data is not sent. I have confirmed that the api key that fivetran is using does have access to the confidential data they are just not currently pulling it.
One more key piece of information if you request a specific record that is confidential it will return the record but if you request multiple records or the full list of records it will only send back the non-confidential records.
Without this functionality it causes reporting issues since we do not have confidential reqs in Snowflake and this is a requirement for us. With out this we can not rely on the data that is being brought in since it is incomplete.
Ideally the confidential data would be posted to the correct tables as well as identified as confidential in another column the api returns a node "confidentiality" that could be used to tell if it is confidential or not