- 6068 Views
- 6 replies
- 1 kudos
Delta Live Tables @expect compare tables count between two stages
Hello,I'm wondering if there is an option to make an expectation on DLT that will compare the number of records between two stages and e.g. fail if there is a difference between those counts?I mean something like this:@dlt.table()def bronze(): Some...
- 6068 Views
- 6 replies
- 1 kudos
- 1 kudos
Hi @Jacek Dembowiak​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Th...
- 1 kudos
- 2657 Views
- 3 replies
- 1 kudos
I have cleared Databricks Foundational Accreditation today and received the completion certificate. But I didnt receive the badge for the same. By whe...
I have cleared Databricks Foundational Accreditation today and received the completion certificate. But I didnt receive the badge for the same. By when I will receive the badge ?
- 2657 Views
- 3 replies
- 1 kudos
- 1 kudos
Hi @Sakshi Puchnanda​ Does @Hubert Dudek​ response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?We'd love to hear from you.Thanks!
- 1 kudos
- 2604 Views
- 3 replies
- 1 kudos
Incorrect results with df.query()
I have tried pulling a single row from a .csv using df.query()However, the data being returned doesn't coincide with the data I'm expecting - it is pulling a different row. Here is my code:df = spark.read.option("header",True).csv(data_fldr + "config...
- 2604 Views
- 3 replies
- 1 kudos
- 1 kudos
Hi @Peter Ott​ Does @Hubert Dudek​ response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?We'd love to hear from you.Thanks!
- 1 kudos
- 3467 Views
- 2 replies
- 1 kudos
Multiple DLT Pipelines Sharing a Single Cluster
When you use Workflows to orchestrate standard notebooks, they can share a single cluster. It will be awesome if we can achieve the same for DLT pipelines orchestrated in a Workflows Job.I understand DLT pipelines utilising their own special clusters...
- 3467 Views
- 2 replies
- 1 kudos
- 1 kudos
Hi @Bo Zhu​ Does @Hubert Dudek​ response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?We'd love to hear from you.Thanks!
- 1 kudos
- 3098 Views
- 2 replies
- 0 kudos
Databricks-jdbc and vulnerabilities CVE-2022-42004, CVE-2022-42003
The latest version of Databricks-jdbc available through Maven (2.6.29) now has these two vulnerabilities:https://nvd.nist.gov/vuln/detail/CVE-2022-42004https://nvd.nist.gov/vuln/detail/CVE-2022-42003All due to depending on and including in the jar th...
- 3098 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @Lars Joreteg​ Does @Hubert Dudek​ response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?We'd love to hear from you.Thanks!
- 0 kudos
- 3969 Views
- 3 replies
- 1 kudos
Pipeline in Community edition
Hi there,I'm learning Databricks using the community edition. I noticed I don't have way to practice the pipeline in community edition. (The icon below compute). Says I need to upgrade. Is there any way to practice pipeline and follow learning lesson...
- 3969 Views
- 3 replies
- 1 kudos
- 1 kudos
Hi @AJ DJ​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Thanks!
- 1 kudos
- 14900 Views
- 4 replies
- 5 kudos
SQL CTE in Databricks or something similar?
%sqlWITH genCTE AS (SELECT MAX(PredID) + 1 AS PredID, 145 AS SystemIDFROM TableAUNION ALLSELECT PredID + 1FROM genCTE)SELECT * FROM genCTEWhen I attempt this, I get an error that genCTE does not exists.There may be a better way to what I am trying to...
- 14900 Views
- 4 replies
- 5 kudos
- 5 kudos
Hi @Greg Bradley​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Thank...
- 5 kudos
- 18344 Views
- 7 replies
- 3 kudos
uuid in Merge
Hi guys,I'm trying to use uuid in the merge but I always get an error...import uuid ( df_events.alias("events").merge( source = df_updates.alias("updates"), condition = "events.cod = updates.cod and events.num = updates.num" ).whenMatch...
- 18344 Views
- 7 replies
- 3 kudos
- 3 kudos
Hi @William Scardua​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Th...
- 3 kudos
- 6418 Views
- 5 replies
- 3 kudos
New Visualization Tools
How do I add new visualization tool option to my databricks? I don't see a plus sign that will let you choose "Visualization" in my display command results :(. Please help.
- 6418 Views
- 5 replies
- 3 kudos
- 3 kudos
Hi @Suky Muliadikara​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.T...
- 3 kudos
- 4651 Views
- 2 replies
- 3 kudos
Issue with identity key column in databricks?
For the identity key I've used both GENERATED ALWAYS AS IDENTITY(start with 1 increment by 1) andGENERATED BY DEFAULT AS IDENTITY(start with 1 increment by 1)but in both cases, if I'm running my script once then it is fine (identity key is working as...
- 4651 Views
- 2 replies
- 3 kudos
- 3 kudos
yes, by default option allow duplicated values per design.I will avoid this option and use only use GENERATED ALWAYS AS IDENTITY Using BY DEFAULT option is worse than not using it at all in BY Default option, If I forget to set starting value, the ID...
- 3 kudos
- 2432 Views
- 1 replies
- 4 kudos
DLT DataPlaneException
I created an Azure Databricks workspace with my Visual Studio Subsciption, so far everything has been working as expected although I have requested to increase CPU core limit once.I am now getting this "DataPlaneException" error in the DTL during "Wa...
- 2432 Views
- 1 replies
- 4 kudos
- 4 kudos
@Bo Zhu​ can we get more error log, looks quota limit exceeded. did you get a chance to check quota in azure portal and see if cores exists for config that you selected. try to select another cluster config and validate
- 4 kudos
- 4014 Views
- 1 replies
- 4 kudos
My DLT pipeline return ACL Verification Failed
Python Commanddf = spark.read.format('csv').option('sep', ';').option("recursiveFileLookup", "true").load('dbfs:/***/data_files/PREVISIONS/')Here is the content of the folder Each folder contain the following files: Full logorg.apache.spark.sql.stre...
- 4014 Views
- 1 replies
- 4 kudos
- 4 kudos
Yes some of the files I don't have the right to access (mistakenly) In this case, how do you think I can tell DTL to handle this exception and ignore the file, since I can read some files but not all?
- 4 kudos
- 2366 Views
- 1 replies
- 2 kudos
How to jump back to latest positions in the Notebook
Hi,when developing I often need to jump around the Notebook to fix and run things. It would be really helpful so I can jump back to several latest positions (cells), similarly, like in Office Word by SHIFT+F5 key. Is here a way now in Databricks?Than...
- 2366 Views
- 1 replies
- 2 kudos
- 2 kudos
@Retko Okter​ go to any of notebook and click on help-->keyboard shortcuts, they will show all possibilities that you need
- 2 kudos
- 2786 Views
- 2 replies
- 3 kudos
course code - 'ACAD-INTRO-DELTALAKE' Notebook has errors
Dear DB Team,While following a course from DB Academy course code - 'ACAD-INTRO-DELTALAKE' noticed the notebooks has errors can you please check i have also attached the notebookRegards,Rakesh
- 2786 Views
- 2 replies
- 3 kudos
- 3 kudos
Hi @Rakesh Reddy Gopidi​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from yo...
- 3 kudos
- 4975 Views
- 3 replies
- 4 kudos
Resolved! dropDuplicates
Afternoon Community!! I've done some research today and found multiple, great approaches to accomplish what I'm trying to do, but having trouble understanding exactly which is best suited for my use case.Suppose you're running Auto Loader on S3 and u...
- 4975 Views
- 3 replies
- 4 kudos
- 4 kudos
If you records are partitioned to narrow down your search, then can you try writing an upsert logic after autoloader code?The upsert logic will insert, update or drop rows as per your conditions.
- 4 kudos
| User | Count |
|---|---|
| 1644 | |
| 793 | |
| 576 | |
| 349 | |
| 287 |
