- 3612 Views
- 1 replies
- 2 kudos
Built-In Governance for Your Databricks Workspace
Databricks Unity Catalog simplifies data and AI governance by providing a unified solution for organizations to securely discover, access, monitor, and collaborate on a range of data and AI assets. This includes tables, ML models, files and functions...
- 3612 Views
- 1 replies
- 2 kudos
- 2 kudos
Thank you for sharing this @Sujitha
- 2 kudos
- 2516 Views
- 1 replies
- 1 kudos
DLT Medallion Incremental Ingestion Pattern Approach
Hi there, I have a question regarding what would be the "recommended" incremental ingestion approach using DLT to pull raw landing data into bronze and then silver? The original approach I've been considering is to have raw CSV files arrive in a land...
- 2516 Views
- 1 replies
- 1 kudos
- 2456 Views
- 1 replies
- 0 kudos
Databricks SQL Identifier Variables
Hi all.Just trying to implement adb sql scripts using identifier clause but I have errors like that using an example:DECLARE mytab = 'tab1'; CREATE TABLE IDENTIFIER(mytab) (c1 INT);The feature is not supported: Temporary variables are not yet support...
- 2456 Views
- 1 replies
- 0 kudos
- 0 kudos
@RobsonNLPT - The feature development is still in place. Just the docs are released prior to the feature availability which is an usual process. The feature will be released on preview channel with a tentative ETA on Feb 20 as of now. Alternatively...
- 0 kudos
- 1789 Views
- 0 replies
- 0 kudos
databricks data engineer associate exam I missed retake exam
Hi Team,I had a written exam on Jan 2nd, 2024 but I failed the exam with 65% I misunderstood I needed to take the exam after 14 days.I have missed the chance. Could you please give me a chance to write exam.email:tudururavikiran@gmail.comThanks & Reg...
- 1789 Views
- 0 replies
- 0 kudos
- 2676 Views
- 0 replies
- 0 kudos
Foreign catalogs aren't populated.
I've created connections to various RDS Aurora databases but always get the same problem - when creating a foreign catalog only the information_schema database is shown in Catalog Explorer. The AI chat agent has made a few ways to specify the databa...
- 2676 Views
- 0 replies
- 0 kudos
- 2069 Views
- 0 replies
- 0 kudos
https://groups.google.com/g/ibm.software.network.directory-integrator/c/9ubZOuHJob4/m/JQAdpv5qAgAJ
https://feedback.azure.com/d365community/idea/e7289e29-26b4-ee11-92bc-000d3a037f01https://docs.google.com/document/d/1gVBMFUqZaVteXs9-DbZQmH1CYHajWe3EhU_h3MV4S-s/edithttps://support.google.com/looker-studio/thread/253656391https://bemorepanda.com/en/...
- 2069 Views
- 0 replies
- 0 kudos
- 2012 Views
- 1 replies
- 0 kudos
Can only connect from tableau cloud using Compute Cluster
We are trying to connect tableau cloud to databricks. We have a serverless sql warehouse and a pro warehouse, both of those warehouses are not able to connect.Can’t connect to DatabricksDetailed Error Message There was an unknown connection error to...
- 2012 Views
- 1 replies
- 0 kudos
- 0 kudos
@questions - It seems the current catalog is set to empty. can you please change the default catalog name to hive_metastore ?
- 0 kudos
- 1532 Views
- 1 replies
- 0 kudos
Data view in Side Panel
Does anyone know why I cannot see the Data view in the side panel under workspace. I see catalog instead of data. Is this something that has been upgraded?
- 1532 Views
- 1 replies
- 0 kudos
- 0 kudos
@DB_Keith - Data Explorer is renamed to catalog Explorer. Please refer to the release notes. https://learn.microsoft.com/en-us/azure/databricks/release-notes/product/2023/september#data-explorer-is-now-catalog-explorer
- 0 kudos
- 1496 Views
- 1 replies
- 0 kudos
Parsed Logical Plan report UnresolvedHint RANGE_JOIN
I'm new to RANGE_JOIN so this may be completely normal, but I'd like confirmation.Whenever I put a RANGE_JOIN hint in my query SELECT /*+ RANGE_JOIN(pr2, 3600) */ event.FirstIP4Record FROM SCHEMA_NAME_HERE.dnsrequest event INNER JOIN SC...
- 1496 Views
- 1 replies
- 0 kudos
- 0 kudos
@hukel - The query above does not have a range join, the range filter is not a join condition and it is evaluated as a regular filter. Please refer to the criteria on range join optimization for joins. Have a condition that can be interpreted as ...
- 0 kudos
- 2604 Views
- 1 replies
- 1 kudos
DataFrame vs. Spark SQL
When should I use DataFrame over Spark SQL?If DataFrame is better, then why do I need Spark SQL?
- 2604 Views
- 1 replies
- 1 kudos
- 1 kudos
@SamAWS - when you want to query the underlying data in the dataframe by creating a view or table, Spark SQL is preferred. Same can be achieved using pyspark by retaining them as a dataframe. Spark SQL is used by wider audience and easy to develop.
- 1 kudos
- 1418 Views
- 1 replies
- 0 kudos
Unable to create a Unity Catalog
https://accounts.azuredatabricks.net/data/createI am unable to access the above link to start with Unity Catalog.
- 1418 Views
- 1 replies
- 0 kudos
- 0 kudos
Are you an account admin? If you access to https://accounts.azuredatabricks.net/ are you able to see the console or just the workspaces that are currently available for you?
- 0 kudos
- 1972 Views
- 1 replies
- 0 kudos
Is it possible to view Databricks cluster metrics using REST API
I am looking for some help on getting databricks cluster metrics such as memory utilization, CPU utilization, memory swap utilization, free file system using REST API.I am trying it in postman using databricks token and with my Service Principal bear...
- 1972 Views
- 1 replies
- 0 kudos
- 0 kudos
There is currently no option available to get this metrics available through API, but is coming soon.
- 0 kudos
- 3601 Views
- 1 replies
- 1 kudos
Unable to reconstruct state at version ? as the transaction log has been truncated
We have a small table, which undergoes a merge operation on a daily basis. This causes that currently the table has 83 versions.When trying to query this table, we receive the following error: DeltaFileNotFoundException: dbfs:/mnt/XXXXX/warehous...
- 3601 Views
- 1 replies
- 1 kudos
- 1 kudos
It is difficult to say exactly what caused the issue as there are multiple underlying reasons. But as a general advice, you can try setting the "delta.checkpointRetentionDuration=7 days" and also you can try switching to a different DBR version to se...
- 1 kudos
- 2839 Views
- 1 replies
- 0 kudos
- 2839 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @Databricks_Work , Vacuum and Analzye are two separate commands that are used for optimizing the queries but they perform two different operations. Vacuum is used to clear the stale data files in your delta table. Vacuum should be run after a opti...
- 0 kudos
- 2924 Views
- 4 replies
- 0 kudos
Need reattempt to Certified Data Engineer Associate
Hello Team/ @Cert-Team ,I encountered Pathetic experience while attempting my 1st DataBricks certification. My exam got suspended within 10min after starting my exam. Abruptly, Proctor asked me to show my desk, walls, room, wallet, id card, adapter,...
- 2924 Views
- 4 replies
- 0 kudos
