Transformation,s in direct query mode for amazon redshift

[chotu27]

Hi all,

Can we do below in Direct query mode 

1.change column type

2.transformations

3. calculated columns 

4. measures

[v-jiascu-msft · Accepted solution]

Hi @chotu27,

According to my test, they all can be done in Direct Query mode. But some complicate Calculated Columns and Measures might not be supported. "Transpose" and "Unpivot Columns" aren't supported. You can have a try.

Best Regards!

Dale