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
  • 4321 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
  • 4321 Views
  • 0 replies
  • 0 kudos
dtu
by • New Contributor II
  • 325 Views
  • 1 replies
  • 0 kudos

Resolved! 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
  • 325 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
Akshay_Petkar
by • Valued Contributor
  • 4548 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...

  • 4548 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
iamgoce
by • New Contributor III
  • 1987 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...

  • 1987 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
  • 737 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 ...

  • 737 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
  • 473 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...

  • 473 Views
  • 2 replies
  • 0 kudos
Latest Reply
SumeshKashyap
Valued 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
  • 331 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...

  • 331 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
  • 1795 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 ...

  • 1795 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
  • 1259 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...

  • 1259 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
  • 775 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?

  • 775 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
VTiw25
by • New Contributor II
  • 720 Views
  • 3 replies
  • 5 kudos

Landing Layer vs. Bronze Layer — When to Use Which?

 I’ve seen two common approaches in data architectures:Landing → Bronze: Raw files are first dumped into a landing layer, archived, and then loaded into Delta tables as Bronze.Raw files = Bronze: The raw file dump itself is treated as the Bronze laye...

  • 720 Views
  • 3 replies
  • 5 kudos
Latest Reply
masonreed11
Contributor
  • 5 kudos

The choice mainly depends on replay, audit, and governance needs. If you need a reliable source of truth for reprocessing, keep raw files separate from Bronze. Otherwise, treating raw files as Bronze can reduce storage, cost, and complexity. Make the...

  • 5 kudos
2 More Replies
Ji-Seung
by • New Contributor III
  • 622 Views
  • 2 replies
  • 2 kudos

Got error using Opensharing Get Table API to foreign iceberg table

Hi, There is Get Table api in open sharing. and I faced error while using it. test_iceberg_table is foreign iceberg table.curl -s -X GET \      'https://frankfurt.cloud.databricks.com/api/2.0/delta-sharing/metastores/617a9420-4294-453a-8a56-ea87eb418...

  • 622 Views
  • 2 replies
  • 2 kudos
Latest Reply
GabFernandes
Contributor III
  • 2 kudos

Hi @Ji-Seung,The ENDPOINT_NOT_FOUND error makes sense — the endpoint you're trying to call does not exist in the Delta Sharing open protocol. There is no standalone "Get Table" (singular) endpoint at that path.The Delta Sharing Protocol Endpoints for...

  • 2 kudos
1 More Replies
sachamourier
by • Contributor
  • 5299 Views
  • 5 replies
  • 2 kudos

Importing Python files into another Workspace Python file does not work

I have created Python modules containing some Python functions and I would like to import them from a notebook contained in the Workspace. For example, I have a "etl" directory, containing a "snapshot.py" file with some Python functions, and an empty...

Warehousing & Analytics
Databricks
Modules
python
  • 5299 Views
  • 5 replies
  • 2 kudos
Latest Reply
dee_vy
New Contributor II
  • 2 kudos

Hello,I was facing the same issues as the OP and was unable to resolve them using the suggested solutions.In my case, the root cause turned out to be the cluster configuration rather than pytest or Databricks imports.I verified this by switching to a...

  • 2 kudos
4 More Replies
dbernstein_tp
by • Contributor II
  • 1117 Views
  • 5 replies
  • 3 kudos

Resolved! Databricks streamlit app with write back capability and audit trail display

Hi Everyone, This is a follow up to a previous question I posted. We have a need for a number of apps that have a spreadsheet-like interface and read/write to our lakehouse. A common spec that comes up in these discussions is the need for managers to...

  • 1117 Views
  • 5 replies
  • 3 kudos
Latest Reply
dbernstein_tp
Contributor II
  • 3 kudos

Thank you both for those very quick and excellent responses. The hovering thing is just an example of the kind of question I get, probably not an exact spec. I would be happy if the audit trail can be displayed somehow in the app.

  • 3 kudos
4 More Replies
brickuser
by • New Contributor II
  • 910 Views
  • 2 replies
  • 0 kudos

Resolved! How to remove/delete a Relationship Graph (Semantic Model) from an AI/BI Dashboard?

Hi everyone,I'm working on an AI/BI dashboard and I accidentally initialized a Relationship Graph (semantic model) by clicking "Get started with Relationships" in the Data tab. The model has no relationships and no measures -- it just auto-created en...

Warehousing & Analytics
AI-BI Dashboard
dashboard
  • 910 Views
  • 2 replies
  • 0 kudos
Latest Reply
balajij8
Esteemed Contributor II
  • 0 kudos

Hi brickuser,You have hit a UI limitation with the Dashboard Relationships (Semantic Model) feature in Public Preview. Once you click Get started with Relationships, Databricks automatically initializes a semantic model from your existing datasets. W...

  • 0 kudos
1 More Replies
tcranoratmcgee
by • New Contributor II
  • 777 Views
  • 4 replies
  • 0 kudos

NetSuite connector (Lakeflow Connect) — transactionline refresh takes 3.5–4.8 hrs regardless

Setup: Lakeflow Connect Netsuite pipeline (UC Connection, deployed via UI), Azure Databricks. Target table is netsuite.transactionline, currently about 13.8M rows, 395 columns, CDC ingestion type (I know I know but there aren't that many rows changin...

  • 777 Views
  • 4 replies
  • 0 kudos
Latest Reply
matt_precog
New Contributor II
  • 0 kudos

Hey there, we offer a best-in-class ELT tool that can connect NetSuite to Azure Databricks out of the box.It supports incremental loading.Might you be interested in this tool?https://studio.precog.cloud 

  • 0 kudos
3 More Replies