You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
Redshift Multi-AZ cannot use STL scan
DataHub version: v0.13.2
Redshift configuration: multi-AZ
To Reproduce
Steps to reproduce the behavior:
Go to Redshift Query in query editor v2
Execute this command
SELECT * FROM stl_insert LIMIT 10;
And you will get
ERROR: permission denied for relation stl_insert [ErrorId: 1-67402a42-124aa79d44733fe95b73d753]
Expected behavior
It should be queried successfully.
Or could you please help to guide how to modify it in the source code? EX: Using other SYS_* views to modify?
Screenshots
Desktop (please complete the following information):
Chrome browser
Additional context
This issue will impact the Redshift ingestion feature.
You can find the AWS official document here https://docs.aws.amazon.com/redshift/latest/mgmt/overview-multi-az.html and which mentioned You can't use STL, SVCS, SVL, SVV, STV views with Multi-AZ deployments as they only support system monitoring views (SYS_* views). Change your monitoring queries to use system monitoring views (SYS_* views).
The text was updated successfully, but these errors were encountered:
Describe the bug
Redshift Multi-AZ cannot use STL scan
DataHub version: v0.13.2
Redshift configuration: multi-AZ
To Reproduce
Steps to reproduce the behavior:
Expected behavior
It should be queried successfully.
Or could you please help to guide how to modify it in the source code? EX: Using other
SYS_* views
to modify?Screenshots
Desktop (please complete the following information):
Chrome browser
Additional context
This issue will impact the Redshift ingestion feature.
You can find the AWS official document here https://docs.aws.amazon.com/redshift/latest/mgmt/overview-multi-az.html and which mentioned
You can't use STL, SVCS, SVL, SVV, STV views with Multi-AZ deployments as they only support system monitoring views (SYS_* views). Change your monitoring queries to use system monitoring views (SYS_* views).
The text was updated successfully, but these errors were encountered: