I wanna ask,
if its possible or not to access the HWC with dbt using spark.
If you can share more details about what you are trying to achieve here, we can help you with that. Last week we have released dbt-hive adapter if it helps you here is an article to get started with it.
You can check the following link for spark and dbt integration.