https://community.databricks.com/t5/community-articles/new-in-notebooks-ai-powered-databricks-assistant-improved/m-p/49632#M79 <P><SPAN>We are excited to share some of the latest updates in Databricks Notebooks. From AI-powered Databricks Assistant that automates code development to new charts with better performance, these features help you build faster.</SPAN></P> <P><SPAN>See the latest features live at the <A href="https://www.youtube.com/watch?v=g9REIGKkAVo&amp;embeds_referring_euri=https%3A%2F%2Fwww.databricks.com%2F&amp;embeds_referring_origin=https%3A%2F%2Fwww.databricks.com&amp;feature=emb_imp_woyt" target="_blank" rel="noopener">webinar on October 24</A>.<BR /><BR /></SPAN></P> <H3><SPAN>Let’s start with Databricks Assistant</SPAN></H3> <P><SPAN><A href="https://www.databricks.com/blog/introducing-databricks-assistant" target="_blank" rel="noopener">Databricks Assistant</A> makes you more productive inside Databricks. Describe your task in English and let the Assistant generate SQL queries, explain complex code, and automatically fix errors. The Assistant leverages context from your notebook and Unity Catalog metadata to provide accurate, personalized responses.<BR /><BR /></SPAN></P> <H3><SPAN>Generate SQL or Python code</SPAN></H3> <P><SPAN>Databricks Assistant is natively integrated into Notebooks, SQL editor and file editor. It can help you accelerate projects by writing boilerplate code or providing initial code for you to start with. You can then execute the code, copy it, or add it into a new cell for further development.</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="generatecode.gif" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4514iDEEEB82B646DCD4B/image-size/large?v=v2&amp;px=999" role="button" title="generatecode.gif" alt="generatecode.gif" /></span></P> <H3>&nbsp;</H3> <H3><SPAN>Explain code or queries</SPAN></H3> <P><SPAN>Databricks Assistant describes complex pieces of code or queries in clear, concise language, making it easier to quickly ramp up on unfamiliar codebases. </SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="explain_code.gif" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4515iC99F54DD31F52F6C/image-size/large?v=v2&amp;px=999" role="button" title="explain_code.gif" alt="explain_code.gif" /></span></P> <H3><SPAN><BR />Fix issues</SPAN></H3> <P><SPAN>Databricks Assistant can identify errors in your code and recommend fixes. When you encounter issues like syntax errors, the Assistant will explain the problem and create a code snippet with a proposed fix.</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fix_code (3).gif" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4516i21F5DB2CCCBFD28E/image-size/large?v=v2&amp;px=999" role="button" title="fix_code (3).gif" alt="fix_code (3).gif" /></span></P> <P><SPAN>Databricks Assistant applies a number of signals to provide more accurate, relevant results. It uses context from code cells, libraries, and tables in your notebook to generate code and queries.<BR /><BR /></SPAN><SPAN>Watch the </SPAN><A href="https://www.youtube.com/watch?v=g9REIGKkAVo" target="_blank" rel="noopener"><SPAN>demo</SPAN></A><SPAN> or enable the Assistant by following </SPAN><A href="https://docs.databricks.com/en/notebooks/databricks-assistant-faq.html#q-how-do-i-enable-databricks-assistant" target="_blank" rel="noopener"><SPAN>these instructions</SPAN></A><SPAN>.</SPAN></P> <H2><SPAN><BR />Better performance and improved colors for visualizations</SPAN></H2> <P><SPAN>Databricks has released a Public Preview of <A href="https://docs.databricks.com/en/visualizations/preview-chart-visualizations.html" target="_blank" rel="noopener">new charts for visualizing data</A> in notebooks and in Databricks SQL. These new charts feature better performance, improved colors, and faster interactivity. These charts will replace the legacy rendering library currently used by Databricks charts.</SPAN></P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-10-20 at 10.11.24 AM.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4517iEA69769FE48BA601/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-10-20 at 10.11.24 AM.png" alt="Screenshot 2023-10-20 at 10.11.24 AM.png" /></span></SPAN></P> <H2><SPAN><BR />Access web terminal from within Notebooks</SPAN></H2> <P><SPAN><A href="https://docs.databricks.com/en/clusters/web-terminal.html#launch-the-web-terminal" target="_blank" rel="noopener">Databricks web terminal</A> provides a convenient way to run shell commands and use editors, such as Vim or Emacs, on the Spark driver node. Unlike using SSH, web terminal can be used by many users on one cluster and does not require setting up keys. Example uses of the web terminal include monitoring resource usage and installing Linux packages.</SPAN></P> <P>&nbsp;</P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="web_terminal.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4518iF22B15D66D9320E4/image-size/large?v=v2&amp;px=999" role="button" title="web_terminal.png" alt="web_terminal.png" /></span></SPAN></P> <H3><SPAN><BR />View all your data without leaving Notebooks</SPAN></H3> <P><SPAN>The new unified <A href="https://docs.databricks.com/en/notebooks/notebooks-code.html#browse-data" target="_blank" rel="noopener">schema browser</A> lets you view all of your data without leaving a notebook. You can select “For you” to filter the list to the active tables in your notebook. As you type your search request into the filter box, the display actively updates to show only those items that contain that text. This will look for items that are currently open or have been opened earlier in the current session.</SPAN></P> <P>&nbsp;</P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-10-20 at 10.15.00 AM.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4519i4476BF84494E7C34/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-10-20 at 10.15.00 AM.png" alt="Screenshot 2023-10-20 at 10.15.00 AM.png" /></span></SPAN></P> <H2>&nbsp;</H2> <H3><SPAN>Easily navigate between notebooks with search</SPAN></H3> <P><A href="https://docs.databricks.com/en/search/index.html" target="_blank" rel="noopener"><SPAN>Search</SPAN></A><SPAN> now returns more relevant results. It shows recents and can now return tables with Unity Catalog that match the search query semantically in addition to keyword matching.</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-10-20 at 10.16.43 AM.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4520i58627E6BA7C93521/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot 2023-10-20 at 10.16.43 AM.png" alt="Screenshot 2023-10-20 at 10.16.43 AM.png" /></span></P> <H2><SPAN><BR />Use SQL warehouses in Notebooks</SPAN></H2> <P><SPAN>Databricks </SPAN><A href="https://docs.databricks.com/en/sql/admin/create-sql-warehouse.html" target="_blank" rel="noopener"><SPAN>SQL warehouses</SPAN></A><SPAN> are now public preview in notebooks, combining the flexibility of notebooks with the performance and TCO of Databricks SQL Serverless and Pro warehouses. To enable SQL warehouses in notebooks, simply select an available SQL warehouse from the notebooks compute dropdown.</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sqlwarehouse_ws1.gif" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/4521iAD67467B2063C218/image-size/large?v=v2&amp;px=999" role="button" title="sqlwarehouse_ws1.gif" alt="sqlwarehouse_ws1.gif" /></span></P> <P>&nbsp;</P> <H3><SPAN>Improved autocomplete for SQL</SPAN></H3> <P><A href="https://docs.databricks.com/en/notebooks/notebook-editor.html" target="_blank" rel="noopener"><SPAN>Autocomplete</SPAN></A><SPAN> now always detects if you’ve already typed the table alias and therefore will avoid populating the alias twice. It recommends popular joins for tables on Unity Catalog and now works for all CTEs and subqueries.</SPAN></P> <H3><SPAN><BR />Other improvements</SPAN></H3> <UL> <LI style="font-weight: 400;" aria-level="1"><SPAN>Refreshed developer settings page</SPAN></LI> <LI style="font-weight: 400;" aria-level="1"><SPAN>Dark mode in more areas</SPAN></LI> <LI style="font-weight: 400;" aria-level="1"><SPAN>Visualizations in notebooks have a larger hit area for mouse actions</SPAN><SPAN><BR /><BR /></SPAN></LI> </UL> <P><SPAN>Stay tuned for more innovations in Notebooks.</SPAN></P> Fri, 20 Oct 2023 18:45:19 GMT Taha_Hussain 2023-10-20T18:45:19Z https://community.databricks.com/t5/community-articles/new-in-notebooks-ai-powered-databricks-assistant-improved/m-p/49632#M79 <P><SPAN>We are excited to share some of the latest updates in Databricks Notebooks. From AI-powered Databricks Assistant that automates code development to new charts with better performance, these features help you build faster.</SPAN></P> Fri, 20 Oct 2023 18:45:19 GMT https://community.databricks.com/t5/community-articles/new-in-notebooks-ai-powered-databricks-assistant-improved/m-p/49632#M79 Taha_Hussain 2023-10-20T18:45:19Z