Clustered columnstore indexes - Do I need to create a non clustered index on a column that's used in a join?
You should add a nonclustered columnstore index on the recommended columns. This will be compressed and should also provide a performance improvement.