As mentioned in the above response, connecting to Denodo Platform from SQLAlchemy would require developing a new dialect and currently, there is no support for any JDBC Drivers.
In order to overcome “The user does not have READ privileges on the view ‘pg_type'” error, I would create a new view called **pg_type** in the Virtual DataPort as per the schema described in the [pg_type](https://www.postgresql.org/docs/8.4/catalog-pg-type.html) documentation.
For example, you could execute the below statement in the VQL shell of the Virtual DataPort Administration Tool.
`CREATE OR REPLACE VIEW pg_type as SELECT NULL AS oid, NULL AS typarray, NULL AS typname, NULL AS typnamespace FROM dual();`
You could refer the section [Defining a Derived View](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/defining_a_derived_view/defining_a_derived_view#defining-a-derived-view) of the Virtual DataPort VQL Guide for more information.
Hope this helps!