How do I create an athena table (instead of hive table) in databricks?

[HowardZ]

My dashboard uses Athena as data source for its availability (I don't need to fire up the cluster and manually refresh the data), but it requires me to create the tables manually. Wondering if there is a similar method like the .saveAsTable() to create the table while writing the data to S3, thanks.

[Kaniz · Accepted solution]

Hi @Howard Zhang​, Here's a fantastic article for your use case. Please have a read.

[jose_gonzalez]

Hi @Howard Zhang​ 

Just a friendly follow-up. Did Kaniz's response helped you? do you still need help? please let us know