- 3028 Views
- 2 replies
- 1 kudos
I would like to know why I am getting this error when I tried to earn badges for lakehouse fundamen
I would like to know why I am getting this error when I tried to earn badges for lakehouse fundamentals. I can't access the quiz page. Can you please help on this?Getting below error:-403FORBIDDENYou don't have permission to access this page2023-08-...
- 3028 Views
- 2 replies
- 1 kudos
- 8487 Views
- 2 replies
- 0 kudos
Resolved! how to set jobs permission with rest api
create job with cli, but can not set the permission with cli,have to use rest api to set permission:https://docs.databricks.com/api/workspace/permissions/setbelow is my command in windows to set permission:curl -X PUT https://my-workspace-url.azureda...
- 8487 Views
- 2 replies
- 0 kudos
- 0 kudos
thank you, the new permission list should be a whole list, not the new permission
- 0 kudos
- 1085 Views
- 0 replies
- 0 kudos
the function base64 has issue with function aes_encrypt and secret
for the below query:select base64( aes_encrypt( '00', to_binary(secret('secret-scope', 'data-protection-secret'), 'BASE64') ) )when the value to encrypt is 2 characters, the return is always "REDACTED_POSSIBLE_SECRET_ACC...
- 1085 Views
- 0 replies
- 0 kudos
- 1451 Views
- 0 replies
- 0 kudos
Looking for Upload file to dbfs using "/api/2.0/dbfs/put"
Hello,I am trying to upload the file from local linux machine to dbfs using request.post(<URI>,<Headers>, params={"path": "dbfs:/tmp", "contents": local_path}) and getting the error b'{"error_code":"INVALID_PARAMETER_VALUE","message":"You must provid...
- 1451 Views
- 0 replies
- 0 kudos
- 2940 Views
- 2 replies
- 1 kudos
Backup/Export Databricks SQL Column Comments
We've had users make comments on tables/columns throughout Databricks SQL using the Data Explorer UI. I'm looking for a way to backup these comments, but when I run DESCRIBE TABLE, the comment column is always null despite being non-null in Data Expl...
- 2940 Views
- 2 replies
- 1 kudos
- 1 kudos
@804082 - Markdown does not render when returned by DESCRIBE statements. we can view them on the Data Explorer UI.Reference: https://docs.databricks.com/en/data/markdown-data-comments.html#document-data-with-markdown-comments
- 1 kudos
- 1443 Views
- 1 replies
- 0 kudos
Databricks Job RUns API
/api/2.1/jobs/runs/list Currently returns all jobs which got executed within specified time lines which we provide as input. Is There any way where we can get only specific jobs as per their status(only success)?
- 1443 Views
- 1 replies
- 0 kudos
- 0 kudos
@venkat94 thanks for the feedback. We are working on updating the Jobs Runs API so you can filter runs by status e.g. only success. Stay tuned in the next couple of months.
- 0 kudos
- 2056 Views
- 1 replies
- 0 kudos
Re-running DLT Pipeline Does Not Add Data After Delete
I am using DLT and unity catalog and using managed tables. The first table in this pipeline is a live streaming table. I first did this in the SQL editor:DELETE FROM my_table;This appears to have deleted all the records, which I wanted since now when...
- 2056 Views
- 1 replies
- 0 kudos
- 0 kudos
@Mo is correct!
- 0 kudos
- 2213 Views
- 0 replies
- 0 kudos
SQL Merge condition
Hi guys I have a question regarding this merge step and I am a new beginner for Databricks, trying to do some study in data warehousing, but couldn't figure it out by myself. need your help with it. Appreciate your help in advance. I got this questi...
- 2213 Views
- 0 replies
- 0 kudos
- 2590 Views
- 1 replies
- 0 kudos
Azure Shared Clusters - P4J Security Exception on non-whitelisted classes
When I try to use a third party JAR on an Azure shared cluster - which is installed via Maven and I can successfully import - , I get the following message: py4j.security.Py4JSecurityException: Method public static org.apache.spark.sql.Column com.da...
- 2590 Views
- 1 replies
- 0 kudos
- 0 kudos
Thanks Kaniz.I must use a shared cluster because I'm reading from a DLT table stored in a Unity Catalog.https://docs.databricks.com/en/data-governance/unity-catalog/compute.htmlMy understanding is that shared clusters are enforcing the Py4J policy I ...
- 0 kudos
- 3375 Views
- 3 replies
- 1 kudos
Delta live table UC Kinesis: options overwriteschema, ignorechanges not supported for data sourc
I try to build a DLT in UC with Kinesis as producer.My first table looks like: @dlt.create_table( table_properties={ "pipelines.autoOptimize.managed": "true" }, spark_conf={"spark.databricks.delta.schema.autoMerge.enabled": "true"},)def feed_chu...
- 3375 Views
- 3 replies
- 1 kudos
- 1 kudos
If you use the "Preview" Channel in the "Advanced" section of the DLT Pipeline, this error should resolve itself. This fix is planned to make it into the "Current" channel by Aug 31, 2023
- 1 kudos
- 2891 Views
- 0 replies
- 0 kudos
Delta Live Tables maintenance schedule
I have a DLT that runs every day and an automatically executed maintenance job that runs within 24 hours every day. The maintenance operations are costly, is it possible to change the schedule to once a week or so?
- 2891 Views
- 0 replies
- 0 kudos
- 5736 Views
- 3 replies
- 3 kudos
Resolved! DLT failure: ABFS does not allow files or directories to end with a dot
In my DLT pipeline outlined below which generically cleans identifier tables, after successfully creating initial streaming tables from the append-only sources, fails when trying to create the second cleaned tables witht the following:It'**bleep** cl...
- 5736 Views
- 3 replies
- 3 kudos
- 3 kudos
Hi @scvbelle The error message you're seeing is caused by an IllegalArgumentException error due to the restriction in Azure Blob File System (ABFS) that does not allow files or directories to end with a dot. This error is thrown by the trailingPeriod...
- 3 kudos
- 28635 Views
- 5 replies
- 2 kudos
Resolved! DBFS and Local File System Doubts
Dear Databricks Expert,I got some doubts when dealing with DBFS and Local File System.Case01: Copy a file from ADLS to DBFS. I am able to do so through the below python codes:#spark.conf.set("fs.azure.account.auth.type", "OAuth") spark.conf.set("fs.a...
- 28635 Views
- 5 replies
- 2 kudos
- 2 kudos
Hi @KS LAU​ 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 answers your q...
- 2 kudos
- 13288 Views
- 1 replies
- 0 kudos
AnalysisException: [ErrorClass=INVALID_PARAMETER_VALUE] Missing cloud file system scheme
I am trying to follow along Apache Spark Programming training module where the instructor creates events table from a parquet file like this:%sql CREATE TABLE IF NOT EXISTS events USING parquet OPTIONS (path "/mnt/training/ecommerce/events/events.par...
- 13288 Views
- 1 replies
- 0 kudos
- 0 kudos
@Retired_mod Thanks for your response. I didn't provide cloud file system scheme in the path while creating the table using DataFrame API, but I was still able to create the table. %python # File location and type file_location = "/mnt/training/ecom...
- 0 kudos
- 13044 Views
- 7 replies
- 4 kudos
Resolved! Change Databricks Community User Name
How do I change my Databricks Community user name?
- 13044 Views
- 7 replies
- 4 kudos
- 4 kudos
Hi Sujitha,Thanks for the quick help! I cleaned the caches, and it works now.
- 4 kudos
| User | Count |
|---|---|
| 1629 | |
| 790 | |
| 511 | |
| 349 | |
| 287 |
