- 1317 Views
- 1 replies
- 1 kudos
Resolved! Data Types - varchar(2147483647)
Hi,when I read a PostgreSQL table containing a custom datatype, it gets translated to VARCHAR(2147483647).I would like to understand how Databricks and Delta handle this scenario. Specifically, does Delta store all the bytes for the maximum length of...
- 1317 Views
- 1 replies
- 1 kudos
- 1 kudos
Hello @yumnus, Delta does not allocate storage for the entire length (2147483647) characters if you only use a portion of it. Instead, Delta stores only the bytes for the actual characters used.
- 1 kudos
- 687 Views
- 1 replies
- 1 kudos
Does Databricks support the password grant type?
Hi,For my azure databricks instance, I am able to generate an access token using client_credentials and authorization_code grant types. I would like to know if Databricks supports the password grant type or not. Is there any document or reference to...
- 687 Views
- 1 replies
- 1 kudos
- 1 kudos
Hello @Syed-SnapLogic, Databricks does not support the password grant type for generating access tokens. The supported grant types for generating access tokens in Databricks are client_credentials and authorization_code. For more information, you can...
- 1 kudos
- 1569 Views
- 3 replies
- 1 kudos
Resolved! Can't access Azure Databricks
Hi,I've been trying to access my notebooks for already 2 hours in Azure Databricks. I have tried different browsers and deleted cookies, restarted computer. I still get the same erro after connecting with SSO (see image bellow)I am in Belgium, but al...
- 1569 Views
- 3 replies
- 1 kudos
- 6933 Views
- 6 replies
- 0 kudos
Is there any better way to manage workflow dependencies using databricks workflows
Looking for solution on how to manage job dependencies using databricks workflows.
- 6933 Views
- 6 replies
- 0 kudos
- 2671 Views
- 4 replies
- 0 kudos
Resolved! how to share a unity PROD catalog to STAGING workspace
Hello Community,I’m looking for a secure way to share a production Unity Catalog with the staging workspace. My goal is to sync data from a schema in the production catalog to the staging workspace, enabling it to read the data and write it into some...
- 2671 Views
- 4 replies
- 0 kudos
- 0 kudos
Hi!A potential solution to your issue could be configuring read-only access to the schema in your production catalog. This approach allows you to securely share the production catalog with your staging workspace while ensuring that users in the stagi...
- 0 kudos
- 3051 Views
- 3 replies
- 0 kudos
Dataframe Count before and after write command do not match
Hi,I have noticed a strange behaviour in a notebook where I am developing. When I use the notebook to read a single file the notebook works correctly, but when I set it to read multiple files at once, using the option recursive lookup, I have noticed...
- 3051 Views
- 3 replies
- 0 kudos
- 0 kudos
I just found out I was populating a column with random variables, these variables are filtered in a join...so at each write and count those numbers change
- 0 kudos
- 887 Views
- 2 replies
- 0 kudos
mongodb ingest data into databricks error
spark = SparkSession.builder \.appName("MongoDBToDatabricks") \.config("spark.jars.packages", "org.mongodb.spark:mongo-spark-connector_2.12:10.4.0") \.config("spark.mongodb.read.connection.uri", mongodb_uri) \.config("spark.mongodb.write.connection.u...
- 887 Views
- 2 replies
- 0 kudos
- 0 kudos
Hello @jeft , will you be able to share some screenshots of the driver logs?
- 0 kudos
- 6246 Views
- 5 replies
- 3 kudos
Show log4j messages in run output
Hi,I have an issue when running JAR jobs. I expect to see logs in the output window of a run. Unfortunately, I can only see messages of that are generated with "System.out.println" or "System.err.println". Everything that is logged via slf4j is only ...
- 6246 Views
- 5 replies
- 3 kudos
- 1868 Views
- 4 replies
- 0 kudos
Failed job with "A fatal error has been detected by the Java Runtime Environment"
Hi community,I have a question regarding an error that I get sometimes when running a job.# # A fatal error has been detected by the Java Runtime Environment: # # SIGSEGV (0xb) at pc=0x00007fc941e74996, pid=940, tid=0x00007fc892dff640 # # JRE versio...
- 1868 Views
- 4 replies
- 0 kudos
- 0 kudos
In the last run there has been additional information in the error message:# # A fatal error has been detected by the Java Runtime Environment: # # SIGSEGV (0xb) at pc=0x00007f168e094210, pid=1002, tid=0x00007f15dd1ff640 # # JRE version: OpenJDK Run...
- 0 kudos
- 7350 Views
- 6 replies
- 3 kudos
Resolved! The best practice to remove old data from DLT pipeline created tables
Hi, didn't find any "reasonable" way to clean old data from DLT pipeline tables. In DLT we have used materialized views and streaming tables (scd1, append only). What is the best way to delete old data from the tables (storage size increases linearly...
- 7350 Views
- 6 replies
- 3 kudos
- 3 kudos
@LasseL 1. Enable Change Data Capture (CDC):Enable CDC before deleting data to ensure Delta tables track inserts, updates, and deletes. This allows downstream pipelines to handle deletions correctly. ALTER TABLE your_table SET TBLPROPERTIES ('delta.e...
- 3 kudos
- 1345 Views
- 1 replies
- 1 kudos
Resolved! Asynchronous progress tracking with foreachbatch
Hello,currently the doc says that async progress tracking is available only for Kafka sink:https://docs.databricks.com/en/structured-streaming/async-progress-checking.htmlI would like to know if it would work for any sink that is "exactly once"?I exp...
- 1345 Views
- 1 replies
- 1 kudos
- 1 kudos
Asynchronous progress tracking is a feature designed for ultra low latency use cases. You can read more in the open source SPIP doc here, but the expected gain in time is in the hundreds of milliseconds, which seems insignificant when doing merge ope...
- 1 kudos
- 723 Views
- 1 replies
- 0 kudos
Catalog Sample Data is not visible with all purpose cluster
Hi All,I need one help even i have the cluster access and i can able to run it attaching with the notebook, still when im going in catalog to see the sample data im able to see an error, Here is the error,@ipriyanksingh , FYRCan anyone please help us...
- 723 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @Krishna2110, Based on the error are you using any token? Ensure that the access token is valid and has not expired. Is your workspace Unity Catalog enabled? and which are your cluster settings to browse through the data?
- 0 kudos
- 2523 Views
- 1 replies
- 0 kudos
#HelpPost for Azure Blob to Databricks connection.
Hi,There is a set of .csv/.txt files in the storage container ie Azure Blob Storage/ Azure Storage Gen 2. I would like to ingest the files to Databricks. Dataset,LinkedServices was created on both ends. Also an all purpose cluster was created in Bric...
- 2523 Views
- 1 replies
- 0 kudos
- 0 kudos
These errors occur when you are not authenticated / properly authorized to access the storage account. Ensure that you've set proper storage credential configurations, and that those credentials have proper access. Documentation here.
- 0 kudos
- 1573 Views
- 2 replies
- 0 kudos
start another workflow waiting the completion of a job-run of the same workflow
Hello community,I'm using DABs I want to know if It is possible to configure the yaml file a logic that allows me to run a workflow if the previous job run is finished of the same workflow. Is it possible to do it? Do I need to create a task that che...
- 1573 Views
- 2 replies
- 0 kudos
- 0 kudos
Hello @jeremy98, Yes, it is possible to configure a YAML file to run a workflow only if the previous job run of the same workflow has finished. You can achieve this by defining dependencies between tasks within the workflow. You can specify task depe...
- 0 kudos
- 1471 Views
- 2 replies
- 0 kudos
Databricks workflow job
Hi team,I am trying to execute a workflow job which takes in a parameter as unique identifier. I am using this job parameter to push down to tasks. I was hoping if there is any way for me to use python uuid4() function to generate unique id every tim...
- 1471 Views
- 2 replies
- 0 kudos
- 0 kudos
hi ctiwari7A possible way to do that, you create a python file which generates the uuid and then pass it to jobs.taskValues. This is described here: https://docs.databricks.com/en/jobs/task-values.html As test, I created a python file, with the follo...
- 0 kudos
| User | Count |
|---|---|
| 1644 | |
| 792 | |
| 553 | |
| 349 | |
| 287 |
