- 3946 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 ...
- 3946 Views
- 4 replies
- 2 kudos
- 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
- 4663 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...
- 4663 Views
- 4 replies
- 6 kudos
- 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
- 3422 Views
- 1 replies
- 4 kudos
Resolved! How to provide read access only to the view in DBSQL and not the underlying table?
Facing the below error User cannot select on table `database2.view1` because: There is no owner for table `database1.table1`. Ask your administrator to set an owner."
- 3422 Views
- 1 replies
- 4 kudos
- 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
- 2092 Views
- 1 replies
- 1 kudos
- 2092 Views
- 1 replies
- 1 kudos
- 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
- 1247 Views
- 1 replies
- 0 kudos
- 1247 Views
- 1 replies
- 0 kudos
- 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
- 1897 Views
- 1 replies
- 0 kudos
- 1897 Views
- 1 replies
- 0 kudos
- 0 kudos
You can do this via the "Share" option in the dashboard and define the appropriate permission - Can Run vs Can Manage from there
- 0 kudos
- 921 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...
- 921 Views
- 0 replies
- 0 kudos
- 1156 Views
- 0 replies
- 0 kudos
- 1156 Views
- 0 replies
- 0 kudos
- 1194 Views
- 0 replies
- 1 kudos
- 1194 Views
- 0 replies
- 1 kudos
- 919 Views
- 0 replies
- 0 kudos
- 919 Views
- 0 replies
- 0 kudos
- 1612 Views
- 0 replies
- 1 kudos
- 1612 Views
- 0 replies
- 1 kudos
- 1839 Views
- 1 replies
- 0 kudos
Resolved! DBSQL connection to other BI tools
How do i connect DBSQL to other BI tools?
- 1839 Views
- 1 replies
- 0 kudos
- 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