2 of 2 people found this helpful
Answering my own question here!
I was able to get access to our Athena AWS console, and found that I needed to reference my source table as "tableau"."ad_sales_revenue_attribution" instead of just ad_sales_revenue_attribution where "tableau" is the S3 bucket we store data for our Tableau integration.
If you come across a similar issue I'd suggest getting access to your AWS console (or connecting with someone who does have access) to debug the query on that side.