- 977 Views
- 1 replies
- 1 kudos
Resolved! Delta live table not showing in workspace (Azure databricks with premium plan)
- I have a premium plan and owner level access
- 977 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @kcyugesh ,They changed the name from DLT to Lakeflow Declartive Pipelines, so you won't find DLT name in UI.Click job & pipelines and then ETL pipeline to access declarative pipeline editior
- 1 kudos
- 641 Views
- 1 replies
- 1 kudos
Resolved! Unable to see the Assistant suggested code and current code side by side
Hi,I'm unable to see the Assistant suggested code and current code side by side. Previously I'm able to see the my code and Assistant suggested code side by side which helped me to understand the changes. Please suggest if there is any ways for it. T...
- 641 Views
- 1 replies
- 1 kudos
- 1 kudos
@DE5 Some recent updates moved comparison features into the SQL Editor side panel or rely on “Cell Actions,” where you can generate code or format it and then see differences before applying changeshttps://www.databricks.com/blog/introducing-new-sql-...
- 1 kudos
- 3078 Views
- 7 replies
- 6 kudos
Reading empty json file in serverless gives error
I ran a databricks notebook to do incremental loads from files in raw layer to bronze layer tables. Today, I encountered a case where the delta file was empty. I tried running it manually on the serverless compute and encountered an error.df = spark....
- 3078 Views
- 7 replies
- 6 kudos
- 6 kudos
Hello @Dhruv-22 , Can you share the schema of the df? Do you have a _corrupt_record column in your dataframe? If yes.. where are you getting it from, because you said its an empty file correct?As per the design ,Spark blocks queries that only referen...
- 6 kudos
- 2400 Views
- 3 replies
- 2 kudos
Resolved! Lakehouse Federation - fetch size parameter for optimization
Hi,We use lakehouse federation to connect to a database.A performance recommendation is to use 'fetchSize':Lakehouse Federation performance recommendations - Azure Databricks | Microsoft Learn SELECT * FROM mySqlCatalog.schema.table WITH ('fetchSiz...
- 2400 Views
- 3 replies
- 2 kudos
- 2 kudos
Hello @dbdev , I did some digging and here are some suggestions. The `fetchSize` parameter in Lakehouse Federation is currently only available through SQL syntax using the `WITH` clause, as documented in the performance recommendations. Unfortunately...
- 2 kudos
- 2365 Views
- 2 replies
- 3 kudos
Resolved! Databricks Bundle Validation Error After CLI Upgrade (0.274.0 → 0.276.0)
After upgrading the Databricks CLI from version 0.274.0 to 0.276.0, bundle validation is failing with an error indicating that my configuration is formatted for "open-source Spark Declarative Pipelines" while the CLI now only supports "Lakeflow Decla...
- 2365 Views
- 2 replies
- 3 kudos
- 3 kudos
Hi @databricksero ,It's a bug. I've checked and the PR fixing this bug is already merged to main branch. Check below github thread and then once they build new release just update databricks CLI (soon they should release version without bug). Fix oss...
- 3 kudos
- 516 Views
- 1 replies
- 0 kudos
Search result shows presence of a text in notebook, but its not present in notebook
Search result shows presence of a text in notebook, but its not present in notebook
- 516 Views
- 1 replies
- 0 kudos
- 0 kudos
Ah yes a classic. The search also looks into hidden/collapsed content which is not visible.F.e. results or metadata.
- 0 kudos
- 3082 Views
- 2 replies
- 0 kudos
Resolved! Migrating SQL Server Tables and Views to Databricks using Lakebridge
We have a requirement to carry out migration of few 100 tables which are present in SQL Server to Databricks Delta Table. We intend to explore Lakebridge capability for carrying out a PoC for this. We also want to migrate few historic records say las...
- 3082 Views
- 2 replies
- 0 kudos
- 0 kudos
Migrating several hundred SQL Server tables to Databricks Delta Lake, using Lakebridge for a Proof of Concept (PoC), can be approached with custom pipelines—especially for filtering by a date/time column to migrate only the last two years of data. Of...
- 0 kudos
- 2167 Views
- 1 replies
- 1 kudos
Resolved! DLT or DP: How to do full refresh of Delta table from DLT Pipeline to consider all records from Tbl
RequirementI have a Kafka streaming pipeline that ingests Pixels data. For each incoming record, I need to validate the Pixels key against an existing Delta table (pixel_tracking_data), which contains over 2 billion records accumulated over the past ...
- 2167 Views
- 1 replies
- 1 kudos
- 1 kudos
Matching streaming data in real time against a massive, fast-changing Delta table requires careful architectural choices. In your case, latency is high for the most recent records, and the solution only matches against data ≥10 minutes old. This is a...
- 1 kudos
- 2961 Views
- 10 replies
- 0 kudos
Rasterio on shared/standard cluster has no access to proj.db
We try to use rasterio on a Databricks shared/standard cluster with DBR 17.1. Rasterio is directly installed on the cluster as library. Code:import rasterio rasterio.show_versions()Output: rasterio info:rasterio: 1.4.3GDAL: 3.9.3PROJ: 9.4.1GEOS: 3.11...
- 2961 Views
- 10 replies
- 0 kudos
- 0 kudos
Current Workaround:If you select the "Photon" engine on a Standard/Shared Cluster, they change the access rights of /databricks/native/proj-data and rasterio works fine.The downside:Pay for "Photon" compute to use a Python library, which do not use S...
- 0 kudos
- 939 Views
- 2 replies
- 2 kudos
Resolved! DABs with multi github sources
I want to deploy a dabs that has dev using a github branch and prod using a github release tag. I can't seem to find a way to make this part dynamic based on the target. Things I've tried:- Setting the git varaible in the databricks.yml- making the g...
- 939 Views
- 2 replies
- 2 kudos
- 2 kudos
I ended up finding this discussion which mostly ended up working. What was not mentioned is the first resources block should be in the job.yml and the overwrite parameters mentioned below are in the databricks.yml. You cannot put both in the databric...
- 2 kudos
- 7119 Views
- 5 replies
- 4 kudos
Asset Bundles cannot run job with single node job cluster
Hello community,we are deploying a job using asset bundles and the job should run on a single node job cluster. Here is the DAB job definition:resources: jobs: example_job: name: example_job tasks: - task_key: main_task ...
- 7119 Views
- 5 replies
- 4 kudos
- 4 kudos
In case this is now breaking for anyone (as it is for me), there's an update here to follow along with on how to define single node compute!https://github.com/databricks/databricks-sdk-py/issues/881
- 4 kudos
- 75028 Views
- 21 replies
- 9 kudos
Resolved! Is it possible to get Job Run ID of notebook run by dbutils.notbook.run?
When running a notebook using dbutils.notebook.run from a master-notebook, an url to that running notebook is printed, i.e.: Notebook job #223150 Notebook job #223151 Are there any ways to capture that Job Run ID (#223150 or #223151)? We have 50 or ...
- 75028 Views
- 21 replies
- 9 kudos
- 9 kudos
Thanks for the response @Manoj5 - I had to use this "safeToJson()" option too because all of the previous suggestions in this thread were erroring out for me with a message like "py4j.security.Py4JSecurityException: Method public java.lang.String com...
- 9 kudos
- 4600 Views
- 2 replies
- 2 kudos
Resolved! Column comments in DLT python notebook
The SQL API specification in the DLT docs shows an option for adding column comments when creating a table. Is there an equivalent way to do this when creating a DLT pipeline with a python notebook? The Python API specification in the DLT docs does n...
- 4600 Views
- 2 replies
- 2 kudos
- 2 kudos
this works in a readStream writeStream scenario for us, but the exact same code fails when put in a DLT
- 2 kudos
- 1592 Views
- 1 replies
- 2 kudos
Resolved! How to Stop Driver Node from Overloading When Using ThreadPoolExecutor in Databricks
Hi everyone,I'm using a ThreadPoolExecutor in Databricks to run multiple notebooks at the same time. The problem is that it seems like all the processing happens on the driver node, while the executor nodes are idle. This causes the driver to run out...
- 1592 Views
- 1 replies
- 2 kudos
- 2 kudos
Greetings @alex307 and thank you for sending your question. When using ThreadPoolExecutor to run multiple notebooks concurrently in Databricks, the workload is being executed on the driver node rather than distributed across Spark executors. This res...
- 2 kudos
- 1094 Views
- 2 replies
- 0 kudos
Scaling Declarative Streaming Pipelines for CDC from On-Prem Database to Lakehouse
We have a scenario where we need to mirror thousands of tables from on-premises Db2 databases to an Azure Lakehouse. The goal is to create mirror Delta tables in the Lakehouse.Since LakeFlow Connect currently does not support direct mirroring from on...
- 1094 Views
- 2 replies
- 0 kudos
- 0 kudos
Yes, a databricks labs project seems perfect for your scenario. https://databrickslabs.github.io/dlt-meta/index.html
- 0 kudos
| User | Count |
|---|---|
| 1645 | |
| 793 | |
| 584 | |
| 349 | |
| 287 |
