cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Help
Warehousing & Analytics
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Start a conversation
Salty
by • New Contributor II
  • 949 Views
  • 4 replies
  • 2 kudos

Resolved! DBSQL subscriptions method returning `410: Gone`

We've been using the DQBSQL API to perform CRUD on queries and alerts.Part of that process added a slack channel as alert destination using the /subscriptions element on an alert post as below.As of today I am getting a 410 'Gone' error from the API ...

Warehousing & Analytics
Reply
  • 949 Views
  • 4 replies
  • 2 kudos
View Replies
Latest Reply
Salty
New Contributor II
  • 2 kudos

Hi @Suteja Kanuri​ , @Vidula Khanna​ thanks for getting back with a solution.The suggested solution looks fine, but for a number of reasons I went with another option to use the Jobs API. This allowed me to preserve more of the automation I had alrea...

  • 2 kudos
3 More Replies
Carkis7
by • New Contributor II
  • 1501 Views
  • 4 replies
  • 6 kudos

Databricks SQL Option

Hello Everyone,I want you to ask how can I get the SQL option on Databricks, because I am doing the Data Analyst courses and I do not have that option, just Data Engineer and Machine Learning. I am connecting through Microsoft Azure..Waiting for your...

Warehousing & Analytics
Reply
  • 1501 Views
  • 4 replies
  • 6 kudos
View Replies
Latest Reply
Hemant
Valued Contributor II
  • 6 kudos

@Luis Carcaño​  You can switch your persona from data science and engineering to SQL, but this is only possible if you have a premium Databricks workspace. To do so, please create a new workspace with a premium tier.

  • 6 kudos
3 More Replies
shan_chandra
by • Honored Contributor III
  • 1634 Views
  • 2 replies
  • 4 kudos

Resolved! How to provide read access only to the view in DBSQL and not the underlying table?

Facing the below errorUser cannot select on table `database2.view1` because: There is no owner for table `database1.table1`. Ask your administrator to set an owner."

Warehousing & Analytics
Reply
  • 1634 Views
  • 2 replies
  • 4 kudos
View Replies
Latest Reply
shan_chandra
Honored Contributor III
  • 4 kudos

Please find the below resolutionThe owner of the table needs to be the same as the owner of the ViewCreate a group with users for whom we require only access to the viewThe group needs to have SELECT and READ_METADATA on view(database2.view1), USAGE ...

  • 4 kudos
1 More Replies
User16826992666
by • Valued Contributor
  • 1147 Views
  • 1 replies
  • 1 kudos

Resolved! Do Databricks SQL Endpoints support PowerBI in DirectQuery mode?

Warehousing & Analytics
Reply
  • 1147 Views
  • 1 replies
  • 1 kudos
View Replies
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
  • 511 Views
  • 1 replies
  • 0 kudos

Is global temp views supported on DBSQL endpoints?

Warehousing & Analytics
Reply
  • 511 Views
  • 1 replies
  • 0 kudos
View Replies
Latest Reply
Ryan_Chynoweth
Honored Contributor III
  • 0 kudos

After testing this. I was unable to create a global temporary view on a SQL Endpoint. I was able to create a temporary view for that session as well as a normal view. So while the global temp view seems to be unsupported there are a number of other o...

  • 0 kudos
Anonymous
by • Not applicable
  • 368 Views
  • 0 replies
  • 0 kudos

Collaborating in DBSQL

Are there workarounds that would allow multiple people to edit the same dashboard? I understand that "can edit" permission is on the roadmap but is there anything else they can do in the meantime to collaborate? Is it possible to disable access contr...

Warehousing & Analytics
Reply
  • 368 Views
  • 0 replies
  • 0 kudos
Digan_Parikh
by • Valued Contributor
  • 717 Views
  • 1 replies
  • 0 kudos

Resolved! DBSQL connection to other BI tools

How do i connect DBSQL to other BI tools?

Warehousing & Analytics
Reply
  • 717 Views
  • 1 replies
  • 0 kudos
View Replies
Latest Reply
Digan_Parikh
Valued Contributor
  • 0 kudos

Generally, you can connect to SQL endpoint using a ODBC or JDBC driver. More information can be found here. https://docs.databricks.com/integrations/bi/index-sqla.html

  • 0 kudos
Labels