...
The API design is fairly simple, and only involves the creation of a new Entity type that extends the View Table interface called MaterializedView:
Field Name | type | description |
|---|---|---|
definingSQL | String | A Synapse SQL statement that fully defines this materialized view. |
Unlike other Views or Tables, a MaterializedView is fully defined by its single property: definingSQL. The schema of the MaterializedView will be derived directly from the SQL select statement. While the scope of the MaterializedView is derived from both the SQL from statements, and where statements.
...