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
  • 4182 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
  • 4182 Views
  • 0 replies
  • 0 kudos
gilo12
by New Contributor III
  • 2767 Views
  • 1 replies
  • 1 kudos

request error: invalid operation state. This should not have happened

I am trying to identify errors coming from Databricks. So I can handle them in my code.Sometimes I get a descriptive error, that points me to the exact problem, but then if I run the exact same test, I sometimes get "request error: invalid operation ...

  • 2767 Views
  • 1 replies
  • 1 kudos
Latest Reply
mathan_pillai
Databricks Employee
  • 1 kudos

Can you share what command were you executing ? Also were you currently doing exception handling within your code with try/catch exception ? Can you also check the driver logs during the time error happened ? The driver logs should have more detail...

  • 1 kudos
RohitSingh
by New Contributor
  • 2627 Views
  • 1 replies
  • 1 kudos

Resolved! Video Submission

For purpose of posting video, can we post it on Google Drive, and share relevant link while submitting? Video will be made accessible to anyone with the link.Tagging @Karen Bajza-Terlouw​ and @Michelle Brain​ 

  • 2627 Views
  • 1 replies
  • 1 kudos
Latest Reply
Michelle_-_Devp
New Contributor III
  • 1 kudos

Hello! The video should be uploaded to and made publicly visible on YouTube, Vimeo, Facebook Video, or Youku so that it can playback on Devpost. This makes it easier for the judges

  • 1 kudos
115412
by New Contributor
  • 3809 Views
  • 2 replies
  • 2 kudos

Resolved! can you help me with connection between databricks and sftp file using paramiko??

https://community.databricks.com/s/question/0D58Y00009fClizSAC/ssh-connection-with-paramiko i read in this post that you can help me with that problem, please can you give me more advice what i have to do to connect to an sftp through ssh

  • 3809 Views
  • 2 replies
  • 2 kudos
Latest Reply
ZhengHuang
Databricks Employee
  • 2 kudos

Hi!Could you please let me know what your current blocker is? Are you looking for a code snippet that can help you get file through sftp? Or if you are looking for the spark config that whitelist the port? Or if you are blocked by some other error?

  • 2 kudos
1 More Replies
Joseph_B
by Databricks Employee
  • 11917 Views
  • 4 replies
  • 3 kudos

Connect Delta Lake to OData API?

I'd like to expose Delta Lake data to external customers via OData v4 APIs. What's the best way to do that?

  • 11917 Views
  • 4 replies
  • 3 kudos
Latest Reply
john1
New Contributor II
  • 3 kudos

Is the best answer to this still to implement the the OData intermediate service yourself? Or is there a better way now?

  • 3 kudos
3 More Replies
Ajay-Pandey
by Databricks MVP
  • 2765 Views
  • 0 replies
  • 2 kudos

Availability of SQL Warehouse to Data Science and Engineering persona ​Hi All,Now we can use SQL Warehouse in our notebook execution.It's in previ...

Availability of SQL Warehouse to Data Science and Engineering persona   ​ Hi All, Now we can use SQL Warehouse in our notebook execution. It's in preview now and soon will be GA.  

image.png
  • 2765 Views
  • 0 replies
  • 2 kudos
Chhaya
by New Contributor III
  • 8104 Views
  • 4 replies
  • 4 kudos

Resolved! DLT pipeline run cost

Hi team,   I am looking for a way to find DBU cost for DLT clusters, does it get stored anywhere I have been looking into event_logs but did not find information related to cost. it does have cluster resource utilization details. here is what I found...

dlt_Cost
  • 8104 Views
  • 4 replies
  • 4 kudos
Latest Reply
Anonymous
Not applicable
  • 4 kudos

Hi @Chhaya Vishwakarma​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best an...

  • 4 kudos
3 More Replies
dhruv1
by New Contributor II
  • 3592 Views
  • 3 replies
  • 0 kudos
  • 3592 Views
  • 3 replies
  • 0 kudos
Latest Reply
Anonymous
Not applicable
  • 0 kudos

Hi @Dhruv Dalsania​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answer...

  • 0 kudos
2 More Replies
chrisbrowntrue
by New Contributor
  • 1676 Views
  • 0 replies
  • 0 kudos

Explore the major offerings of the MetaMask WalletIf you participating in the crypto economy, you might have come across the term MetaMask Wallet once...

Explore the major offerings of the MetaMask WalletIf you participating in the crypto economy, you might have come across the term MetaMask Wallet once in a while. In this read, we will explore why we should go for MetaMask by acknowledging the major ...

Metamask  sing  in & extension banner MetaMask_Fox
  • 1676 Views
  • 0 replies
  • 0 kudos
dhruv1
by New Contributor II
  • 3425 Views
  • 2 replies
  • 0 kudos
  • 3425 Views
  • 2 replies
  • 0 kudos
Latest Reply
Anonymous
Not applicable
  • 0 kudos

Hi @Dhruv Dalsania​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answer...

  • 0 kudos
1 More Replies
Harry_L
by New Contributor II
  • 5819 Views
  • 2 replies
  • 1 kudos

Resolved! How/where can I set credentials for DataBricks SQL to create a external table.

I've triend this code in Databricks SQL create table people_db.GLAccount USING PARQUET LOCATION "abfss://datamesh@dlseu2dtaedwetldtlak9.dfs.core.windows.net/PricingAnalysis/rdv_60_134.vGLAccount.parquet" But I'm getting a "Invalid configuration...

  • 5819 Views
  • 2 replies
  • 1 kudos
Latest Reply
-werners-
Esteemed Contributor III
  • 1 kudos

you can define 'data access configuration' in the admin panel.go to SQL warehouse settings -> Data Access configurationhttps://learn.microsoft.com/en-us/azure/databricks/sql/admin/data-access-configuration

  • 1 kudos
1 More Replies
rcmarcelo
by New Contributor III
  • 5162 Views
  • 3 replies
  • 4 kudos

Resolved! Group-user link via SQL

I've been trying to check, via databricks SQL, which groups a user belongs to. When I run SHOW GROUPS or SHOW USERS, everything is returned correctly.However, when a try to run: SHOW GROUPS WITH USER `user@domain.com`Nothing is returned, but the u...

  • 5162 Views
  • 3 replies
  • 4 kudos
Latest Reply
Anonymous
Not applicable
  • 4 kudos

Hi @Marcelo Castro​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Tha...

  • 4 kudos
2 More Replies
ehsan1
by New Contributor II
  • 1991 Views
  • 1 replies
  • 1 kudos

Having issue in querying Data bricks End point using SQL Workbench/J

It was working fine initially.   Message: [Simba][SparkJDBCDriver](500618) Error occured while deserializing arrow data: sun.misc.Unsafe or java.nio.DirectByteBuffer.<init>(long, int) not available [SQL State=HY000, DB Errorcode=500618]

  • 1991 Views
  • 1 replies
  • 1 kudos
Latest Reply
Anonymous
Not applicable
  • 1 kudos

@Ehsan Ullah​ :The error message you received indicates that there is an issue with deserializing arrow data in the Spark JDBC driver. This error is caused by the fact that the sun.misc.Unsafe or java.nio.DirectByteBufferclasses are not available.To ...

  • 1 kudos
Priyag1
by Honored Contributor II
  • 7078 Views
  • 1 replies
  • 9 kudos

Refreshing SQL DashboardYou can schedule the dashboard to automatically refresh at an interval.At the top of the page, click Schedule.If the dashboard...

Refreshing SQL DashboardYou can schedule the dashboard to automatically refresh at an interval.At the top of the page, click Schedule.If the dashboard already has a schedule, you see Scheduled instead of Schedule.Select an interval, such as Every 1 h...

  • 7078 Views
  • 1 replies
  • 9 kudos
Latest Reply
samhita
New Contributor III
  • 9 kudos

Useful

  • 9 kudos