I am trying to query my postgresql read replica as a foreign catalog.
- I can sucessfuly test the connection.
- I can see the database names.
- The table names are auto populated correctly.
However when I try to view or query a table, I get the following error. (Names redacted)
Failed to request /ajax-api/2.1/unity-catalog/tables/<foreign_catalog>.<db>.<table>?include_browse=true: 404 Table '<foreign_catalog>.<db>.<table>' does not exist.
When I query this database via python, I usually need to use case sensitive names, and I suspect that is the issue.
eg:
- Foreign Catalog table appears as "table".
- In PostgreSQL I would usually query it as 'select * from "Table"'
Any ideas of if case sensitive postgresql is already solved with Foreign Catalogs or what the problem might be?