When we try to import a table from a Postgres Integration Connector connection - we are getting the following errors.
No columns found
Tables must specify a column structure. For some reason, the app definition has been corrupted. It may also be possible that you left your column structure in an inconsistent state. Delete and re-add the table to create the column structure.
The error is listed in this “Known Issues” documentation (link above) but the workaround listed (Ask your Google Cloud admin to disable authentication override for the connection.) does not work - this option was never enabled on the integration connector in GCP.
The tables do contain valid columns and data…
I know that the Integration Connector is function correctly, because we are able to use it within an Application Integration (in GCP) and are able to interact with the database successfully using this Integration Connector.
Any ideas?