Is direct query compatible with Amazon Athena?

HI djurecic ,

Thanks for confirming.

Initially, I was using Import mode, but due to the large volume of data, I switched to DirectQuery mode. However, I began encountering errors, and the "Apply changes" banner continued to appear even after clicking 'OK'.

The query starts with Value.NativeQuery. Could this be contributing to the issue? I would appreciate your insights on this matter.

Thanks & Regards

Minu