Forum Discussion

Shrabanti's avatar
Shrabanti
New Contributor II
5 years ago

Unable to execute Redshift Script with comments in it using Redshift Execute

Hi All, I am using redshift execute to run a redshift script . While I am able to run the script when every redshift query is enclosed in double quote, but the script is failing when I am addin...
  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    4 years ago
    Copy LinkReport

    @SGArchitect

    Open error view on the Rest Post Snap, and check the “error_entity” field inside the error.

    “error_entity” field should contain the specific error message.

    BR,
    Spiro Taleski

    • SGArchitect's avatar
      SGArchitect
      New Contributor II
      4 years ago
      Copy LinkReport

      Thank you, Spiro.

      Error view showed me the details. We can mark this post as resolved.

  • vish_ch's avatar
    vish_ch
    New Contributor
    2 years ago
    Copy LinkReport

    Hi SpiroTaleski ,

    I have faced the similar issue.
    My question here is, how can I fetch these error_entity details directly in error pipeline, what is the expression to use to extract them

    I know below expressions, and these doesn't provide error_entity details


     

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    2 years ago
    Copy LinkReport

    vish_ch 

    You can access the field the same way you access the other fields: $error_entity

    But I think that not always that field is a part of the error message, so you should probably check first if the error_ entity field exist or not.