- 5651 Views
- 3 replies
- 4 kudos
Resolved! Best Practices for Managing ACLs on Jobs and Job Clusters in Databricks
Hi all,I’m setting up access control for Databricks jobs and have two questions:Ephemeral Job Clusters: Since job clusters are created at runtime, is it best practice to set ACLs on the job itself? The /api/2.0/permissions/clusters/{cluster_id} endp...
- 5651 Views
- 3 replies
- 4 kudos
- 7937 Views
- 9 replies
- 0 kudos
Proposal: Switch to Zstd Compression for Parquet to Reduce S3 Costs
We are thinking to change the Spark configuration for Parquet files to use zstd compression.Configuration: spark.sql.parquet.compression.codec = zstdThis will only affect new data written by our Spark jobs. All existing data will remain compressed wi...
- 7937 Views
- 9 replies
- 0 kudos
- 0 kudos
Yes my believe is it should support 7.3 LTS as well, we will prove it with thorough testingThanks for the discussion. Cheers
- 0 kudos
- 1606 Views
- 3 replies
- 3 kudos
Resolved! from pyspark.ml.stat import KolmogorovSmirnovTest is not working on Serverless compute.
Hi everyone,I am trying to run a Kolmogorov–Smirnov (KS) test on a Spark DataFrame column in Databricks using the built-in pyspark.ml.stat.KolmogorovSmirnovTest. The goal is to apply the KS test directly on Spark DataFrame data without converting it...
- 1606 Views
- 3 replies
- 3 kudos
- 3 kudos
Hi @parthesh24 ,It looks more like KolmogorovSmirnovTest module under the hood is trying to access SparkContext which is not supported in serverless. You can check it yourself by trying to use sparkContext in serverless
- 3 kudos
- 2504 Views
- 1 replies
- 1 kudos
Dashboard tagging
How can i tag dashbaord? i do not see any place to add tagging to it?
- 2504 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi @pinikrisher ,Unforutnately, you can't. Tagging is currently supported on catalogs, schemas, tables, table columns, volumes, views, registered models, and model version
- 1 kudos
- 2246 Views
- 6 replies
- 2 kudos
databricks dashboard deployment error
Hi, i am trying to deploy a dashboard using a bundle and github action. but i am getting an error on CI even though the dashboard is deployed. im using the latest version of CLI from https://raw.githubusercontent.com/databricks/setup-cli/main/install...
- 2246 Views
- 6 replies
- 2 kudos
- 2 kudos
@szymon_dybczak ,@nayan_wylde , I checked the permissions and the SP has 'can manage' access on the folder.
- 2 kudos
- 1564 Views
- 2 replies
- 2 kudos
Resolved! Lakehouse monitoring dashboard shows no data
Hello, I am replicating the demo for Lakehouse monitoring found here: https://notebooks.databricks.com/demos/lakehouse-monitoring/index.htmlFor some reason, my dashboards show empty, i.e., they say 'no data' - like nothing fits the criteria from the ...
- 1564 Views
- 2 replies
- 2 kudos
- 2 kudos
Hello @heli123 Can you share the image again? looks like didnt upload well.
- 2 kudos
- 2839 Views
- 3 replies
- 3 kudos
Databricks model serving endpoint returns 403 Unauthorized access to workspace when using service
I deployed a simple Iris model in Databricks Model Serving and exposed it as an endpoint. I’m trying to query the endpoint using a service principal. I can successfully fetch the access token with the following databricks_token() function:def databri...
- 2839 Views
- 3 replies
- 3 kudos
- 3 kudos
Hi @szymon_dybczak, Thanks for your comment.One of the admins in this workspace tried using the token generated via client id and secret, and were able to successfully get a response from the serving endpoint using this same above mentioned code.Coul...
- 3 kudos
- 1275 Views
- 2 replies
- 0 kudos
How to switch serverless dlt pipeline to cost optimized mode from performance optimized
We have a few serverless dlt pipelines that we want to optimize for cost as we are ok with an increased latency. Where can I change the pipeline to run on cost optimized mode. I dont see this option in UI or API
- 1275 Views
- 2 replies
- 0 kudos
- 0 kudos
Hello!To enable cost-optimized mode for your serverless DLT pipeline, switch it to Triggered mode and edit the schedule trigger—there you’ll find the option to disable “Performance optimized.” This setting isn’t visible in the main UI or API unless t...
- 0 kudos
- 44786 Views
- 13 replies
- 6 kudos
SQL Stored Procedure in Databricks
Hello. Is there an equivalent of SQL stored procedure in Databricks? Please note that I need a procedure that allows DML statements and not only Select statement as a function provides.Thank you in advance
- 44786 Views
- 13 replies
- 6 kudos
- 6 kudos
how to connect the stored procedures to power bi report builder, seems like it is not working
- 6 kudos
- 1637 Views
- 3 replies
- 0 kudos
Convert a Managed Table to Streaming Table
HiI have applied transformations on a set of streaming tables and saved it as a managed table....How can i change the Managed table to a Streaming table with minimal changesRegardsZD
- 1637 Views
- 3 replies
- 0 kudos
- 0 kudos
I am just writing the dataframe to delta table.....Are you suggesting me to first define a STREAMING TABLE (using the DLT definition) and then save the dataframe into that table?
- 0 kudos
- 3409 Views
- 4 replies
- 2 kudos
Databricks app with parameters from databricks asset bundle
HelloooI tried out setting up a Databricks App using asset bundle, where i was able to successfully parameterize the sql warehouse id which was specified on specific targets. However i was unable to get values of other variables from the targets, the...
- 3409 Views
- 4 replies
- 2 kudos
- 2 kudos
Found that this is an implementation in progress on the Databricks CLI. https://github.com/databricks/cli/issues/3679
- 2 kudos
- 2516 Views
- 2 replies
- 3 kudos
Resolved! handling both Pyspark and Python exceptions
In a Python notebook, I am using error handling according to the official documentation. try:[some data transformation steps]except PySparkException as ex:[logging steps to log the error condition and error message in a table]However, this catches o...
- 2516 Views
- 2 replies
- 3 kudos
- 3 kudos
To handle both PySpark exceptions and general Python exceptions without double-logging or overwriting error details, the recommended approach is to use multiple except clauses that distinguish the exception type clearly. In Python, exception handlers...
- 3 kudos
- 2968 Views
- 5 replies
- 1 kudos
Resolved! BUG in Job Task of Type DBT
Hi, just wanted to let the Databricks Team know, that there is a bug in the task ui.Currently it is not possible to save a task of "Type: dbt" if the "SQL Warehouse" is set to "None (Manual)".Some weeks ago this was possible, also the "Profiles Direc...
- 2968 Views
- 5 replies
- 1 kudos
- 1 kudos
I am facing this bug still. I don't want to select any SQL warehouse, what do I do? and from where can I pass the profiles directory
- 1 kudos
- 1197 Views
- 3 replies
- 1 kudos
Resolved! I recently made new account on databricks under Free edition
It by default made SQL warehouse compute, but I want all-purpose compute, as I want test and learn capabilities of PySpark and Databricks.I can't connect with the serverless compute in the notebook; it gives a mean error as follows: "An error occurr...
- 1197 Views
- 3 replies
- 1 kudos
- 1 kudos
In the free Databricks edition, to use PySpark you need to create and start a cluster, since the SQL Warehouse is only for SQL queries; go to Compute > Create Cluster, set up a free cluster, click Start, and then attach your notebook to it this will ...
- 1 kudos
- 3084 Views
- 2 replies
- 1 kudos
Unable to access metrics from Driver node on localhost:4040
Greetings,I am trying to setup monitoring in Grafana for all my databricks clustersI have added 2 things as part of thisUnder Compute > Configuration > Advanced > Spark > Spark Config, I have addedspark.ui.prometheus.enabled trueUnder init_scripts, I...
- 3084 Views
- 2 replies
- 1 kudos
- 1 kudos
Hi @vishal_balaji ,You're following guides that were prepared for OSS Apache Spark. For sure localhost won't work in this case because in Databricks all compute is cloud-based. Please follow below guide how to configure it properly on databricks:Data...
- 1 kudos
| User | Count |
|---|---|
| 1645 | |
| 793 | |
| 584 | |
| 349 | |
| 287 |
