Hey Ryan -
The Custom SQL in a published workbook (or data source) cannot be viewed from directly in the Tableau Server portal.
You'll need to download the workbook and/or data source locally and open it up manually.
Thanks Russell! That's what I figured I would have to do.