Custom SQL Import Job Error

2 followers
0
Avatar

I am seeing the following error when I enter my custom SQL "The SQL contains an illegal action or keyword: 'delete'". How do I use the word delete in my SQL filter. Do I need to wrap the text in something for datameer to recognize it as text?

Joshua Barnett

1 comment

  • Avatar
    Alan Mark

    Hi Joshua,

    The custom SQL interface only supports selecting data, not updating or deleting data.  You'll note that the text explanation next to the custom SQL box mentions to enter your select statement.

    You won't be able to escape 'delete' if you're trying to use it as a column name or asname - it's an ANSI SQL reserved word and should not be used in select queries.

    0
Please sign in to leave a comment.