Master Databricks Assistant: Step-by-Step Tutorial

0:01hello my name is Yusef today I'm introducing one of the hottest features that databricks has recently introduced during the data and AI Summit this feature is that data breaks are distant it works as an AI based companion per programmer to make you more efficient as you create notebooks query and queries

0:24it can help you rapidly answer questions by generating and optimizing completing fixing your code as well and how do I enable databricks assistant we just need to go to the accounts console click on settings feature enablement and then enable third-party services for AI assistive features

0:46why should I do this because database assistant may use third-party services to provide response including Azure open Ai and the open AI API these services are subject to their respective data management policies and data sent to these Services is automatically pushed within 30 days and is not used for any model training

1:11and something very very important database assist does not automatically execute code on your behalf and make sure to review the AI generated code prior to executing so let's go back to the database system so just need to go to your notebook and click on assistant

1:33and the first I will do I will run this query and then ask the assistant can you explain a square and you see over here I have a bunch of uh names of teams so yes as you guess it I'm a huge Premier League fan and the result is this query will return

1:56lists of boost block teams that won against TLC in away game in 2009 and yes that's correct I will run the second query and you see I have an error so I just need to click on fix my code and the assistant will generate the right query for me so I can just and you

2:22see I have the correct results it's showing all the year where Chelsea scored more than 100 call I can also for example generate code like uh in Hue generate a pie chart and not

2:45plot sleep of the percent win we would draw or Chelsea in 2009. and once it's done I can send my God to my notebook and run

3:08my my code to have the expected result so you see the person twin is 71 Pro 13 and the last is 15 of course I can also use the assistant to think to ask

3:30questions for documentation uh can I declare a volume in unity catalog I can also ask some questions about how to optimize how to optimize the code and something very very important the database assistant sends code and

3:52metadata to the modes on each API request so this helps return more relevant results for your data so it can be like several tables previous questions table and column names and descriptions and code queries in the current cell of course it only reads the table and the column

4:14name not the data not the data inside the table and the database assistant requests may include the context like the contents of the current cell or the query window and that's how I was able to still get the context as I was asking questions to the assistant and of course you can also

4:36think about questions like how to optimize or how to convert for example Sparky to Delta and more and more like questions thank you for watching this video