- 602 Views
- 1 replies
- 1 kudos
Resolved! Issue with Lakebridge transpile installation – SSL Certificate Error
Hi Team,I am trying to use Lakebridge to test a small piece of code for conversion. The base installation of Lakebridge worked fine, but when I attempt to install transpile, I encounter SSL-related errors. I even tried to hardcode of the certificates...
- 602 Views
- 1 replies
- 1 kudos
- 1 kudos
The error indicates that while installing Lakebridge's transpile component on Databricks with Python 3.13, SSL certificate verification fails due to a "Missing Authority Key Identifier" in the certificate chain. This is a result of stricter requireme...
- 1 kudos
- 465 Views
- 3 replies
- 2 kudos
Resolved! Inconsistent behavior of LakeBridge transpiler for similar scripts
Hi Everyone,I am testing the LakeBridge prototype and noticed inconsistent behavior when converting stored procedures.For simple scripts, the conversion is correct.But for medium/complex scripts, especially those with multiple LEFT JOINs and column e...
- 465 Views
- 3 replies
- 2 kudos
- 2 kudos
Is there a way to standardize/optimize the conversion so it doesn’t blow up into thousands of lines? Yes, there are actionable methods to standardize and optimize LakeBridge conversions to prevent code from ballooning into thousands of lines, but t...
- 2 kudos
- 326 Views
- 1 replies
- 2 kudos
Resolved! Vacuuming clones in USER_ISOLATION mode and ThreadPool Executor
Hello,I run my process on a shared, interactive cluster (data security mode: USER_ISOLATION).I run operations on multiple tables having each of them as a separate thread, pseudo-code :try: truncate target_tablevacuum target_table (retain 0 hours with...
- 326 Views
- 1 replies
- 2 kudos
- 2 kudos
This is most likely a bug. It certainly is unexpected and should be reported to Databricks support or your platform administrator for clarification and remediation. As a temporary workaround, running vacuum commands outside of threaded contexts or s...
- 2 kudos
- 3824 Views
- 5 replies
- 0 kudos
Delta Live tables stream output to Kafka
Hello,Wanted to Know if we can write the stream output to a Kafka topic in DLT pipeline?Please let me know.Thankyou.
- 3824 Views
- 5 replies
- 0 kudos
- 0 kudos
Hi ! Ensure your code is set up to use these libraries. Here is the complete example: Navigate to your cluster configuration:Go to your Databricks workspace.Click on "Clusters" and select your cluster.Go to the "Libraries" tab. Install the necessar...
- 0 kudos
- 430 Views
- 5 replies
- 0 kudos
Databricks bundle repository permission
Hi everyone,How can I use Databricks Asset Bundle configuration to set permissions on the workspace folder (root_path) where my code is deployed, in order to protect it from manual changes by users?My current bundle config for production looks like t...
- 430 Views
- 5 replies
- 0 kudos
- 0 kudos
Hi @HoussemBL ,In Databricks there is a users group to which by deafult all the workspace users belong (in UI displayed All workspace users). That group has default permission that cannot be revoked at the top-level Shared folder. So, any new folder ...
- 0 kudos
- 20797 Views
- 25 replies
- 28 kudos
Installing Databricks Connect breaks pyspark local cluster mode
Hi, It seems that when databricks-connect is installed, pyspark is at the same time modified so that it will not anymore work with local master node. This has been especially useful in testing, when unit tests for spark-related code without any remot...
- 20797 Views
- 25 replies
- 28 kudos
- 28 kudos
Hi Utu,try doing something like this , wrap import within a fixture itself.import osimport pytestfrom pyspark.sql import SparkSession_local_test = True@pytest.fixture(scope='session')def spark(): if 'DATABRICKS_RUNTIME_VERSION' in os.environ: ...
- 28 kudos
- 1267 Views
- 6 replies
- 7 kudos
Resolved! Retrieving Last Data and Metadata Refresh DateTimes of table in Databricks
Hi, I had a query regarding how to accurately retrieve the last data refresh datetime and last metadata refresh datetime for tables in Databricks. Currently, the only reliable approach I am aware of is using the DESCRIBE HISTORY command with filters ...
- 1267 Views
- 6 replies
- 7 kudos
- 343 Views
- 1 replies
- 2 kudos
inconsistency between the analyze and transpile commands with respect to SSIS support.
Hi Team,I'm using Databricks Labs LakeBridge and noticed an inconsistency between the analyze and transpile commands with respect to SSIS support.Analyzer:When I run the analyze command, I’m able to select SSIS as the source technology, and the tool ...
- 343 Views
- 1 replies
- 2 kudos
- 2 kudos
Hi Gauri,As I can read but someone from databricks can also confirm: as of now, SSIS is not supported as a source dialect for the transpile command in Databricks Labs LakeBridge. The analyze command supports SSIS for assessment and reporting, but the...
- 2 kudos
- 1293 Views
- 5 replies
- 3 kudos
Resolved! Unable to use Auto Loader for External Location in Community Edition
Using Community EditionI'm trying to create a pipeline(streaming) using auto loader (accessing external location) and each time my select query is thrown this error- " An error occurred while calling t.analyzeAndFormatResult. : java.lang.UnsupportedO...
- 1293 Views
- 5 replies
- 3 kudos
- 3 kudos
Hi @AanchalSoni ,To make it clear - are you using Free Edition or Community Edition? Because people confuses them all the time so it's better to clarify this first.
- 3 kudos
- 848 Views
- 8 replies
- 1 kudos
Error with AutoLoader pipeline ingesting from external location: LOCATION_OVERLAP
Hello,I am trying to use pipelines in Databricks to ingest data from an external location to the datalake using AutoLoader, and I am facing this issue. I have noticed other posts with similar errors, but in those posts, the error was related to the d...
- 848 Views
- 8 replies
- 1 kudos
- 1 kudos
also try doing this :csv_file_path = "abfss://storage-dm-int-container@devdomaindmdbxint01.dfs.core.windows.net/raw_data/dummy.csv" add another folder for file
- 1 kudos
- 259 Views
- 1 replies
- 1 kudos
Resolved! PipelineSpec object does not seem to show event_log when defining a pipeline with DAB
Hi all, I am looking for help on a very specific subject.I am trying to access the event_log property (EventLogSpec) of an object from PipelineSpec that I get by running a query on the Workspace Client, which is part of the Databricks Python sdk:w.pi...
- 259 Views
- 1 replies
- 1 kudos
- 1 kudos
hi @RikL Thank you for reaching out. It doesn't seem you are doing anything wrong. Per the documentation, indeed, the event_log spec should be retrieved when you run the pipeline.get, then the spec. I was able to test and confirm the correct behavio...
- 1 kudos
- 458 Views
- 1 replies
- 1 kudos
Custom stream-stream join using transformWithState - expanded example
Hi all,Just wondering if anyone has more information / an expanded example of the "Custom stream-stream join using transformWithState" example on Stateful applications page: Example stateful applications | Databricks on AWSI'm looking to implement so...
- 458 Views
- 1 replies
- 1 kudos
- 1 kudos
Hello @alexbush-mas Good day!! Unioning the streams is the standard method for feeding multiple input streams into a single transformWithStateInPandas operation for custom stream-stream joins, so your intuition is correct. After grouping the input by...
- 1 kudos
- 2358 Views
- 3 replies
- 4 kudos
Resolved! Permission denied on schema evolution view
Hey Databricks community,We are registering views in Databricks with schema evolution, however these views fail when a user (other than the owner) is the first to query the view after the schema change.PERMISSION_DENIED: User is not an owner of Table...
- 2358 Views
- 3 replies
- 4 kudos
- 4 kudos
Hi @Sinkrad, There is an internal case about this: ES-1260035, and a fix is going to be out for this quarter. The behavior where only the view owner can update the view definition after a schema change is not intended. It is expected that the view sh...
- 4 kudos
- 666 Views
- 7 replies
- 5 kudos
Resolved! Issue in renaming the table
We have tried to rename a tableEx: alter rename tablea to tablebwhile we checked the table b properties we are seeing the tableb location is being pointed to tablea location.
- 666 Views
- 7 replies
- 5 kudos
- 5 kudos
Hello @Rajasaiharish , The above is expected by design.ALTER TABLE RENAME TO updates only the table name in the catalog.The underlying Delta log + data files remain in the original storage location Try setting the location to a new location ALTER ...
- 5 kudos
- 551 Views
- 3 replies
- 3 kudos
Job Owner Changes in Asset Bundle
When I deploy a fresh job, I'm set as owner, which makes sense because I'm creating it.Then at some point, the owner switches to a service principal. This is strange. I believe it happens when a scheduled job triggers.Can job owners change?
- 551 Views
- 3 replies
- 3 kudos
- 3 kudos
Hi @T0M, how are you doing?You’re right about the statuses at the level above the job; however, my reference to IS_OWNER comes from the job-level statuses, as shown below:IS_OWNER exists and is valid for resource-level permissions (e.g., inside resou...
- 3 kudos
| User | Count |
|---|---|
| 1616 | |
| 790 | |
| 468 | |
| 349 | |
| 287 |
