Hi! We've got pretty big problem with Airbyte's MS SQL connector. It seems we are not able to replicate a table that we have not allowed it to read some of the columns.. I.e.

GRANT SELECT
    ON dbo.my_table (
                             id,
                             created_at,
                             updated_at,
                             text            
    ) TO airbyte_user;

This same table also has an

email

field, that we do not want to replicate.. and we have not included it in the grant above for obvious reasons. We then receive following error in the logs

"stacktrace" : "java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The SELECT permission was denied on the column 'email' of the object 'my_table', database 'my_database', schema 'dbo'.

How can we trick airbyte into not doing blunt

*

query? Stitch has absolutely no problems with this as it will replicate only the fields the user has told it to replicate.

Hello JP, it's been a while without an update from us. Are you still having problems or did you find a solution?

We gave up on the Airbyte POC. We're happily using Meltano now.