- 10821 Views
- 2 replies
- 1 kudos
Resolved! Unity Catalog - Lakehouse Federation: Permission to read data from foreign catalogs
I have seup connection "SQL-SV-conn" to SQL Server and based on that connection I have created foreign catalog "FC-SQL-SV".I have granted All permission on CATALOG to developers:Use CatalogUse SchemaSelectBut they can not query table (e.g. by running...
- 10821 Views
- 2 replies
- 1 kudos
- 1 kudos
OK, I have found out the answer in below docummentation:https://learn.microsoft.com/en-us/azure/databricks/query-federation/#limitationsSingle-user access mode is only available for users that own the connection.So when I use e.g. Job Cluster that ru...
- 1 kudos
- 4332 Views
- 0 replies
- 1 kudos
Workspace Model Registry with Unity Catalog
if the "default catalog for the workspace" is to Unity Catalog, how can we access a model from the workspace model registry?I have already tried mlflow.set_tracking_uri("databricks") but still try to find catalog in UC.
- 4332 Views
- 0 replies
- 1 kudos
- 3149 Views
- 0 replies
- 0 kudos
Specify cidr when using aws quick start template
Hello,I want to create a new databricks workspace using aws quick start template. However, I want to specify a cidr address that is specified by our network administration. Is it possible to do that. From what I read, the quick start template does no...
- 3149 Views
- 0 replies
- 0 kudos
- 7382 Views
- 1 replies
- 1 kudos
Resolved! Security and vulnerability for Azure databricks clusters in Data Plane
Microsoft defender is not supported for azure databricks clusters. Can someone point me to a document which describe how the security vulnerabilities are reported and fixed for azure databricks clusters in data plane.
- 7382 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi Aria,can you check this link?Basically Databricks checks for vulnerabilities and does pentesting etc."Databricks will use commercially reasonable efforts to address critical vulnerabilities within 14 days, high severity within 30 days, and medium ...
- 1 kudos
- 4235 Views
- 1 replies
- 0 kudos
Automatic UC enablement with existing Unity Catalog
Hello,The environment I'm working in has an existing account and unity catalog in our primary region. These have been primarily PoC, and have existed for a year or so.Now we're building out our IaC and getting ready to move towards production. In new...
- 4235 Views
- 1 replies
- 0 kudos
- 3706 Views
- 1 replies
- 0 kudos
Connect to Salesforce
Curious if there's a Databricks connector for Salesforce on AWS?
- 3706 Views
- 1 replies
- 0 kudos
- 0 kudos
There is no "databricks" connector like the on you have in Unity Fedarating e.g. for Snowflake.You can use partner ecosystem e.g. Fivetran https://www.fivetran.com/connectors/salesforceto integrate Salesforce data to your Lakehouse. You also have spa...
- 0 kudos
- 4818 Views
- 1 replies
- 1 kudos
How to allocate costs per SQL query?
By using System Tables (systen.billing.usage) I'm able to identity DBU usage per query, but I'm not able to identify who ran each query because is not part of the table. I'm also aware of query history where all the queries and who ran them is listed...
- 4818 Views
- 1 replies
- 1 kudos
- 1 kudos
thanks @Retired_mod for the reply, however query_id is not part of the system.billing.usage table, so no way to join them by IDs. What my Databricks account team suggested me is to join them by timestamps since both tables contain a column like that....
- 1 kudos
- 5944 Views
- 2 replies
- 0 kudos
NPIP tunnel setup failure during launch
In AWS with this current error when spinning up the SQL warehouse or personal compute.Backend private link is enabled.Error: NPIP tunnel setup failure during launch. Please try again later and contact Databricks if the problem persists. Instance boot...
- 5944 Views
- 2 replies
- 0 kudos
- 0 kudos
Hello, Thanks for contacting Databricks Support. Based on the error message: NPIP_TUNNEL_SETUP_FAILURE. It indicates that bootstrap failed due to network connectivity issues between the data plane and control plane. Seems like you have already dow...
- 0 kudos
- 2173 Views
- 0 replies
- 0 kudos
Error running history command twice using DeltaTable
Hi I'm using Unity Catalog on Azure with a Managed Identity connected to my Storage Account. I can read and write data without issues, and interact with data using pyspark and SQL.I can display the history by running a cell with the following code:fr...
- 2173 Views
- 0 replies
- 0 kudos
- 6004 Views
- 2 replies
- 1 kudos
How to monitor a python wheel job with Prometheus?
Hi Community,We have a Databricks job with a single Python wheel task that runs our streaming pyspark job. The job runs on a single-node compute cluster and consumes from Kafka.Our monitoring stack is Prometheus + Grafana.I want the job's metrics to ...
- 6004 Views
- 2 replies
- 1 kudos
- 1 kudos
Hi I'm trying to use the metrics registry object inside an UDF function, but I can't because it's not serializable due to Lock. Our goal is to be able to count the number of messages parsed, and the number of messages we can't parsed (due to exceptio...
- 1 kudos
- 1845 Views
- 0 replies
- 0 kudos
Handling Kafka Topics with Avro Schema
Our input data resides in a Kafka topic, and we utilize the Kafka schema registry with Avro schemas. While I can retrieve the schema from the registry, I am facing challenges creating a Spark DataFrame that correctly serializes data for streaming rea...
- 1845 Views
- 0 replies
- 0 kudos
- 1371 Views
- 0 replies
- 0 kudos
Scalable API/binary lookups
We sometimes process large dataframes that contain a column of IP addresses and we need to associate an Autonomous System Number (ASN) per IP address. The ASN information is provided by MaxMind in the form of a binary data file only accessible via a ...
- 1371 Views
- 0 replies
- 0 kudos
- 2920 Views
- 0 replies
- 0 kudos
auto-deleted workspace on GCP
Our production Databricks workspaces were auto-deleted when our subscription from our GCP account was canceled due to system error. We have a backup of the GCS buckets that Databricks was running on (not workspace exports). Is it possible to recove...
- 2920 Views
- 0 replies
- 0 kudos
- 2616 Views
- 1 replies
- 0 kudos
Databricks Private link connectivity for External SaaS Application
We need your guidance on completing the set-up around private link set-up with a Customer who is in the same region in AWS where our application is hosted in AWS. Our Customer has already enabled Private Link in their account and they are using custo...
- 2616 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi Databricks Support,We followed the instructions above, but we are getting an error when registering the endpoint in customer databricks environment using "Registering Endpoint".Following is the error message we see:"INVALID_PARAMETER_VALUE" Endpoi...
- 0 kudos
- 3162 Views
- 1 replies
- 0 kudos
When to add Users Groups or SPs from Account to Workspace
Hi community We are using Unity Catalog, SCIM and Identity Federation, so we have users, groups and service principals at Account level. In what scenarios do users, groups and service principals need explicitly added to a Workspace?
- 3162 Views
- 1 replies
- 0 kudos
- 0 kudos
1. If you enable Unity Catalog in a workspace, users in that workspace may be able to access the same data that users in other workspaces in your account can access. Data guardians can control who has access to what data across all workspaces from on...
- 0 kudos
