Going through the error, I believe the jar file is unable to detect on the data type and resulting with the error message "Unrecognized column type".
For this scenario, I would check whether I can able to establish the connection with the data source by performing "Test connection". It is important to use the same connection settings, i.e. the same driver, the same connection URI, the same driver properties etc.
Also, I could create Base view from create from query option. You can follow the steps on [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) document to create the base view from this option.
Hope this helps!