@dhruv1 

Canceling a subscription alone will not delete your Databricks account; the account will remain active. You will need to follow the steps outlined in the following documentation:
Delete Your Databricks Account

Additionally, a past topic in the community might also be helpful for you:
Delete Databricks Account - Community Discussion

I hope this helps!