cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

MadelynM
by • Databricks Employee
  • 4435 Views
  • 0 replies
  • 0 kudos

[Recap] Data + AI Summit 2024 - Warehousing & Analytics | Improve performance and increase insights

Here's your Data + AI Summit 2024 - Warehousing & Analytics recap as you use intelligent data warehousing to improve performance and increase your organization’s productivity with analytics, dashboards and insights.  Keynote: Data Warehouse presente...

Screenshot 2024-07-03 at 10.15.26 AM.png
Warehousing & Analytics
AI BI Dashboards
AI BI Genie
Databricks SQL
  • 4435 Views
  • 0 replies
  • 0 kudos
JstelaBR
by • Databricks Partner
  • 1432 Views
  • 0 replies
  • 1 kudos

Databricks Free Edition + $100M in Skills: why this matters

Databricks launching a Free Edition and committing $100M to data + AI education isn’t just about free access — it’s about changing how people learn data engineering.When engineers learn on a unified platform, not a stitched-together toolchain, they s...

  • 1432 Views
  • 0 replies
  • 1 kudos
Ties
by • New Contributor II
  • 2399 Views
  • 5 replies
  • 1 kudos

Resolved! Query does finish on serverless but will not on classic

Dear community,We are running nightly businessvaults. Last year it stopped to finish on classic wh and after testing until completion when switching to serverless wh it stayed that way but costs have increased a lot. I have been testing numerous spar...

Ties_0-1767884888474.png
  • 2399 Views
  • 5 replies
  • 1 kudos
Latest Reply
Ties
New Contributor II
  • 1 kudos

I saw that in this topic a reply was selected as a solution. Sadly this is not the case and we are still in limbo with this issue. I tried setting up a meeting through support for databricks on azure but the third party rep microsoft provided did not...

  • 1 kudos
4 More Replies
data-wrangler
by • New Contributor II
  • 4106 Views
  • 4 replies
  • 0 kudos

Foreign Catalog with BigQuery connects, but appears empty, and queries fail

Hi -- I'm trying to connect to BigQuery as a foreign catalog. I'm able to create and successfully test the connection, but when I create a foreign catalog it appears empty, and queries against that catalog return a "TABLE_OR_VIEW_NOT_FOUND" error.The...

  • 4106 Views
  • 4 replies
  • 0 kudos
Latest Reply
lorenz_singer
New Contributor II
  • 0 kudos

Hello, I had the same problem (foreign catalog for BigQuery project with limited access) and was able to solve it with the SQL command "REFRESH FOREIGN CATALOG catalog_name". It took a while, but after it finished with "OK", all BigQuery tables could...

  • 0 kudos
3 More Replies
cristianc
by • Contributor
  • 3985 Views
  • 3 replies
  • 1 kudos

How does the refresh work for AI/BI (formerly LakeView Dashboards)

Greetings,I'm writing this message because I want to understand how does the "automatic refresh" feature work for AI/BI dashboards that use SQL Serverless endpoints?I'm asking because sometimes the published dashboard refreshes when viewing the link ...

  • 3985 Views
  • 3 replies
  • 1 kudos
Latest Reply
gyorgyjelinek
New Contributor III
  • 1 kudos

I have the same impression. But I guess besides the parameters time related functions (or any?) included in the source SQL must trigger the refresh. Can this behaviour be switched off somehow? Using a cached version?

  • 1 kudos
2 More Replies
hobrob_ex
by • New Contributor III
  • 1746 Views
  • 2 replies
  • 1 kudos

Resolved! Anchor links in notebook markdown

Does anyone know if there is a way to get anchor links working in Databricks notebooks so you can jump to sections in the same book without a full page refresh? i.e. something that works like the following html:<a href="#jump_to_target">Jump</a>...<p...

  • 1746 Views
  • 2 replies
  • 1 kudos
Latest Reply
iyashk-DB
Databricks Employee
  • 1 kudos

@hobrob_ex , yes, this is possible, but not like the HTML way; instead, you will have to use the markdown rendering formats. Add #Heading 1, #Heading 2.. so on in the (+Text) button of the notebook. Once these headings/ sections that you want are con...

  • 1 kudos
1 More Replies
Stanciu_Cristi
by • New Contributor III
  • 1971 Views
  • 2 replies
  • 3 kudos

Resolved! Dynamic Global Filters

Hi everyone, I hope you're all doing well! I'm currently working on an AI/BI dashboard designed for business users, where the goal is for users to simply view and interact with the data in the dashboard. I've asked this question before to the Agent a...

  • 1971 Views
  • 2 replies
  • 3 kudos
Latest Reply
davidmorton
Databricks Employee
  • 3 kudos

Ultimately, your ask is essentially what happens when you're creating a new dashboard and you select some filter fields from the right side. The challenge here, however, is that you want this to be available to the user, and not simply at creation ti...

  • 3 kudos
1 More Replies
_its_akshaye
by • New Contributor II
  • 1217 Views
  • 1 replies
  • 0 kudos

Resolved! Create Cascading Dropdown in Dashboard

I am creating a dashboard, and I am looking to implement the scenario below.How do I create a cascading dropdown where selecting one field filters the available values in another dropdown?In a dropdown, how do I show a description for each option for...

  • 1217 Views
  • 1 replies
  • 0 kudos
Latest Reply
pradeep_singh
Honored Contributor III
  • 0 kudos

Create a dataset that returns the “parent” values . Add filter A and connect it to that dataset field. Create a dataset for “child” values whose query is parameterized by the parent selection, or simply filters on the parent field: Configure the filt...

  • 0 kudos
satyambaranwalc
by • New Contributor II
  • 1093 Views
  • 1 replies
  • 1 kudos

Resolved! how to create a workspace with community edition?

how to create a workspace with community edition?workspace is not being created after login to community edition.

  • 1093 Views
  • 1 replies
  • 1 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 1 kudos

Hey @satyambaranwalc , Communithy Edition has been depricated.  You want to use the NEW and IMPROVED Free Edition.  You can sign up here: https://www.databricks.com/learn/free-edition Hope this helps, Louis.

  • 1 kudos
danilo_amorim
by • New Contributor
  • 4984 Views
  • 2 replies
  • 0 kudos

Unable to connect to databricks with ODBC connection on a Mac

Hi all!Need help configuring ODBC connection on a Mac. I'm receiving the error "The web server failed to start, please verify if  port 8020 is being used by another connection or annother application".I've downloaded and installed Databricks ODBC con...

danilo_amorim_0-1742470647673.png
  • 4984 Views
  • 2 replies
  • 0 kudos
Latest Reply
Allex_Sanus
New Contributor II
  • 0 kudos

Could you please provide the macOS ODBC driver? I’ve been trying to download it from the official website, but the download links are not working.

  • 0 kudos
1 More Replies
Leif
by • New Contributor II
  • 1424 Views
  • 4 replies
  • 0 kudos

RLS

Hi,I have created a function that I have applied as a row filter function to multiple tables.The function takes one input parameter (a column value from the table). It then uses session_user() to look up a user in our users table. If the user is foun...

  • 1424 Views
  • 4 replies
  • 0 kudos
Latest Reply
Leif
New Contributor II
  • 0 kudos

Hi! Sorry for the late reply, lots of holidays No, the user table does not have a row filter in it. The structure is like this:schema1.users: contains a list of users obviously, and it has a column with a customer id for the customer they are allowed...

  • 0 kudos
3 More Replies
jasmin_mbi
by • New Contributor II
  • 1091 Views
  • 2 replies
  • 1 kudos

Impossible to create classic warehouse

Hello,we have already spent surprisingly many DBUs, although we have only uploaded a few tiny tables (9 Tables with approx. 10 lines).We had the idea to change the warehouse from serverless starter warehouse to classic 2x small in order to save DBUs....

  • 1091 Views
  • 2 replies
  • 1 kudos
Latest Reply
Advika
Community Manager
  • 1 kudos

Hello @jasmin_mbi! Did the suggestion shared above help resolve the issue with creating a classic SQL warehouse? If yes, please consider marking the response as the accepted solution.

  • 1 kudos
1 More Replies
viniciusmartins
by • New Contributor II
  • 1800 Views
  • 4 replies
  • 2 kudos

Dataflow Gen2 Timeout When Loading Databricks Tables

 I created a Dataflow Gen2 to get data from Databricks. I can see the preview data very quickly (around 5 seconds). But when I run the dataflow, it takes 8 hours and then cancels with a timeout. I’m trying to get 8 tables with the same schema. Six of...

  • 1800 Views
  • 4 replies
  • 2 kudos
Latest Reply
viniciusmartins
New Contributor II
  • 2 kudos

Do you think the Databricks cluster that Microsoft Fabric is connected to needs more capacity?

  • 2 kudos
3 More Replies
andre_rizzatti
by • New Contributor II
  • 5074 Views
  • 5 replies
  • 4 kudos

SQLWarehouse Case INsensitive

Good morning, is there any parameter or configuration that causes all my data to be consulted without case distinction? insensitive?

  • 5074 Views
  • 5 replies
  • 4 kudos
Latest Reply
Harshad_B
New Contributor III
  • 4 kudos

Is this feature available in GA? Can you help with documentation?

  • 4 kudos
4 More Replies
amekojc
by • New Contributor III
  • 2178 Views
  • 2 replies
  • 1 kudos

Resolved! Show values as rows instead of columns in pivot table Databricks AI/BI

Is there a way to show values in columns instead of rows in pivot table function?I have fields I want to show as rows, and when I want to add multiple fields under values, they show as rows instead of columns.I want each values field to show as colum...

  • 2178 Views
  • 2 replies
  • 1 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 1 kudos

Hello @amekojc ,  Yes — Databricks AI/BI pivot tables do support showing multiple measure values as columns, not just as a single stacked “values” row. How to set it up Create a Pivot visualization and add your dimension fields under Rows, and optio...

  • 1 kudos
1 More Replies
Malthe
by • Valued Contributor II
  • 4513 Views
  • 4 replies
  • 1 kudos

Resolved! Intermittent connectivity issues between Power BI and Databricks

We're experiencing connectivity issues between Power BI (refreshing a dataset) and Databricks.On the Databricks side, we're using a SQL Warehouse (serverless), which reports queries timing out:Query has been timed out due to inactivity.On the Power B...

  • 4513 Views
  • 4 replies
  • 1 kudos
Latest Reply
emma_s
Databricks Employee
  • 1 kudos

From everything you've said, it's most likely some kind of Cloud issue with regional availability or network connectivity between Power BI and Databricks. If you want to pursue further I would suggest you log a support ticket with your cloud provider...

  • 1 kudos
3 More Replies