Clustered columnstore indexes - Do I need to create a non clustered index on a column that's used in a join? I have two very large tables that need to be joined to produce a data extract. Both tables have clustered column store indexes and are partitioned.

DW Sentry advises me in the plan view that it thinks a NC index should be added, but without compression, it's likely to be a very large index. Does anyone know about the join characteristics for a columnstore?
You should add a nonclustered columnstore index on the recommended columns. This will be compressed and should also provide a performance improvement.