The Redshift connector currently does not expose Redshift view definitions through Presto's connector view.
As a result, operations such as:
SHOW CREATE VIEW redshift.test.orders_view;
line 1:1: Relation 'redshift.test.orders_view' is a table, not a view
DROP VIEW redshift.test.orders_view;
line 1:1: View 'redshift.test.orders_view' does not exist
DROP TABLE redshift.test.orders_view;
Relation 'orders_view' is a view, not a table
Expected Behavior or Use Case
Add support for:
CREATE VIEWDROP VIEWSHOW CREATE VIEW
Provide an optional configuration property to allow Redshift to manage view resolution for views containing Redshift-specific SQL syntax that cannot be analyzed by Presto.
The Redshift connector currently does not expose Redshift view definitions through Presto's connector view.
As a result, operations such as:
Expected Behavior or Use Case
Add support for:
CREATE VIEWDROP VIEWSHOW CREATE VIEWProvide an optional configuration property to allow Redshift to manage view resolution for views containing Redshift-specific SQL syntax that cannot be analyzed by Presto.