topic Re: DABs vs API in Administration & Architecture https://community.databricks.com/t5/administration-architecture/dabs-vs-api/m-p/87667#M1712 <P>DABs use Terraform which in turn calls the API anyway. So, I guess it comes down to personal preference of deployment consistency, code maintenance etc. However, from your description of "taking a user's SQL" I'm assuming some sort of real-time application interface that takes the SQL query and builds assets. If so, I would go directly to the API instead of using DAB. If not and it is something about "productionizing" user's SQL queries in a programmatic manner, then DAB's with appropriate scheduled workflows/jobs is the way to go.</P> Tue, 03 Sep 2024 01:07:32 GMT Shazaamzaa 2024-09-03T01:07:32Z DABs vs API https://community.databricks.com/t5/administration-architecture/dabs-vs-api/m-p/83681#M1618 <P>DABs seem like a great way to build a project based workflow.&nbsp; However, I have a need to take a user's SQL and create a TABLE/VIEW based on it.&nbsp; We plan to use the API to submit the request but is this the best way going forward?&nbsp; Should we consider wrapping the user's SQL changes into a DAB and go through the creation this way?</P> Tue, 20 Aug 2024 19:58:33 GMT https://community.databricks.com/t5/administration-architecture/dabs-vs-api/m-p/83681#M1618 jlowe 2024-08-20T19:58:33Z Re: DABs vs API https://community.databricks.com/t5/administration-architecture/dabs-vs-api/m-p/87667#M1712 <P>DABs use Terraform which in turn calls the API anyway. So, I guess it comes down to personal preference of deployment consistency, code maintenance etc. However, from your description of "taking a user's SQL" I'm assuming some sort of real-time application interface that takes the SQL query and builds assets. If so, I would go directly to the API instead of using DAB. If not and it is something about "productionizing" user's SQL queries in a programmatic manner, then DAB's with appropriate scheduled workflows/jobs is the way to go.</P> Tue, 03 Sep 2024 01:07:32 GMT https://community.databricks.com/t5/administration-architecture/dabs-vs-api/m-p/87667#M1712 Shazaamzaa 2024-09-03T01:07:32Z