Functions/Synonyms in Parallel Data Warehouse

Question

I know in PDW, functions and synonyms are not supported. Any idea, what's the alternative for these?

Thanks in advance.

Answer 1

The Analytics Platform System v2 Appliance Update 3 supports scalar UDF functions. You can download the Analytics Platform System AU3 Help file for more details.

We are planning on adding synonym support in a future release.

Answer 2

Synonyms - just referring to the underlying object.

Functions - sub-queries, views, or stored procedures that populate temp tables.