- 4230 Views
- 5 replies
- 1 kudos
parsing error in Databricks SQL endpoint
I have two tables EMPLOYEE & EMPLOYEE_ROLE. I'm trying to Update a column with a value from another column. I'm using SQL server join but i get an error - [parse_syntax_error] Syntax error at or near 'FROM' line 3. UPDATE CSET C.title = B.title FROM ...
- 4230 Views
- 5 replies
- 1 kudos
- 1 kudos
Hi @Vijesh V​ Try to use merge into to perform cdc between tables :MERGE INTO target aUSING source bON {merge_condition}WHEN MATCHED THEN {matched_action}WHEN NOT MATCHED THEN {not_matched_action}
- 1 kudos
- 3214 Views
- 3 replies
- 2 kudos
- 3214 Views
- 3 replies
- 2 kudos
- 2 kudos
Hi @Ravi Vishwakarma​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answ...
- 2 kudos
- 3193 Views
- 3 replies
- 0 kudos
Resolved! Not received my certificate after passing Databricks Certified Associate Developer for Apache Spark 3.0 - Python.
I've successfully passed Databricks Certified Associate Developer for Apache Spark 3.0 - Python but still have not received the certificate. E-mail : anwarpatel91@gmail.com
- 3193 Views
- 3 replies
- 0 kudos
- 0 kudos
@Nadia Elsayed​ could you please help me with this issue I need to send my certificate to my team.
- 0 kudos
- 3531 Views
- 4 replies
- 3 kudos
[Databricks][JDBC](10400) Invalid type for data - column: 10, type: Array
Getting below error while mapping an Array Column to String[] entity. Please suggest if Databricks JDBC support entity mapping of Array Values [Worked the same code for below config - H2 DB version - 2.1.214 and org.hibernate.dialect.H2Dialect - ...
- 3531 Views
- 4 replies
- 3 kudos
- 3 kudos
Hello @Emmanuel Trindade​ @Praveen C​ This does not look like coming from Databricks end. Look at the error thread.javax.persistence.PersistenceException: org.hibernate.exception.DataException: Could not read entity state from ResultSet : EntityKey...
- 3 kudos
- 1408 Views
- 1 replies
- 0 kudos
- 1408 Views
- 1 replies
- 0 kudos
- 0 kudos
Delta Sharing is an open protocol developed by Databricks for secure data sharing with other organizations. The primary concepts underlying Delta Sharing in Databricks are shares and recipients. A share is a read-only collection of tables and table p...
- 0 kudos
- 12090 Views
- 4 replies
- 3 kudos
Load CSV files with slightly different schemas
I have a set of CSV files generated by a system, where the schema has evolved over the years. Some columns have been added, and at least one column has been renamed in newer files. Is there any way to elegantly load these files into a dataframe? I ha...
- 12090 Views
- 4 replies
- 3 kudos
- 3 kudos
For reference - for anybody struggling with the same issues. All online examples using auto loader are written as one block statement on the form: (spark.readStream.format("cloudFiles") .option("cloudFiles.format", "csv") # The schema location di...
- 3 kudos
- 3318 Views
- 2 replies
- 2 kudos
Perform database operations like INSERT, and MERGE using the backend service (golang)
I would like to have an example or reference documentation on how we can create a live (capable of real-time data persistence) pipeline from an in-house golang (backend) service to the databricks tables.I would give a bit more detail on what the gola...
- 3318 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @Harikrishnan G​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answer...
- 2 kudos
- 9536 Views
- 2 replies
- 3 kudos
Unable to read data from delta table using a python script after the table properties change.
Renamed the Column to include () in a delta table and set the table properties to the below ​ALTER TABLE test_table SET TBLPROPERTIES ( 'delta.minReaderVersion' = '2', 'delta.minWriterVersion' = '5', 'delta.columnMapping.mode' = 'name' ) However w...
- 9536 Views
- 2 replies
- 3 kudos
- 3 kudos
Hi @Lakshmi Jayaraman​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best ans...
- 3 kudos
- 1693 Views
- 2 replies
- 1 kudos
unable to login Databricks partner account same id and password as Acadmey Account.
Unable to login Databric partner academy account. same as Acadmey give me a link to verify my mail to databric partner Account. I have try soo many time but unable to verify and login to databric partner Account .
- 1693 Views
- 2 replies
- 1 kudos
- 1 kudos
Hi @Firoz Ahmad Ansari​ Thank you for reaching out! Please submit a ticket to our Training Team here: https://help.databricks.com/s/contact-us?ReqType=training and our team will get back to you shortly.
- 1 kudos
- 8468 Views
- 2 replies
- 0 kudos
Databricks Devops Release Pipeline Abort
We've built a release pipeline to our Databricks Workspaces, using the VNET Template. It's working end-to-end but intermittent aborts are occurring when workspace is recreated.For example, 4th of April (Monday) We recreated the workspaces and no abor...
- 8468 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @Jonas Oliveira de Souza​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that be...
- 0 kudos
- 1424 Views
- 2 replies
- 0 kudos
Where is the dbc file for this couse :Â Deep Dive Into Lakehouse with Delta Lake
Where is the dbc file for this couse :Deep Dive Into Lakehouse with Delta Lake
- 1424 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @G S​ Thank you for reaching out! Please submit a ticket to our Training Team here: https://help.databricks.com/s/contact-us?ReqType=training and our team will get back to you shortly.
- 0 kudos
- 4934 Views
- 1 replies
- 1 kudos
Database Objects Naming Convention for Bronze, Silver and Gold Layers
Please help me for database Objects Naming Convention and coding standard for Bronze, Silver and Gold Layers
- 4934 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @Arun Sharma​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers y...
- 1 kudos
- 7508 Views
- 5 replies
- 5 kudos
Resolved! Unity Catalog - Azure account console - how to access?
I'm trying to access account console in Azure but I only can see the list of workspaces and access them. I didn't find documentation about account console for Azure. Do you know how to access account console?
- 7508 Views
- 5 replies
- 5 kudos
- 5 kudos
Hello @Leszek​ . Please tell me is it works for you ?Did you find the root cause ?I still don't understand why I should grant to myself some extra permissions if I already global administrator, owner of subscription, owner of databricks workspace but...
- 5 kudos
- 2892 Views
- 2 replies
- 0 kudos
How to link 2 Dashboards
Hi, I have 2 dashboards. 1st Dashboard has a table with two columns, 'Country' and 'NumberOfMajorCities'. When I click on any row of this table/click on 'NumberOfMajorCities' field of a row, I would like to jump to 2nd Dashboard, where I display all ...
- 2892 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @Ghazanfar Sl​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers ...
- 0 kudos
- 6882 Views
- 3 replies
- 1 kudos
Error when creating a delta live table pipeline
INVALID_PARAMETER_VALUE: Validation failed for node_type_id, the value must be Standard_DS3_v2 (is "Standard_F8s")
- 6882 Views
- 3 replies
- 1 kudos
- 1 kudos
Hi @Nitya Mehta​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers y...
- 1 kudos
| User | Count |
|---|---|
| 1611 | |
| 768 | |
| 348 | |
| 286 | |
| 252 |
