- 3771 Views
- 2 replies
- 0 kudos
Resolved! Connect Spark Cluster to SQL Endpoint
Hello! Is it possible to retrieve data from a SQL Endpoint in the Databricks SQL persona using the Data Science and Engineering persona? In other words, I would like to use pyspark in DS&E to query a table in Databricks SQL.#DatabricksSQL#Databricks...
- 3771 Views
- 2 replies
- 0 kudos
- 0 kudos
you do not need the sql warehouse itself for that. for ds & e you need a classic cluster (not a sql endpoint) anyway so you can easily read the tables from the metastore using spark.read.table().Connecting the sql endpoint to the ds cluster seems od...
- 0 kudos
- 5417 Views
- 5 replies
- 1 kudos
Resolved! Use different instance types in pools
I am wondering if it's possible to create a pool that has a mix of instance types in it?
- 5417 Views
- 5 replies
- 1 kudos
- 1 kudos
AWS Fleet instance types are now GA and available for clusters and instance pools. You can see more details here: https://docs.databricks.com/compute/aws-fleet-instances.html
- 1 kudos
- 3111 Views
- 3 replies
- 0 kudos
Resolved! Are there any scenarios where it doesn't make sense to use Spot Instances?
It seems like using spot instances make a lot of sense for cost savings. But are there any risks to using them? Or things to consider before enabling them?
- 3111 Views
- 3 replies
- 0 kudos
- 0 kudos
On AWS, to further improve the chance of acquiring spot instances, you can use the newly GA'd feature Fleet instance types: https://docs.databricks.com/compute/aws-fleet-instances.html
- 0 kudos
- 2347 Views
- 1 replies
- 1 kudos
Limited number of workspaces vs workspace for department or line of business ?
We are just getting started with databricks currently we have 1 workspace for each environment (DEV, QA and PRD). we have started with 1 workspace but there is already getting flooded with new workspace requests? is there any check list/criteria fo...
- 2347 Views
- 1 replies
- 1 kudos
- 1 kudos
I believe DEV, QA and PRD are the right segregate . We may need this because this will be easy to categorize the production and QA workload - based upon the amount of data cluster processes (Meaning more DBU) which we can restrict by the company work...
- 1 kudos
- 2448 Views
- 1 replies
- 0 kudos
Delta Live Table tables in Data Tab
If I use this code (CREATE STREAMING LIVE TABLE Employee) in dlt pipeline, where does the Employee table gets created by default, if no storage location is specified? How can I create this table in Data tab within a database (a.k.a: Schema) lets say ...
- 2448 Views
- 1 replies
- 0 kudos
- 0 kudos
@Kris Koirala :When you create a streaming live table in Databricks Delta Lake using the code CREATE STREAMING LIVE TABLE Employee, the table is created in the default database called default. If no storage location is specified, the table is stored...
- 0 kudos
- 3449 Views
- 3 replies
- 0 kudos
If I come via Databricks Partner connect and subscribe a partner product then how is the billing done and what api is used for publishing usage information to databricks?
If I come via Databricks Partner connect and subscribe a partner product then how is the billing done and what api is used for publishing usage information to databricks?
- 3449 Views
- 3 replies
- 0 kudos
- 0 kudos
Hi @Atul Karn We haven't heard from you since the last response from @Kaniz Fatma , and I was checking back to see if her suggestions helped you.Or else, If you have any solution, please share it with the community, as it can be helpful to others....
- 0 kudos
- 10782 Views
- 1 replies
- 0 kudos
Spark Streaming: Checkpoint corrupted
Hi Everyone! Today 4 streaming jobs started to fail out of nowhere due to: StreamingQueryException: [STREAM_FAILED] Query [id = ####, runId = ####] terminated with exception: dbfs:/mnt/path/my_table/sources/0/0 doesn't exist (latestId: 8, compactIn...
- 10782 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @Martin Riccardi,We haven't heard from you since the last response from @Kaniz Fatma , and I was checking back to see if her suggestions helped you.Or else, If you have any solution, please share it with the community, as it can be helpful to ot...
- 0 kudos
- 5907 Views
- 2 replies
- 3 kudos
Resolved! How can I set the data access for each SQL warehouse individually?
As far as the official documentation from Microsoft says and I understood it correctly, each SQL warehouse uses the same service principal for data access. But I want to control the access to the data (Azure Data Lake Storage) for each SQL warehouse ...
- 5907 Views
- 2 replies
- 3 kudos
- 3 kudos
It can be done but it's very tricky. You should create a service principal to whom you will grant permission over some tables then you can generate a token using the SP to access only this data.
- 3 kudos
- 19475 Views
- 2 replies
- 0 kudos
How to move from an embedded spark inside a spring boot microservices to azure databricks?
Hi, My question will be more about the architecture solutions and potential implementation of these solutions. The project : Multiple microservices each one deployed on a Tomcat and each Tomcat is running in one of the tree VM existing in Azure...
- 19475 Views
- 2 replies
- 0 kudos
- 0 kudos
My main question is why you use spark in the first place, but that is another discussion.If you want to use databricks, you will have to launch a spark job in one way or another on the databricks cluster with spark-submit or by using the jobs api.How...
- 0 kudos
- 3239 Views
- 0 replies
- 0 kudos
Unity Catalog - Cluster Access Mode - Change Management
Hi all, I am curious to know how you handled change management when rolling out changes to cluster access modes (single user, shared) applicable to UC, especially when there is a centralized platform team offering Infrastructure Deployment services...
- 3239 Views
- 0 replies
- 0 kudos
- 10052 Views
- 2 replies
- 2 kudos
Resolved! What is the advantages and disadvantages of setting up log-delivery at account vs workspace level?
- 10052 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @janaki jagadeesh 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 answ...
- 2 kudos
- 3970 Views
- 2 replies
- 0 kudos
Resolved! Does CVE-2020-13949 (vulnerability) affect the data plane and its security patch is included in Databricks 10.4 LTS?
Here is the previous discussion. https://community.databricks.com/s/question/0D58Y0000ACcIv2SQF/does-thrift-only-exist-in-databrick-control-plane I have the following questions. Does CVE-2020-13949 affect the data plane or not?Do you know from whic...
- 3970 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @Jimin Hsieh Hope everything is going great.Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so w...
- 0 kudos
- 9121 Views
- 0 replies
- 0 kudos
Is CVE-2023-22946 managed by databricks?
Hi Databricks, We want to understand a vulnerability issue - CVE-2023-22946. does this CVE affect Azure databricks users? Does it affect data plane?Is it managed by databricks?Should end users do anything to mitigate it if this issue is a shared ...
- 9121 Views
- 0 replies
- 0 kudos
- 3443 Views
- 1 replies
- 0 kudos
Number of DBU's utilized in Azure
We would like to know the number of DBU's utilized cluster level/workspace level which was hosted in Azure. We were able to see the amount spend but not able to see the DBU's. If we get any idea of no.of DBU's it would help us to think of reserved DB...
- 3443 Views
- 1 replies
- 0 kudos
- 0 kudos
@Mani Teja G we don't have screen like aws for azure, but in azure you can monitor everything in cost management --> cost analysis and select tags as Databricks
- 0 kudos
- 2148 Views
- 1 replies
- 0 kudos
How can I set up a DBU usage alert
Hi,I would like to set up a DBU usage alert, such that I will get an email notification when the DBU usage of last X hour exceeds the budget.How can I do that?Thanks,Kit
- 2148 Views
- 1 replies
- 0 kudos
- 0 kudos
Hello @Kit Yam Tse You can download and analyse usage logs to monitor the DBUs.Check this out: https://docs.databricks.com/administration-guide/account-settings-e2/usage.htmlwe also have usage analysis dashboard notebook:https://docs.databricks.com/...
- 0 kudos
