Databricks Community

Akshay_Petkar

I recently tried applying Liquid Clustering to a partitioned table in Databricks and encountered the followingerror: [DELTA_ALTER_TABLE_CLUSTER_BY_ON_PARTITIONED_TABLE_NOT_ALLOWED] ALTER TABLE CLUSTER BY cannot be applied to a partitioned table. I u...

Akshay_Petkar

I have applied row-level security (RLS) on the department column in the table so that users can only see data related to their own department. The security policy works perfectly when I query the table in Databricks SQL.Now, I have built a Databricks...

Akshay_Petkar · 02-06-2025

Hi all,I have a table named employee in Databricks. I ran the following query to filter out rows where the salary is greater than 25000.This query returns 10 rows. I want to find the size of these 10 rows in bytes, and I would like to calculate or re...

Akshay_Petkar · 02-05-2025

I have created a Ai/Bi dashboard on Databricks and set it to refresh every 1 minute. However, the dashboard is not refreshing as expected. Interestingly, when I terminate the warehouse, it triggers the warehouse but still does not refresh per minute ...

Akshay_Petkar · 01-27-2025

What is the process for renewing a Databricks certification? How long is the certification valid, and do we need to retake the exam for renewal? Additionally, is there a cost associated with renewal, or is it free?

Akshay_Petkar · 02-11-2025

Hi @ss_data_eng ,When copying the host, make sure it is correct. The host will be in URL format, typically starting with https:// . When copying the host, make sure it is correct. You need to copy the username, password, and host while removing jdbc:...

Akshay_Petkar · 02-11-2025

Hello @TejeshS ,We cannot directly mask a view since we cannot alter it or add data to it. However, we can apply column masking at the view level using Databricks Dynamic Views. This allows us to control access to specific columns based on the user's...

Akshay_Petkar · 02-10-2025

Hi @Mo ,The parameter limits the rows from the dataset that we read in the query. For example, We create a city-wise sales chart at that time, it aggregates the values and performs a group by. This parameter will not perform on that. It will limit on...

Akshay_Petkar · 02-05-2025

Hi @Alberto_Umana ,I have followed the correct approach to create and schedule the dashboard for a 1-minute refresh, but it's not updating every minute as expected.I have attached images for your reference. Please take a look.

Akshay_Petkar · 11-12-2024

Hi @AlbertWang You have multiple options to connect Power BI with Databricks:Using Cluster Credentials: Under the cluster details, go to the Advanced Options and select JDBC/ODBC. Here, you’ll find the necessary credentials, such as hostname and HTTP...

Databricks Community

User Stats

User Activity

Issue with Liquid Clustering on Partitioned Table in Databricks

Row-Level Security Not Working in Published Databricks AI/BI Dashboard

How to get the size of selected rows in bytes using a single SQL query?

Databricks Dashboard Not Refreshing as per Schedule (Per Minute)

Process and Cost for Renewing Databricks Certification

Re: Using Lakehouse Federation for SQL Server with Serverless Compute

Re: How to apply Column masking and RLS on Views in Databricks

Re: How to Display Top Categories in Databricks AI/BI Dashboard?

Re: Databricks Dashboard Not Refreshing as per Schedule (Per Minute)

Re: What is the best practice for connecting Power BI to Azure Databricks?