Hi @hanssaj - You can maintain a business glossary which will have your column details and for each table a unique value. This unique value can be take as Physical table id as your source reference in logical map file. See the link - Quicksight dataset with API table map - #4 by Sanjeeb2022
Hope this will help you.
Regards - Sanjeeb