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...
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...
@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...
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...
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...
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...
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...
Hi everyone,I’m exploring the new Databricks Metric Views (Semantic Layer) and have two questions regarding programmatic management and UI visualization.1. Parser Disparity: spark.sql vs. SQL WarehouseI'm noticing that CREATE OR REPLACE VIEW ... WITH...
Hi @smpa011,Metric views work on both SQL warehouse and classic clusters, but the cluster must be running DBR 17.2 or above. The error you are getting is because you may be using DBR version below 17.2 or so. try upgrading your DBR version or use SQL...
I created an external connection to an Oracle Database 12c Standard Edition Release 12.1.0.2.0.The connection is working, I executed successfully a lot of queries with different filters and joins. But I couldn't find a way to make any date filter pus...
Can you spin up a DBR 18+ all-purpose compute cluster with this spark config set to true spark.databricks.connector.oracle.properlyCompileJava8Values true and then re-run your tests? If this works then I think it might be a known issue and we can fin...
how to create a workspace with community edition?workspace is not being created after login to community edition.
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.
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...
Hey @Ties , When a query reaches 100% completion but fails to commit, it usually points to a metadata bottleneck, file system contention, or a massive data skew. While the job is hanging at 100%, go to the Spark UI -> Executors tab -> Driver -> Threa...
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...
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.
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...
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...
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...
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...
