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
  • 3114 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
  • 3114 Views
  • 0 replies
  • 0 kudos
Anonymous
by Not applicable
  • 1834 Views
  • 2 replies
  • 0 kudos
  • 1834 Views
  • 2 replies
  • 0 kudos
Latest Reply
prasadvaze
Valued Contributor II
  • 0 kudos

@Harikrishnan Kunhumveettil​  Using Azure databricks, I have set up SQL Endpoint with the connection details that match with global init script. I am able to browse tables from regular cluster in Data Engineering module but i get below error when t...

  • 0 kudos
1 More Replies
Prabakar
by Databricks Employee
  • 7770 Views
  • 1 replies
  • 2 kudos

Resolved! Error with GRANT in Databricks SQL

While trying to GRANT SELECT permissions for a Database or Table it reports the below error.Error running query Operation not allowed: GRANT(line 1, pos 0) == SQL == GRANT SELECT ON DATABASE my_database TO `my_table` LIMIT 1000 ^^^

  • 7770 Views
  • 1 replies
  • 2 kudos
Latest Reply
Prabakar
Databricks Employee
  • 2 kudos

In Databricks SQL, by default, the Limit clause is enabled. So trying GRANT with limit will throw the error. Uncheck the Limit to execute the GRANT successfully.Default:Uncheck Limit to fix this. 

  • 2 kudos
User16826992666
by Databricks Employee
  • 2422 Views
  • 1 replies
  • 1 kudos
  • 2422 Views
  • 1 replies
  • 1 kudos
Latest Reply
Hubert-Dudek
Esteemed Contributor III
  • 1 kudos

According to: https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi yes. It is standard sql so should be not problem. However when querying this way there can be issues when querying by field which is not used to partitioning or ...

  • 1 kudos
Anonymous
by Not applicable
  • 529 Views
  • 0 replies
  • 0 kudos

14691989_354337641584477_4778513545854400919_o

Want to make a statement ? Ocean Wraps offers several different solutions for transforming your car or boat, from solid, single color boat wraps to completely custom designed boat wraps. We can work with you to create the perfect design for your vess...

  • 529 Views
  • 0 replies
  • 0 kudos
Anonymous
by Not applicable
  • 754 Views
  • 0 replies
  • 0 kudos

Management hacks: How to keep your desk clean and accessible all the time. If you want to buy a study desk, a sorted, clean, and organized study desk ...

Management hacks: How to keep your desk clean and accessible all the time.If you want to buy a study desk, a sorted, clean, and organized study desk should be your first bet and motivates you much more to work hard. Desk Cable management solution mak...

  • 754 Views
  • 0 replies
  • 0 kudos
Anonymous
by Not applicable
  • 734 Views
  • 0 replies
  • 0 kudos

sofadungtien.com

Sofa Dũng Tiến là thương hiệu cửa đã được hơn 5000+ công trình yêu thích tin dùng. Sofa Dũng Tiến cung cấp các loại Sofa giá hợp lý nhất so với các đối thủ cạnh tranh trên thị trường. Đội ngũ giàu kinh nghiệm trên 15 năm, đảm bảo đáp ứng được hết nhữ...

  • 734 Views
  • 0 replies
  • 0 kudos
Advanced_Keto_1
by New Contributor
  • 575 Views
  • 0 replies
  • 0 kudos

www.bignewsnetwork.com

The stylish thing here is the way that there are a lot of science-sponsored BHB ketone diet pills sold web-based today, so how or for what reason is Keto Advanced 1500 so famous among a jam-packed ocean of keto weight reduction supplements? A portion...

  • 575 Views
  • 0 replies
  • 0 kudos
Men_s_Hair_Toup
by New Contributor II
  • 883 Views
  • 0 replies
  • 1 kudos

Lordhair specializes in hair replacement systems that promise a realistic look, natural hairline, high durability, and inexpensive pricing. Our growin...

Lordhair specializes in hair replacement systems that promise a realistic look, natural hairline, high durability, and inexpensive pricing. Our growing catalog of hair systems for men is perfect if you want a full head of hair without the risks assoc...

  • 883 Views
  • 0 replies
  • 1 kudos
Wilson
by New Contributor
  • 2555 Views
  • 1 replies
  • 2 kudos

Resolved! Bug with Azure Databricks SQL query parameters

2 Issues both related to query based drop down please read below documentation for more info: https://docs.microsoft.com/en-us/azure/databricks/sql/user/queries/query-parameters#query-based-dropdown-list   Issue # 1 Drop down list only accepts up to ...

  • 2555 Views
  • 1 replies
  • 2 kudos
Latest Reply
Prabakar
Databricks Employee
  • 2 kudos

Hi @Wilson Lee​ Thanks for the information. We'll test this internally and discuss it with the product team to fix it.

  • 2 kudos
Bilal1
by New Contributor III
  • 3854 Views
  • 5 replies
  • 2 kudos

Error when querying an XML table Databricks SQL Analytics

I've created an external table that points to an XML file on the ADLS. I've installed spark-xml library on my cluster. I can query the table on the cluster.   However, I cannot query the table on Databricks SQL. I get the following error. I suppose t...

  • 3854 Views
  • 5 replies
  • 2 kudos
Latest Reply
Anonymous
Not applicable
  • 2 kudos

Hello @Bilal Haniff​ - My name is Piper and I'm a moderator for the community. It's nice to meet you! Let's see how your fellow community members answer first and then the team will follow up if they need to.

  • 2 kudos
4 More Replies