Allow exclusion of non supported data type columns in Polybase External Tables
I have been using Polybase with SQL Server 2019 and on the most part I really like it. I have found though that there are some tables I can't create as External Tables due to incompatible data types. It would be great if in the wizard in Azure Data Studio when trying to create the external tables, you could choose what columns to bring in as opposed to just not allowing the table to be pulled in due to 1 incompatible column.
I am mainly running into this with connecting to an Oracle (SAP HANA) database. The tables I need to connect to all have Blob storage on the tables. I am not sure if it is that field or a different field that is causing the error as all that is displayed is an error banner stating there is an incompatible data type. It would be nice to have some type of indicator as to what field is causing the error as well.