Actually, I have tried with other dataset name and for other schema's as well however every time the same error message is displayed. I checked in other temporary sandbox with some other schema to create dataset and there I don't see this issue. Not sure what is missing here, any permission, mapping...