Databricks Community

Akshay_Petkar

In a Databricks AI/BI dashboard, I have a field with multiple categories (e.g., district-wise sales with 50 districts). How can I display only the top few categories (like the top 10) based on a specific metric such as sales?

Akshay_Petkar

I have created a legacy dashboard in Databricks and I'm trying to grant "Can Manage" access to my colleague. However, when I use Run as Owner credentials I am only able to provide "Can View" access. If I switch to Run as Viewer credentials, I can ass...

Akshay_Petkar

I am preparing to migrate from EMR to Databricks and would like to know the best practices for this process. Is there a direct connector, such as a JDBC connector, available to facilitate the migration? Alternatively, would it be more effective to ex...

Akshay_Petkar · 09-16-2024

I have to migrate the data from Azure Synapse Analytics to Databricks. Could anyone share the different approaches to migrate data, and from those, which is the best approach to use?

Akshay_Petkar · 08-22-2024

I'm planning to connect SQL Server Management Studio (SSMS) with Databricks using Lakehouse Federation. I understand that there are some differences in the SQL dialects between SSMS and Databricks SQL. For instance, in SSMS, we use TOP 10 to limit th...

Akshay_Petkar

Got the solution.

Akshay_Petkar

Hi @Subash Go to Settings, then navigate to the Advanced tab. Under the Other section, you'll find the second option to enable the DBFS File Browser.

Akshay_Petkar

Hello @Mo I am creating a AI/BI dashboard where I need to add multiple charts, each showing the top 10 values. For example, I used a query like select * from table and in the canvas, I added a chart with 50 unique values, but I want to display only t...

Akshay_Petkar

Hi @TamD A materialized view looks for a permanent table. In your case, since the temporary view used to load the data is deleted after the session expires, the materialized view cannot find it when the session ends. For example, if you create a mate...

Akshay_Petkar

Hi @TamD You cannot create a materialized view on a temporary view because temporary views are session-based. Once the session expires, the temporary view will be dropped. To resolve this, you need to create either a regular view or a table, and then...

Databricks Community

User Stats

User Activity

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

Unable to Assign "Can Manage" Access on Legacy Dashboard in Databricks

Best Approach for Migrating from EMR to Databricks

Migrate Azure Synapse Analytics data to Databricks

SQL Differences When Using SSMS with Databricks Lakehouse Federation

Re: Unable to Assign "Can Manage" Access on Legacy Dashboard in Databricks

Re: DBFS File browser option is not visible in Databricks Community Edition

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

Re: SELECT from VIEW to CREATE a table or view

Re: SELECT from VIEW to CREATE a table or view