- 1714 Views
- 2 replies
- 0 kudos
Is there a way to see Job/Workflow in the lineage of a table/view
Hi allOne frequent question I get from the data users is - how often a view is refreshed? ((users are given access to views not tables))I was thinking to guide them to leverage lineage for the same. However, I noticed the lineage tab in the catalog e...
- 1714 Views
- 2 replies
- 0 kudos
- 0 kudos
@Vidhi_Khaitan the user wants to know the frequency of the schedule, not whether the view/table is fresh...
- 0 kudos
- 1165 Views
- 1 replies
- 0 kudos
Job Runs Permissions for Runs Submit API via ADF
I wanted to assign group permissions to Job runs in Azure Databricks which are triggered from ADF via Runs Submit API.How can we assign Job Runs Permissions in Azure Databricks for ADF triggers by Runs Submit API?
- 1165 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @hajojko ,Good Day!I believe this is what you can try for your use case - https://docs.databricks.com/api/workspace/jobs_21/submit#access_control_list
- 0 kudos
- 1393 Views
- 1 replies
- 0 kudos
Databricks compute failed to start due to EC2 security group id change in AWS default VPC
I have been using Databricks on AWS for almost 2 years. Recently, I cannot start up Databricks compute. "databricks_error_message": "The VM launch request to AWS failed, please check your configuration. [details] InvalidGroup.NotFound: The se...
- 1393 Views
- 1 replies
- 0 kudos
- 0 kudos
hey @sg-vtc You need to register a new network configuration in Databricks that points to the updated VPC and security group. Here’s how:- Go to the Databricks Account Console (not the workspace UI). (Click in workspaces dropbox and Manage Account)- ...
- 0 kudos
- 560 Views
- 1 replies
- 0 kudos
Costs incurred by systems table usage
Doc about system tables says "The billable usage and pricing tables are free to use. Tables in Public Preview are also free to use during the preview but could incur a charge in the future."https://learn.microsoft.com/en-us/azure/databricks/admin/sys...
- 560 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @alsetr ,The billable usage and pricing system tables are the clearly marked as free to use.Tables in Public Preview are also free for now.For the rest, there’s no mention of a direct cost, but you’ll still be billed for the compute (DBUs) used wh...
- 0 kudos
- 1750 Views
- 3 replies
- 1 kudos
Using logged in user's identity in Databricks Apps
Hi Databricks Community, I recently started using Datbricks apps where I list some schemas and tables in the UI.What I explicitly want to do is only show the schemas and tables on which user actually have permission. Currently the databricks apps wou...
- 1750 Views
- 3 replies
- 1 kudos
- 1 kudos
https://docs.databricks.com/aws/en/dev-tools/databricks-apps/auth#retrieve-user-authorization-credentials : they launched this recently to support user identity in databricks apps
- 1 kudos
- 1373 Views
- 1 replies
- 0 kudos
Custom hostname for Azure Databricks workspace
For a client it's required that all applications use a subdomain of an internal hostname. Does anyone have a suggestion on how to achieve this? Options could be in the line of CNAME or Reverse Proxy, but couldn't get that to work yet.Does Azure Datab...
- 1373 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @gt-ferdyh, Azure Databricks doesn’t natively support custom subdomains. However, to make it accessible via an internal subdomain, you can:Enable Azure Private Link for your Databricks workspace.In your internal DNS, create an A record or CNAME th...
- 0 kudos
- 1439 Views
- 2 replies
- 0 kudos
Resolved! "Aws Invalid Kms Key State" when trying to start new cluster on AWS
Hey,We just established new environment based on AWS. Our first step was to create Cluster but while doing so, we have encountered an error. We tried different policies, configurations and instance types. All resulted in:Aws Invalid Kms Key State: Th...
- 1439 Views
- 2 replies
- 0 kudos
- 1175 Views
- 2 replies
- 2 kudos
Databricks Logs
I’m trying to understand the different types of logs available in Databricks and how to access and interpret them. Could anyone please guide me on:What types of logs are available in Databricks?Where can I find these logs?How can I use these logs to ...
- 1175 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @APJESK,In addition, job logs are very useful to monitor and troubleshoot any job failures. They can be found under Workflows. Workspace admins role is required to have full access on all jobs unless explicitly granted to the user by Job Owner/adm...
- 2 kudos
- 2352 Views
- 3 replies
- 2 kudos
Resolved! Clarification on Databricks Access Modes: Standard vs. Dedicated with Unity Catalog
Hello,I’d like to ask for clarification regarding the access modes in Databricks, specifically the intent and future direction of the “Standard” and “Dedicated” modes.According to the documentation below:https://docs.databricks.com/aws/ja/compute/acc...
- 2352 Views
- 3 replies
- 2 kudos
- 1438 Views
- 2 replies
- 0 kudos
Have authenticator app set up but databricks still resorts to email mfa
Good monring,I set up an authenticator app through settings, profile, mfa. However, when I logout and log back into the workspace, I am still only getting the email verification to get in. Is there a way I can turn off email verification or have it d...
- 1438 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi, @andreapeterson Do you have Account Admin privileges?If you do, you can enforce MFA from the account console, just as shown in the attached image.If you’re using the Databricks Free Edition rather than a paid account, you can’t enforce MFA. This ...
- 0 kudos
- 1435 Views
- 1 replies
- 0 kudos
- 1435 Views
- 1 replies
- 0 kudos
- 0 kudos
hey @prakash4 I understand you're having trouble connecting to a remote server / getting your Databricks workspace to start. Would you be able to share a little more detail to help track down your issue?Specifically:- What happens when you try to sta...
- 0 kudos
- 643 Views
- 1 replies
- 3 kudos
Resolved! Cost of SQL Warehouse scaled to 0 clusters
A SQL Warehouse can be scaled to a minimum of 0.Presumably, there is still a cost to keeping the resource active, because we also have Auto-Stop which can completely stop the warehouse after a configurable amount of time.This cost is not documented. ...
- 643 Views
- 1 replies
- 3 kudos
- 3 kudos
1. Just to clarify, minimum is 1, not 0. See https://docs.databricks.com/api/workspace/warehouses/create#min_num_clusters 2. How it works is based on concurrency. Assuming your max clusters is 2, and based on the concurrency, we don't need the 2nd cl...
- 3 kudos
- 1516 Views
- 2 replies
- 2 kudos
Resolved! JJDBC Insert Performance and Unsupported Data Types
We are reaching out regarding two observations with the Databricks JDBC driver:We’ve noticed that each INSERT query is taking approximately 1 second to execute via the JDBC driver (please refer to the attached screenshot). This seems unusually slow f...
- 1516 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @ankit_kothiya1 Please find below my findings for your query 1. Slow INSERT Performance via Databricks JDBC Driver Observation:Each INSERT query takes about 1 second via the Databricks JDBC driver, which is unusually slow for high-throughput use ...
- 2 kudos
- 1142 Views
- 2 replies
- 0 kudos
Guidance on Populating the cloud_infra_cost Table in System Catalog
In the system catalog, there are three tables: cloud_infra_cost, list_prices, and usage. While the list_prices and usage tables contain cost-related information, the cloud_infra_cost table is currently empty. I am using AWS cloud. Can anyone provide ...
- 1142 Views
- 2 replies
- 0 kudos
- 0 kudos
I am opted in for the features in preview but I dont see any data in this table
- 0 kudos
- 985 Views
- 3 replies
- 1 kudos
Principals given access to and their owners
Hi allIn a large global data platform built with Azure Databricks, I like to know the best practice of how we maintain the users to which Databricks objects (typically views) have been access to, for example - a view has been given access to a servic...
- 985 Views
- 3 replies
- 1 kudos
- 1 kudos
@noorbasha534 - I created a helper function/script to do this in my environment that queries the Unity Catalog system tables to generate a unique list of impacted principals/users. It takes in a list of fully qualified object names and will display ...
- 1 kudos
