Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE] Add option to disallow catalog views #534

Open
asuresh8 opened this issue Aug 7, 2024 · 4 comments
Open

[FEATURE] Add option to disallow catalog views #534

asuresh8 opened this issue Aug 7, 2024 · 4 comments
Labels
enhancement New feature or request

Comments

@asuresh8
Copy link
Contributor

asuresh8 commented Aug 7, 2024

Catalog views cannot be trusted because they can inject custom code. To work with secure environments, an option should exist to disallow this SQL injection technique.

@asuresh8 asuresh8 added enhancement New feature or request untriaged labels Aug 7, 2024
@penghuo
Copy link
Collaborator

penghuo commented Aug 14, 2024

do u mean glue catalog view?

@asuresh8
Copy link
Contributor Author

Yes glue catalog view can potentially have injected code.

@dblock dblock removed the untriaged label Aug 26, 2024
@dblock
Copy link
Member

dblock commented Aug 26, 2024

[Catch All Triage - 1, 2, 3, 4, 5]

@penghuo
Copy link
Collaborator

penghuo commented Sep 5, 2024

per doc https://docs.aws.amazon.com/emr/latest/ManagementGuide/emr-glue-views.html. How can we determine if a query references a view in Glue? One approach is through the analyzer, which retrieves metadata from Glue, potentially including information about views. However, the challenge lies in how the spark extension can interpret the analyzer's behavior and prevent access to views.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants