Can someone guide me how to disable data sync option in record type with proper images guidance ?
Discussion posts and replies are publicly visible
Then you can simply use CDTs like you said. Are you facing any issues while doing it?
For me it's not clear what your actual requirement is.
Are you aware that in 24.1 you are able to sync the latest 4 million rows in the database?
https://docs.appian.com/suite/help/24.1/Appian_Release_Notes.html#keep-record-data-available-at-high-volumes