@DerivedTable is a new function in IDT and its used within the derived Table and also called as “’derived table on a derived table”. @DerivedTable function in the definition of nested derived tables and is a table that is derived from at least one existing derived table.
The syntax of the @DerivedTable function is:
@DerivedTable(<Derived table name>)
<Derived table name> is the name of the derived table you want to reference and it should be defined within double quotes. The @DerivedTable function is only used in the definition of derived tables in the data foundation.
Insert Derived table in Data foundation:
Derived Table “Region_Sales_derived” created.
This “Region_Sales_Derived” derived table will be used in another derived table using @DerivedTable function.
Note: In database-specific SQL (multisource-enabled data foundations), all tables referenced must be from the same connection.