0

i created a glue view through a glue job like this:

CREATE OR REPLACE PROTECTED MULTI DIALECT VIEW risk_models_output.vw_behavior_special_limit_score
        SECURITY DEFINER AS
            [query here...]

but i cant access it through a sagemaker notebook executing on top of a emr cluster with access to the glue catalog... this is the error i'm facing:

An error was encountered:
An error occurred while calling o285.sql.
: org.apache.spark.fgac.SparkFgacMdvException: org.apache.spark.sql.AnalysisException: [INVALID_VIEW_TEXT] The view `spark_catalog`.`risk_models_output`.`vw_behavior_special_limit_score` cannot be displayed due to invalid view text: <REDACTED VIEW TEXT>. This may be caused by an unauthorized modification of the view or an incorrect query syntax. Please check your query syntax and verify that the view has not been tampered with.

when executing

spark.sql("SHOW CREATE TABLE risk_models_output.vw_behavior_special_limit_score").show(truncate=False)

this is shown in the output's end:

|CREATE PROTECTED MULTI DIALECT VIEW risk_models_output.vw_behavior_special_limit_score ([view's columns])\nSECURITY DEFINER AS <REDACTED VIEW TEXT>\n|

it seems like the view definition isn't being accessed by spark and i don't really know why. I couldn't find anyone with this problem anywhere on the internet either. Could it be a permission issue? i don't have a single clue...

1
  • 1
    You should submit a AWS support case for this instead of SO post. Commented Jan 15 at 15:47

0

Your Answer

Draft saved
Draft discarded

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.