Databricks Community is an open-source platform for data enthusiasts and professionals to discuss, share insights, and collaborate on everything related to Databricks. Members can ask questions, share knowledge, and support each other in an environment that ensures respectful interactions.
...ecomes true and hence it becomes a test record. Then with the logic, it gets filtered out by my code and by the time data reaches my sequence_by clause within apply_changes, the recently updated e...
I have want to use the apply_changes feature from a bronze table to a silver table.The bronze table have no "natural" sequence_by column. Therefore, I want to use the CDF column "_commit_timesta...
I have a Personal cluster version 15.4 LTS (includes Apache Spark 3.5.0, Scala 2.12) and a SQL Warehouse in a databricks environment. When I use the following code to create a table in a c...
Hi Team, I have a requirement to trigger a databricks job more than once daily, may be twice or thrice daily. I have checked the workflows but I couldn't find any option in the UI. Please advice
We are using Databricks Asset Bundles (DAB) to orchestrate multiple workflow jobs, each containing multiple tasks. The execution schedules is managed on the job level, i.e., all tasks within a job s...
Hi, In UI I used the pipeline name 00101_source_bronze. I wanted to do the same in the Databricks Asset Bundles. but when the configuration is refreshed against Databricks Workspace I see this ...
We are trying to send a SQL query to the REST API including a BINARY parameter, EX: "INSERT INTO MyTable (BinaryField) VALUES(:binaryData)" We tried to encode the parameter as base64 and specify th...
We are doing POC to migrate SSIS packages to Databricks workflows as part of our effort to build the analytics layer, including dimension and fact tables. How can we accelerate or automate the S...
For example there is a table called "cars", if I remove the table from DLT pipeline and drop the table from catalogue. Now if I change the schema of the table, and create the table again using the sa...