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
  • 1377 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
  • 1377 Views
  • 0 replies
  • 0 kudos
maoruales32
by New Contributor
  • 186 Views
  • 1 replies
  • 0 kudos

Point map datapoints labels

Point map visualization datapoints labels do not let me input a specific column on them

  • 186 Views
  • 1 replies
  • 0 kudos
Latest Reply
Walter_C
Databricks Employee
  • 0 kudos

Previously replied in https://community.databricks.com/t5/warehousing-analytics/datapoints-labels-on-a-point-map-visualization/td-p/101839 

  • 0 kudos
aburkh
by New Contributor
  • 379 Views
  • 1 replies
  • 0 kudos

User default timezone (SQL)

Users get confused when querying data with timestamps because UTC is not intuitive for many. It is possible to set TIME ZONE at query level or at SQL Warehouse level, but those options fail to address the need of multiple users working on the same wa...

  • 379 Views
  • 1 replies
  • 0 kudos
Latest Reply
Alberto_Umana
Databricks Employee
  • 0 kudos

it is possible to set the time zone at the session level using the SET TIME ZONE statement in Databricks SQL. This allows users to control the local timezone used for timestamp operations within their session. However, there is no direct option of us...

  • 0 kudos
atikiwala
by New Contributor
  • 1016 Views
  • 1 replies
  • 0 kudos

Resolved! Working with Databricks Apps

I'm trying to use Databricks Apps to host a Streamlit app to serve some interactive applicaton. I face two limitations:1. In environment for App I see it using certain python version, but how to update it to use any other version?It is already set to...

atikiwala_0-1732008401891.png atikiwala_1-1732008777398.png
  • 1016 Views
  • 1 replies
  • 0 kudos
Latest Reply
parthSundarka
Databricks Employee
  • 0 kudos

Hi @atikiwala , Good Day! Python 3.11 is currently the only version we support. We are thinking of adding additional options in the future. Would love to hear your feedback on this - https://docs.databricks.com/en/resources/ideas.html#submit-product-...

  • 0 kudos
igorstar
by New Contributor III
  • 4130 Views
  • 3 replies
  • 2 kudos

Resolved! What is the difference between LIVE TABLE and MATERIALIZED VIEW?

From the DLT documentation it seems that the LIVE TABLE is conceptually the same as MATERIALIZED VIEW. When should I use one over another?

  • 4130 Views
  • 3 replies
  • 2 kudos
Latest Reply
Mo
Databricks Employee
  • 2 kudos

@ImranA and @igorstar  I repost my response here again:to create materialized views, you could use CREATE OR REFRESH LIVE TABLE however according to the official docs: The CREATE OR REFRESH LIVE TABLE syntax to create a materialized view is deprecat...

  • 2 kudos
2 More Replies
AnnaP
by New Contributor II
  • 830 Views
  • 1 replies
  • 0 kudos

[UNBOUND_SQL_PARAMETER] error

Hi, I'd appreciate it if anyone could help!We are using offical ODBC driver (Simba Spark ODBC Driver 64-bit 2.08.02.1013) in our application. C++ APIs.All the following SQL statements are passed through ODBC API to Databricks:successully executing: C...

  • 830 Views
  • 1 replies
  • 0 kudos
Latest Reply
PiotrMi
Contributor
  • 0 kudos

@AnnaP Hey,Did you try below:To disable the SQL Connector feature, select the Use Native Query check box.Important:l When this option is enabled, the connector cannot executeparameterized queries.l By default, the connector applies transformations to...

  • 0 kudos
Akshay_Petkar
by Contributor III
  • 601 Views
  • 1 replies
  • 1 kudos

How to Create a Live Streaming Dashboard on Databricks?

I am working on a use case where I have streaming data that needs to be displayed in real-time on a live dashboard. The goal is for any new data arriving in the stream to instantly reflect on the dashboard. Is this possible on Databricks? If yes, how...

  • 601 Views
  • 1 replies
  • 1 kudos
Latest Reply
christopher356
New Contributor II
  • 1 kudos

@Akshay_Petkar wrote:I am working on a use case where I have streaming data that needs to be displayed in real-time on a live dashboard. The goal is for any new data arriving in the stream to instantly reflect on the dashboard. Is this possible on Da...

  • 1 kudos
User16753724663
by Valued Contributor
  • 12710 Views
  • 5 replies
  • 3 kudos

Resolved! Unable to use CX_Oracle library in notebook

While using cx_oracle python library, it returns the below error:   error message: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory     The cx_oracle library is dependent on native...

  • 12710 Views
  • 5 replies
  • 3 kudos
Latest Reply
ovbieAmen
New Contributor II
  • 3 kudos

Hi @AshvinManoj  I used your script and still get same error.   sudo echo 'LD_LIBRARY_PATH="/dbfs/databricks/instantclient_23_6"' >> /databricks/spark/conf/spark-env.shsudo echo 'ORACLE_HOME="/dbfs/databricks/instantclient_23_6"' >> /databricks/spark...

  • 3 kudos
4 More Replies
mbhakta
by New Contributor II
  • 5545 Views
  • 3 replies
  • 2 kudos

Change Databricks Connection on Power BI (service)

We're creating a report with Power BI using data from our AWS Databricks workspace. Currently, I can view the report on Power BI (service) after publishing. Is there a way to change the data source connection, e.g. if I want to change the data source...

  • 5545 Views
  • 3 replies
  • 2 kudos
Latest Reply
J_C
New Contributor II
  • 2 kudos

In the Power BI transform data view, you should be able to access the M-Query code and actually change the server and the host directly. My recommendation is to create a couple of parameters to keep this info for all your queries. Then you can just c...

  • 2 kudos
2 More Replies
AE10
by New Contributor III
  • 1273 Views
  • 4 replies
  • 9 kudos

Embed dashboards in websites and applications

I am embedding a dashboard in my react application using an iframe.https://www.databricks.com/blog/how-embed-aibi-dashboards-your-websites-and-applicationshttps://docs.databricks.com/en/dashboards/index.html#embed-a-dashboard1. How can i let my users...

  • 1273 Views
  • 4 replies
  • 9 kudos
Latest Reply
Preeti_Singh
New Contributor II
  • 9 kudos

Hi , Has anyone gotten this working? I am facing the same issue when trying to get the embedded URL working from an iframe in my React application. I think I have all the necessary permissions in place, but still, the Databricks sign-in page opens in...

  • 9 kudos
3 More Replies
anardinelli
by Databricks Employee
  • 445 Views
  • 0 replies
  • 2 kudos

How do I dimension my DBSQL warehouse correctly?

What is the optimal number of cluster/nodes in a warehouse? Depends on your workload. Our DBSQL guide suggests a size range on two main things: time to execute your query and bytes spilled from it. This link can help you understand better optimizatio...

  • 445 Views
  • 0 replies
  • 2 kudos
bradleyjamrozik
by New Contributor III
  • 2499 Views
  • 3 replies
  • 0 kudos

ODBC Connection Does Not Disconnect

I have an on-premises Power BI Report Server that uses the Simba Spark ODBC Driver (2.8) to connect to Databricks. It can connect to a serverless warehouse successfully and run its queries, but it never seems to disconnect the session, and so the war...

  • 2499 Views
  • 3 replies
  • 0 kudos
Latest Reply
gmiguel
Contributor
  • 0 kudos

Hi @bradleyjamrozik ,The problem is that the current designed behavior of Power BI can lead to the connection not being closed under certain conditions.In short, since Databricks is Async, if an error occurs while fetching data, the connection may no...

  • 0 kudos
2 More Replies
Akshay_Petkar
by Contributor III
  • 983 Views
  • 2 replies
  • 1 kudos

Best Approach for Migrating from EMR to Databricks

I am preparing to migrate from EMR to Databricks and would like to know the best practices for this process. Is there a direct connector, such as a JDBC connector, available to facilitate the migration? Alternatively, would it be more effective to ex...

  • 983 Views
  • 2 replies
  • 1 kudos
Latest Reply
thelogicplus
Contributor
  • 1 kudos

@Akshay_Petkar if you're planning to migrate from your current technology to Databricks, Travinto Technologies' Code Converter Tool is here to make the process seamless. This powerful tool enables you to migrate data, ETL workflows, and reports acros...

  • 1 kudos
1 More Replies
San2
by New Contributor
  • 2806 Views
  • 1 replies
  • 0 kudos

recover a deleted workspace

I cancel my subscription plan (account created via accounts.databricks.com), without noticing that by doing this, all of my workspaces will be deleted. Is this possible to recover those workspace, and if possible, what should I do to recover them? 

  • 2806 Views
  • 1 replies
  • 0 kudos
Latest Reply
steyler-db
Databricks Employee
  • 0 kudos

Hello San2.   To recover a workspace, could you please raise a case with support? They will be helping you to recover these workspaces, otherwise you can reach your account team, who will help you for further steps, for more details you see disaster ...

  • 0 kudos
Ismail1
by New Contributor III
  • 3516 Views
  • 3 replies
  • 0 kudos

Migrating from Databases Postgres MySQL to Databricks.

Hi all, working on this project, my team plans to migrate some data from some databases to Databricks. We plan to run this migration by submitting queries to a warehouse through python on a local machine.Now I was wondering what would be the best app...

  • 3516 Views
  • 3 replies
  • 0 kudos
Latest Reply
thelogicplus
Contributor
  • 0 kudos

@Ismail1  if you're planning to migrate from your current technology to Databricks, Travinto Technologies' Code Converter Tool is here to make the process seamless. This powerful tool enables you to migrate data, ETL workflows, and reports across pla...

  • 0 kudos
2 More Replies