Connector Improvement: SQL Server: expose column type
In SQL Server, we would like to see both the name and type of each column so we can exclude columns based on their type.
In our use-case, we sync end user data via Fivetran and don't always know the columns to include. Instead we have a black list of columns to exclude by name. This part works fine.
But sometimes large character / binary blobs are stored in source databases (eg. base64 images) which are of no use and would just increase source, destination and network load to include.
Please sign in to leave a comment.
Comments
0 comments