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...
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....
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.
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...
Do you think the Databricks cluster that Microsoft Fabric is connected to needs more capacity?
Good morning, is there any parameter or configuration that causes all my data to be consulted without case distinction? insensitive?
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...
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...
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...
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...
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...
It should be still supported, the only change I can find is that the table that you're referencing can't have a row filter applied to it. Has the users table got any type of row filter on it? It also can't create any type of circular reference.
On the Databricks documentation they take the TPCH classical tables to create some example https://docs.databricks.com/aws/en/metric-views/create/It's pretty easy to create a metric view using orders and do a measure like SUM(totalprice). Now let's s...
Hi @alxsbn , The Metric View joins are designed for "Many-to-One" relationships. Because orders and lineitem have a One-to-Many relationship (one order has multiple line items), you cannot join lineitem onto an orders-based Metric View and aggregate...
I want to upload excel file to make a table by using UI in databricks.since databricks doesn't accept excel files. So I tried to change the datatype of all the data in excel to string first.Then transform it to csv uft-8, and click the [create ]butt...
If your workspace has Genie spaces enabled, you can upload Excel (.xlsx) directly to Genie and analyze it there; it’s designed for quick validation and NLQ over uploaded files and UC tables. Otherwise, you can use the following approaches: Option A: ...
For one of my client, we are building the entire semantic layer for Data (BI) reporting who uses Snowflake. Is there a way to quickly integrate AI/BI Genie on top of Snowflake ?
Hey @TJ-Leap-Forward , Yes — you can stand up Databricks AI/BI Genie on top of Snowflake quickly by federating Snowflake into Unity Catalog and then building Genie spaces over those governed datasets, without migrating data out of Snowflake. This wo...
I have trouble understanding why, for every report in a dashboard that refers to the same data source, the query re-runs each time Ideally I would want queries being used to fuel the tables for the dashboard run exactly once, and then have the filter...
Your expectation is reasonable, but most dashboards are designed to recompute queries per visual. The best workaround is to precompute the base dataset in a table or view, and have all visuals query that instead. This reduces query load and ensures c...
Hi everyone. I'm keen to understand what impacts the "Optimizing query & pruning files" times seen in the Query Profile History for a sQL Warehouse query. We're querying against delta tables and cannot find any information about what or when a query ...
Hey @Louis_Frolio, thank you for the detailed response - really useful. We'll work through what looks most relevant to us. Question 1: Can you confirm of the `compilation_time_ms` in the metrics from the list query endpoint corresponds to the “Optimi...
Hi everyone,I’m trying to create a table in Unity Catalog from a folder that lives inside a Volume, but I can’t get Terraform to create it successfully.Below is the simplified/anonymous version of my Terraform setup.I have:* A Unity Catalog* A Schema...
It will not work because it will detect that the locations overlap. I tried it in some experiments, like displaying delta_log in volumes, but it didn't work. In fact, it is secure this way as the Delta files in volume would bypass Unity Catalog ACL f...
How can I add a break line between data labels in Visualization Editor?Not seeing anything in the documentation that helpsI would like the data labels in the example below to show as:trade count: 223Price: 84.71875
@AlexG, you can share this in the feature request section so the team can consider it.
how do we apply/add/make Interactive actions in databricks dashboard on tabular chart. here is my case,I have 2 datasets like below,customer tableCustomer region_cdAA GABB CNRegion tableregion_cd name PINGA Georgia 12345 in dashbaord i have 2 pane o...
Hi @boopa45 ,If I understood your requirements correctly you're looking for cross-filtering behaviour. Here's a couple of examples:Cross-filtering for AI/BI dashboards - Databricks Community - 82912Next-Level Interactivity in AI/BI Dashboards | Datab...
I do not see the option as mentioned in the documentation here: https://docs.databricks.com/aws/en/dashboards/#:~:text=Download%20results%E2%80%8B,final%20file%20download.Please let me know if PNG is the only available option currently?
Hi @amdata ,It was possible until recently There's a bug and databricks team is working on a fix. So soon they should release a fix and then you will be able to export to csv as stated in documentation. Check below thread for more info:ONLY PNG form...
