I am not sure how to test queries in a Tableau Online to Databricks connection but I was able to run a different Tableau workbook attached to the same cluster and this query below was in the SQL tab of the Spark UI.

SELECT (CASE WHEN (`delta_table_campaign`.`Name` IN ('CRE_MAT_2023', 'CRE_MAT_2023_Email_Had_Prior_Communication', 'CRE_MAT_2023_Email_NO_Prior_Communication')) THEN 'CRE_MAT_2023 campaign group' ELSE `delta_table_campaign`.`Name` END) AS `name__group_`,

COUNT(DISTINCT `delta_table_contact`.`Id`) AS `usr_calculation_496170019756503042_ok`

FROM `salesforce_raw`.`delta_table_contact` `delta_table_contact`

JOIN `salesforce_raw`.`delta_table_campaignmember` `delta_table_campaignmember` ON (`delta_table_contact`.`Id` = `delta_table_campaignmember`.`ContactId`)

JOIN `salesforce_raw`.`delta_table_campaign` `delta_table_campaign` ON (`delta_table_campaignmember`.`CampaignId` = `delta_table_campaign`.`Id`)

WHERE ((NOT (`delta_table_contact`.`LaunchLeads_Status__c` IS NULL)) AND ((CASE WHEN (`delta_table_campaign`.`Name` IN ('CRE_MAT_2023', 'CRE_MAT_2023_Email_Had_Prior_Communication', 'CRE_MAT_2023_Email_NO_Prior_Communication')) THEN 'CRE_MAT_2023 campaign group' ELSE `delta_table_campaign`.`Name` END) IN ('CRE_MAT_Q1_2023', 'CRE_MAT_Q1_2023_PART_1_MF', 'CRE_MAT_Q1_2023_PART_2_TEXT', 'CRE_MAT_Q3_2024_OTHER', 'CRE_MAT_Q3_2024_OTHER_PART_1', 'CRE_MAT_Q3_2024_OTHER_PART_2')))

GROUP BY 1