- 2836 Views
- 2 replies
- 0 kudos
AWS NAT (Network Address Translation) Automated On-demand Destruct / Create
Hi folks, Our company typically uses Databrick during a 12 hour block, however the AWS NAT for elastic compute is up 24 hours, and I'd rather not pay for those hours.I gather AWS lambda and cloudwatch can be used to schedule / trigger NAT destruction...
- 2836 Views
- 2 replies
- 0 kudos
- 0 kudos
For interest, this is how I ended up solving the situation, with pointers from AWS support:<< CREATE NAT >>import boto3 import logging from datetime import datetime ec2 = boto3.client('ec2') cloudwatch = boto3.client('logs') def lambda_handler(even...
- 0 kudos
- 2715 Views
- 2 replies
- 1 kudos
How to update num_workers dynamically in a job cluster
I am setting up a workflows with the UI. In the first task, a dynamic value for the next task's num_workers is calculated based on actual data size. In the subsequent task, I'd like to use this calculated num_workers to update the job cluster's defau...
- 2715 Views
- 2 replies
- 1 kudos
- 1845 Views
- 1 replies
- 1 kudos
Discrepancy in Record Count in DLT Pipeline Data Quality Tab
Hello,I have set up a DLT pipeline where I ingest data from a Kafka topic into a table. Then, I create another table that filters records from the first table. However, I'm facing an issue:When I check the Data Quality tab for the second table, it sh...
- 1845 Views
- 1 replies
- 1 kudos
- 10310 Views
- 3 replies
- 5 kudos
Resolved! Driver: Out of Memory
Hi everyone,I have a streaming job with 29 notebooks that runs continuously. Initially, I allocated 28 GB of memory to the driver, but the job failed with a "Driver Out of Memory" error after 4 hours of execution.To address this, I increased the driv...
- 10310 Views
- 3 replies
- 5 kudos
- 5 kudos
It looks like _source_cdc_time is the timestamp for when the CDC transaction occurred in your source system. This would be a good choice for a timestamp column for your watermark, since you would be deduping values according to the time the transacti...
- 5 kudos
- 15869 Views
- 1 replies
- 1 kudos
Delta table and AnalysisException: [PATH_NOT_FOUND] Path does not exist
I am performing some tests with delta tables. For each test, I write a delta table to Azure Blob Storage. Then I manually delete the delta table. After deleting the table and running my code again, I get this error: AnalysisException: [PATH_NOT_FOUN...
- 15869 Views
- 1 replies
- 1 kudos
- 1 kudos
yes it is weird , workaround for thisfiles = dbutils.fs.ls("s3 bucket or azure blob path")file_paths = [file.path for file in files]if target_path not in file_paths: dbutils.fs.mkdirs(target_path)
- 1 kudos
- 741406 Views
- 33 replies
- 5 kudos
GC Driver Error
I am using a cluster in databricks to connect to a Tableau workbook through the JDBC connector. My Tableau workbook has been unable to load due to resources not being available through the data connection. I went to look at the driver log for my clus...
- 741406 Views
- 33 replies
- 5 kudos
- 12860 Views
- 3 replies
- 7 kudos
Resolved! Efficient caching/persisting
To cache/persist an action needs to be triggered. I'm just wondering, will it make any difference if, after persisting some df, I use, for instance, take(5) instead of count()?Will it be a bit more effective, because of sending results from 5 partiti...
- 12860 Views
- 3 replies
- 7 kudos
- 7 kudos
Yes take (5) will be more efficient in some ways.When you cache or persist a DataFrame in Spark, you are instructing Spark to store the DataFrame's intermediate data in memory (or on disk, depending on the storage level). This can significantly speed...
- 7 kudos
- 2100 Views
- 2 replies
- 0 kudos
dbfs /mounts permissions with Clusters on Shared Mode / Serverless
Hi allI've used mounts based on service principals but users using shaed clusters or the new serverless they have problems with permissions to access resources on dbfs. Right now we have used clusters in single modeWhat should be the best approach to...
- 2100 Views
- 2 replies
- 0 kudos
- 3984 Views
- 0 replies
- 0 kudos
how to migrate features from azure databricks workspace to gcp
I’m in the process of migrating feature tables from Azure Databricks to GCP Databricks and am having trouble listing all feature tables from Azure Databricks.I’ve tried using the FeatureStoreClient API, but it doesn’t have a function to list all feat...
- 3984 Views
- 0 replies
- 0 kudos
- 8486 Views
- 6 replies
- 3 kudos
Resolved! Is Concurrent Writes from multiple databricks clusters to same delta table on S3 Supported?
Does databricks have support for writing to same Delta Table from multiple clusters concurrently. I am specifically interested to know if there is any solution for https://github.com/delta-io/delta/issues/41 implemented in databricks OR if you have a...
- 8486 Views
- 6 replies
- 3 kudos
- 3 kudos
Please note, the issue noted above [Storage System] Support for AWS S3 (multiple clusters/drivers/JVMs) is for Delta Lake OSS. As noted in this issue as well as Issue 324, as of this writing, S3 lacks putIfAbsent transactional consistency. For Del...
- 3 kudos
- 3834 Views
- 2 replies
- 1 kudos
Resolved! Ingesting logs from Databricks (GCP) to Azure log Analytics
Hi everyone, I wanted to ask if there is any way through which we can ingest logs from GCP databricks to azure log analytics in store-sync fashion. Meaning we will save logs into some cloud bucket lets say, then from there we should be able to send l...
- 3834 Views
- 2 replies
- 1 kudos
- 1 kudos
Hi @Retired_mod ,Thanks for help. We decided to develop our own library for logging to azure log analytics. We used buffer for this. We are currently on timer based logs but in future versions we wanted to move to memory based.Thanks,Nikhil
- 1 kudos
- 5184 Views
- 0 replies
- 1 kudos
Federated Learning for Decentralized, Secure Model Training
Federated learning allows you to train machine learning models on decentralized data while ensuring data privacy and security by storing data on local devices and only sharing model updates. This approach assures that raw data never leaves its source...
- 5184 Views
- 0 replies
- 1 kudos
- 3445 Views
- 3 replies
- 3 kudos
How to reliably get the databricks run time version as part of init scripts in aws/azure databricks
We currently use the script below, but it is not working in some environments.The environment variable used in the script is not listed in this link Databricks Environment Variables```bash#!/bin/bashecho "Databricks Runtime Version: $DATABRICKS_RUNTI...
- 3445 Views
- 3 replies
- 3 kudos
- 3 kudos
If environment variable doesn't work for you, then maybe try with REST API or databrick cli?
- 3 kudos
- 4234 Views
- 1 replies
- 0 kudos
Resolved! How exactly to create cluster policy via Databricks CLI ?
I tried these ways they are all not working: Save the json config into a JSON file locally and run databricks cluster-policies create --json cluster-policy.json Error message: Error: invalid character 'c' looking for beginning of valueSave the json ...
- 4234 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @guangyi ,Try to add @ before the name of json filedatabricks cluster-policies create --json @policy.json Also make sure that you're escaping quotation marks like they do in below documenation:Create a new policy | Cluster Policies API | REST API ...
- 0 kudos
- 1317 Views
- 0 replies
- 0 kudos
Streaming Kafka data without duplication
Hello,We are creating an application to read data from Kafka topic send by a source. After we get the data, we do some transformations and send to other Kafka topic. In this process source may send same data twice.Our questions are1. How can we contr...
- 1317 Views
- 0 replies
- 0 kudos
| User | Count |
|---|---|
| 1645 | |
| 793 | |
| 584 | |
| 349 | |
| 287 |
