I tried enabling 3 options as recommended in documentation

"delta.enableChangeDataFeed": "true"
"delta.enableRowTracking": "true"
"delta.enableDeletionVectors": "true"

but no luck, will try registering as external table later since my workspace has not enabled it yet.