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
  • 4255 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
  • 4255 Views
  • 0 replies
  • 0 kudos
Capri
by • New Contributor
  • 377 Views
  • 3 replies
  • 2 kudos

Dashboard DAB Deployment: default_catalog and default_schema do not work for metric views anymore

We deploy Dashboards using DAB. We set default_catalog and default_schema for the dashboard, so in the `dashboard.lvdash.json` we only need the last part of table and metric names. Starting yesterday (Sep 29th, 2026), this does not work anymore and w...

  • 377 Views
  • 3 replies
  • 2 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 2 kudos

Hello @Capri, I took a look at both internal and external documentation and here is what I found. You're not alone, and nothing on your side caused this. @SamuelHarris reported the identical failure on Sep 30 on this thread (https://community.databri...

  • 2 kudos
2 More Replies
dtu
by • New Contributor
  • 153 Views
  • 1 replies
  • 0 kudos

Unable to connect to Tableau Cloud

I was trying to connect tables in Azure Databricks to Tableau Cloud using Explore In Tableau Cloud, but got the error:    Here's the instruction I follow Connect Tableau and Azure Databricks I am the Tableau Cloud site admin, but don't see Explore in...

DBX to Tableau Cloud error.png
  • 153 Views
  • 1 replies
  • 0 kudos
Latest Reply
datarich
Databricks Employee
  • 0 kudos

It looks like that error comes from Tableau Cloud rather than Databricks, that documentation guide should be the right one. There isn't an "Explore in Tableau" setting to turn on in Tableau Cloud. Web authoring is always on for Cloud (https://help.ta...

  • 0 kudos
Valeria_Koz_DBX
by • Databricks Employee
  • 186 Views
  • 0 replies
  • 2 kudos

How to build FinOps chargeback by cost centre — allocating the whole cloud bill, not just your DBUs

Every IT function I've worked with eventually asks the same question, and can never answer it cleanly and clearly: "What did each team actually cost us last month?"When speaking with the platform team at a large UK bank, the realisation was that the ...

  • 186 Views
  • 0 replies
  • 2 kudos
playnicekids
by • New Contributor III
  • 1694 Views
  • 3 replies
  • 1 kudos

Resolved! Recommended local development workflow for dashboard CI/CD with environment-specific catalog/schema?

Hi all,I’m trying to implement CI/CD for Databricks AI/BI dashboards using Declarative Automation Bundles, following guidance published by Databricks.The documentation recommends exporting dashboards as .lvdash.json using databricks bundle generate, ...

  • 1694 Views
  • 3 replies
  • 1 kudos
Latest Reply
SamuelHarris
New Contributor II
  • 1 kudos

I too am facing the same issue, but my pipeline fails during the release. Previously the unqualified name was working and I moved my changes to Prod and its working fine there. I did move another lvdash dash file and now Im getting this error during ...

  • 1 kudos
2 More Replies
Akshay_Petkar
by • Valued Contributor
  • 4367 Views
  • 2 replies
  • 0 kudos

Facing Data Truncation Issues in Databricks Dashboards

I'm encountering data truncation in my Databricks dashboards. I'm working with a large dataset, and the dashboard only displays a limited number of (truncated) rows.let's take a dataset containing 1 million sales records. The dashboard currently only...

  • 4367 Views
  • 2 replies
  • 0 kudos
Latest Reply
NandiniN
Databricks Employee
  • 0 kudos

Hi @Akshay_Petkar , This is simple in Databricks SQL, just uncheck LIMIT 1000 in the drop down. https://docs.databricks.com/en/sql/get-started/visualize-data-tutorial.html Limit 1000 is selected by default for all queries to ensure that the query ret...

  • 0 kudos
1 More Replies
EminBoz
by • Databricks Partner
  • 7235 Views
  • 5 replies
  • 1 kudos

"Revoke" permissions for SQL-Warehouse with API

Hello dear community,   i am trying to revoke permissions with the API for SQL-Warehouse. Granting permissions isn't a problem and works like a charme. But revoking won't function. I tried "NO_PERMISSIONS", "NO PERMISSIONS", "DENY", "REVOKE" But i al...

image.png
  • 7235 Views
  • 5 replies
  • 1 kudos
Latest Reply
ashford
New Contributor II
  • 1 kudos

You may want to check whether the API expects a specific permission type for revocation rather than a special value such as NO_PERMISSIONS or REVOKE. The error suggests the request is reaching the endpoint, but the permission payload isn't matching t...

  • 1 kudos
4 More Replies
saf_dbx
by • New Contributor II
  • 271 Views
  • 2 replies
  • 2 kudos

ODBC v2.12- 503 "no Retry-After header"

I'm connecting to a Databricks catalog via a SQL Warehouse using the Databricks ODBC Driver (v2.12.0). During one of the fetches from my BI application, the transaction aborts with:Database operation [SQLExecute] failed with error [[Databricks][Hardy...

  • 271 Views
  • 2 replies
  • 2 kudos
Latest Reply
ThomazNeto
Databricks Partner
  • 2 kudos

Hi,I've hit this exact error in a few environments, so maybe this helps.First, the 503 itself is coming from the Databricks side, not from your BI tool or the driver. In every case I've traced it, the timestamps lined up with the SQL Warehouse being ...

  • 2 kudos
1 More Replies
ablanchard
by • New Contributor II
  • 235 Views
  • 1 replies
  • 1 kudos

UC Delta API: managed-table READ_WRITE credentials rejected despite explicit User-Agent

Hi everyone,I’m developing HarborSQL, an open-source SQL engine using Apache DataFusion and delta-rs. I’m working on managed Delta table writes through the UC Delta API with catalog commits.Using the same workspace, managed table, and user identity:-...

  • 235 Views
  • 1 replies
  • 1 kudos
Latest Reply
GabFernandes
Contributor III
  • 1 kudos

Hi @ablanchard .The behavior you're seeing is expected for the Delta protocol-level credential endpoint (/api/2.1/unity-catalog/delta/v1/.../credentials). A few things to note:Managed Delta table writes from external Delta clients are in Public Previ...

  • 1 kudos
iamgoce
by • New Contributor III
  • 1819 Views
  • 4 replies
  • 2 kudos

External embedding for reports using federated credentials fails

Hi,We are implementing external dashboard embedding in Azure Databricks and want to avoid using client secrets by leveraging **Azure Managed Identity** with **OAuth token federation** for generating the embedded report token.Following OAuth token fed...

  • 1819 Views
  • 4 replies
  • 2 kudos
Latest Reply
iamgoce
New Contributor III
  • 2 kudos

Databricks still hasn't committed to addressing this issue.The only workaround is to get enrolled in the private preview for Dashboard Embedding with SSO (Embed with SSO Preview User Guide - Google Docs). This only works if you're already authorizing...

  • 2 kudos
3 More Replies
Leembo
by • New Contributor
  • 651 Views
  • 1 replies
  • 0 kudos

Controlling allow/ask/deny lists for predelivered MCP connectors

Hello,We are looking at utilizing the pre-delivered MCP connector to M365 via Genie One. The connector works great, but each user can individually configure the allowable tool calls without any central governance layer.Are we missing something or is ...

  • 651 Views
  • 1 replies
  • 0 kudos
Latest Reply
DB-RKL
Databricks Employee
  • 0 kudos

Hey @Leembo system.ai.microsoft_365 is now a 1st class UC object ("MCP service") that runs through Unity Gateway, same as the external connectors you register yourself. Two levels of control: - Whole connector on/off:  an EXECUTE grant, so you can al...

  • 0 kudos
Gharhub
by • New Contributor
  • 335 Views
  • 2 replies
  • 0 kudos

Optimizing B2B E-Commerce & Construction Supply Chain Pipelines (Data Architecture Case Study)

Hi Databricks Community,When scaling e-commerce platforms especially in complex domains like construction and building materials—real-time inventory management, price matching, and dynamic logistics pipelines present unique data engineering challenge...

  • 335 Views
  • 2 replies
  • 0 kudos
Latest Reply
SumeshKashyap
New Contributor III
  • 0 kudos

This one's really a network/download-client issue more than a Databricks one, but since the end goal is presumably getting the data into Databricks, a couple of angles: - Browser downloads are single-connection and easy to bottleneck -- 8-9 Mbps on a...

  • 0 kudos
1 More Replies
fjrodriguez
by • New Contributor III
  • 231 Views
  • 1 replies
  • 1 kudos

Could Databricks app support the integration of Genei Room and Power BI?

Is it possible: a Databricks App embedding Power BI ? Rather than placing Genie inside Power BI, place Power BI inside Databricks. A Databricks App (React or Streamlit) hosts native Genie chat alongside a Power BI report embedded via the JavaScript S...

  • 231 Views
  • 1 replies
  • 1 kudos
Latest Reply
balajij8
Esteemed Contributor II
  • 1 kudos

@fjrodriguez The integration is technically feasible. Apps built with AppKit (the recommended TypeScript + React SDK) generally include a native Genie plugin that provides conversational AI/BI capabilities with natural language queries. You can embed...

  • 1 kudos
Andrea_
by • New Contributor
  • 1667 Views
  • 4 replies
  • 0 kudos

Change the default font for plots

Hi community, As the title says, I have been checking the documentation, but I could not find clear references to my question.I am working in a project, and I need to change all the plots fonts to match a specific brand. All plots are generated with ...

  • 1667 Views
  • 4 replies
  • 0 kudos
Latest Reply
josephhawk21
New Contributor II
  • 0 kudos

Updating every plot one by one can become a real hassle as the project grows. A global font setting is much easier for keeping the same brand style across all visual outputs, especially when using a fancy arabic font.https://zakhrafalasmaa.com/

  • 0 kudos
3 More Replies
fjrodriguez
by • New Contributor III
  • 837 Views
  • 5 replies
  • 3 kudos

Resolved! Is it possible to embed a Genie Space inside a Power BI report?

Hi all,Is there any supported way to embed a Genie Space directly inside a Power BI report (not a classic dashboard), so users can chat with it without leaving Power BI?I'm aware Genie Spaces support iframe embedding for external apps, but Power BI r...

  • 837 Views
  • 5 replies
  • 3 kudos
Latest Reply
fjrodriguez
New Contributor III
  • 3 kudos

Thanks every one ! Was a great one :9

  • 3 kudos
4 More Replies
anmolhhns
by • New Contributor III
  • 614 Views
  • 2 replies
  • 3 kudos

SQL Query billing

Is there any way to find a cost of one single query? i can't find any table in system catalog to connect a query with usage to find the exact cost of one query run in sql warehouse?

  • 614 Views
  • 2 replies
  • 3 kudos
Latest Reply
AbhilashNagilla
Databricks Employee
  • 3 kudos

The published system tables do not expose the exact cost of an individual SQL statement. system.billing.usage records warehouse-attributed usage for each record's time interval, but has no statement or session ID. system.query.history records stateme...

  • 3 kudos
1 More Replies