- 2938 Views
- 3 replies
- 2 kudos
Table name as a parameter in SQL UDF
Hello experts,We would like to create a UDF function with input parameter a table_name. Please check the below simple example:CREATE OR REPLACE FUNCTION F_NAME(v_table_name STRING, v_w...
- 2938 Views
- 3 replies
- 2 kudos
- 3863 Views
- 3 replies
- 2 kudos
Resolved! Hello Community Users, Â We recently announced a new Large Language Models (LLM) program, the first of its kind on edX! Learn how to develop production...
Hello Community Users, We recently announced a new Large Language Models (LLM) program, the first of its kind on edX! Learn how to develop production-ready LLM applications and dive into the theory behind foundation models. Taught by industry experts...
- 3863 Views
- 3 replies
- 2 kudos
- 2 kudos
Hi @163050 You could download the Dbc file from the course, we already have the LLM course in the Customer Academy.
- 2 kudos
- 4032 Views
- 5 replies
- 1 kudos
Resolved! Concatenating strings based on previous row values
Consider the following input:ID PrevID -------- --------- 33 NULL 272 33 317 272 318 317I need to somehow get the following result:Result -------- /33 /33/272 /33/272/317 /33/272/317/318I need to do this in SQL a...
- 4032 Views
- 5 replies
- 1 kudos
- 1 kudos
https://speakerdeck.com/mitasingh https://telegra.ph/Free-Printable-cover-letter-template-01-17 https://www.imdb.com/user/ur148564602/?ref_=nv_usr_prof_2 https://www.glenewinestate.com.au/profile/coverletter50/profile https://www.wpanet.org/profile/c...
- 1 kudos
- 1830 Views
- 1 replies
- 5 kudos
docs.databricks.com
New unified Databricks navigationDatabricks plans to enable the new navigation experience (Public Preview) by default for all users. You’ll be able to opt out by clicking Disable new UI in the sidebar.The goal of the new experience is to reduce click...
- 1830 Views
- 1 replies
- 5 kudos
- 5 kudos
Hi @Priyadarshini G​ Thank you for providing accurate and valuable information.Best Regards
- 5 kudos
- 4962 Views
- 2 replies
- 2 kudos
Resolved! "Photon ran out of memory" while when trying to get the unique Id from sql query
I am trying to get all unique id from sql query and I always run out of memoryselect concat_ws(';',view.MATNR,view.WERKS) from hive_metastore.dqaas.temp_view as view join hive_metastore.dqaas.t_dqaas_marc as marc on marc.MATNR = view.MATNR where view...
- 4962 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @Anil Kumar Chauhan​ We haven't heard from you since the last response from @Werner Stinckens​ . Kindly share the information with us, and in return, we will provide you with the necessary solution.Thanks and Regards
- 2 kudos
- 1258 Views
- 1 replies
- 7 kudos
Train machine learning models: How can I take my ML lifecycle from experimentation to production?
Note: the following guide is primarily for Python users. For other languages, please view the following links: • Table batch reads and writes • Create a table in SQL • Visualizing data with DBSQLThis step-by-step guide will get your data...
- 1258 Views
- 1 replies
- 7 kudos
- 7 kudos
I got good knowledge by your post . It is very clear . Thank you . Keep sharing like this posts .It will be helpful
- 7 kudos
- 1178 Views
- 2 replies
- 3 kudos
www.databricks.com
Hello Dolly: Democratizing the magic of ChatGPT with open modelsDatabricks has just released a groundbreaking new blog post exploring ChatGPT, an open-source language model with the potential to transform the way we interact with technology. From cha...
- 1178 Views
- 2 replies
- 3 kudos
- 3 kudos
Lets get candid! Let me know your initial thoughts about LLM Models, ChatGpt, Dolly.
- 3 kudos
- 2572 Views
- 3 replies
- 1 kudos
Can I run a custom function that contains a trained ML model or access an API endpoint from within a SQL query in the SQL workspace?
I have a dashboard and I'd like the ability to take the data from a query and then predict a result from a trained ML model within the dashboard. I was thinking I could possibly embed the trained model within a library that I then import to the SQL w...
- 2572 Views
- 3 replies
- 1 kudos
- 1 kudos
@Erik Shilts​ :Yes, it is possible to use a trained ML model in a dashboard in Databricks. Here are a few approaches you could consider:Embed the model in a Python library and call it from SQL: You can train your ML model in Python and then save it a...
- 1 kudos
- 1881 Views
- 5 replies
- 1 kudos
Latest Blog PostsJanuary 13 - 20Â Did you get a chance to look at the most recent blog posts? Here are some happening content from the past week that i...
Latest Blog PostsJanuary 13 - 20Did you get a chance to look at the most recent blog posts? Here are some happening content from the past week that is worth the read. What’s New With SQL User-Defined Functions In this blog, we describe several enhanc...
- 1881 Views
- 5 replies
- 1 kudos
- 1 kudos
Thanks @Sujitha Ramamoorthy​ , for sharing with the community these are worth reading and insightful.
- 1 kudos
- 969 Views
- 1 replies
- 0 kudos
Weekly Release Notes Recap Here’s a quick recap of the latest release notes updates from the past one week. Databricks platform release notesJanuary 1...
Weekly Release Notes RecapHere’s a quick recap of the latest release notes updates from the past one week.Databricks platform release notesJanuary 13 - 19, 2023Cluster policies now support limiting the max number of clusters per userYou can now use c...
- 969 Views
- 1 replies
- 0 kudos
- 0 kudos
thanks for the details
- 0 kudos
- 1676 Views
- 1 replies
- 1 kudos
Permission errors.
I have some permission erros when I want to modify some sql queries in SQL module. We are two colleauge working on one project so we build da data model. Sometimes we need to correct each other and access the SQL code but unfortunelty we dont have a...
- 1676 Views
- 1 replies
- 1 kudos
- 1 kudos
you not worry here , give permission as a viewer only , or else they will use your creds there This doc will be helpful - https://docs.databricks.com/security/access-control/query-acl.htmlThanksAviral Bhardwaj
- 1 kudos
- 4372 Views
- 1 replies
- 4 kudos
Resolved! Insert into delta table fails
Hello experts. We are trying to execute an insert command with less columns than the target table:Insert into table_name( col1, col2, col10)Select col1, col2, col10from table_name2However the above fails with:Error in SQL statement: DeltaAnalysisExce...
- 4372 Views
- 1 replies
- 4 kudos
- 4 kudos
Hi @ELENI GEORGOUSI​ Yes. When you are doing an insert, your provided schema should match with the target schema else it would throw an error.But you can still insert the data using another approach. Create a dataframe with your data having less colu...
- 4 kudos
- 1594 Views
- 1 replies
- 1 kudos
Pass parameter from python to SQL - Null result
Hello. Could someone please explain at the below example, why having the prefix "da" at the parameter name allows us to select the parameter value but not having it returns to a null value?Correct valueNull value Thank you in advance
- 1594 Views
- 1 replies
- 1 kudos
- 1 kudos
Any insight on this? Thank you!
- 1 kudos
- 1084 Views
- 1 replies
- 3 kudos
Can the HTML behind a SQL visualisations be accessed?
We are using MLFlow to manage the usage of some self service notebooks. This involves logging parameters, tables and figures. Figures are logged using:mlflow.log_figure( figure=fig, artifact_file="visual/fig.html" )Usually the fig object is gener...
- 1084 Views
- 1 replies
- 3 kudos
- 3 kudos
There is no way to access the html used. You can download the images. The editor uses redash, so you can try looking at that library for more information.
- 3 kudos
- 1390 Views
- 3 replies
- 0 kudos
EOFError trying to assign a model using a custom module
I'm in a Data Science Bootcamp, and the final case study includes data preprocessing (done), using a linear regression model on the data, then porting to SQL for visualization. The model build uses custom python code provided as part of the exercise....
- 1390 Views
- 3 replies
- 0 kudos
- 0 kudos
Hi @Joe DiGiovanni​ Just wanted to check in if you were able to resolve your issue or do you need more help? We'd love to hear from you.Thanks!
- 0 kudos