[BUG]: Recon fails with foreign catalog with Redshift

[ankitad-db]

Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

ReconcileError

Current Behavior

Getting this error

[[UNRESOLVED_COLUMN.WITH_SUGGESTION](https://docs.databricks.com/error-messages/unresolved-column-error-class.html#with_suggestion)] A column, variable, or function parameter with name full_data_type cannot be resolved. Did you mean one of the following? [data_type, udt_catalog, interval_type, udt_name, table_catalog]. SQLSTATE: 42703

Columns in the information_schema.columns table for foreign catalog - full_data_type column is missing

Columns in non foreign catalog

Expected Behavior

Remorph reconcile should run successfully if the source table is from foreign catalog

Steps To Reproduce

No response

Relevant log output or Exception details

No response

Sample Query

No response

Operating System

macOS

Version

latest via Databricks CLI

[sundarshankar89]

We currently don't support foreign catalogs.