Unity Catalog Table in Databricks Asset Bundle

[ShashiPrakash]

I am looking to deploy unity catalog schemas and tables via Databricks Asset Bundle (DAB). We can do schema evolution of tables via notebooks as well, but we already have 1000+ notebooks and implementing via notebooks will be an effort hence was looking to do via DAB. But i am only able to deploy Schemas via DAB, but not the tables. I could see in databricks CLI there are no option to create or update tables, but was under assumption that as DAB under the hood uses terraform, should be able to deploy tables, but it is not working. Can someone please help me out for deploying Unity Catalog tables via DAB. 

[saurabh18cs · Accepted solution]

Hi, As DAB does not directly support table creation, you can include SQL scripts in your DAB project to create or update Unity Catalog table?? What is your thought? Br

[ShashiPrakash]

Thanks for the prompt response @saurabh18cs . Yes that was the alternating i was considering. I believe it will be the warehouses group command which will explore. Will you be able to share any best practice document to manage the SQL project file, we have 2000+ tables/views in scope, and deploy delta. I assume terraform under DAB will take care of delta deployment. 

Do you also see this as a feature coming in databricks in future as part of DAB itself. 

Databricks CLI commands - Azure Databricks | Microsoft Learn