Hi all,

According to the documentation, if i extract new and changed records of a table Table with delta extraction, I should be able to access to these data using the placeholder <$Table> in transformation tasks.

I'm trying to set up a delta pipeline, but my transformation ends with errors, because the placeholder <$Table> seems not to be recognized, even if I launch the tasks in delta mode.

I have already set up delta extractions and I am doing mock trials to understand the error, which I paste here:

• If I reference the placeholder with <$Table>, I obtain "ERROR: Syntax error at or near "<" at character 101".
• If i reference the placeholder with "<$Table>", I obtain "ERROR: Relation "<$Table>" does not exist".

The structure of my delta transformation is:

CREATE TABLE TMP_Table AS (

  SELECT

    Field_1,

    Field_2

  FROM <$Table>

);

What could cause this error? Am i missing some further configuration?

Thanks