cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

PrData05
by New Contributor II
  • 6968 Views
  • 5 replies
  • 1 kudos

dbfs rest api - Access denied on dbfs rest api call but access works in dataricks notebook

Hello, We are trying to interact with dbfs to upload files and list files in dbfs directory ( we are tring to upload files in volumes ). Although we have necessary permissions on databricks, we are still getting permission denied when we are making r...

Data Engineering
dbfs api
dbfs rest api
REST API
  • 6968 Views
  • 5 replies
  • 1 kudos
Latest Reply
sgdnp
New Contributor II
  • 1 kudos

I am experiencing the same issue as well. Any ideas about how we can upload to volumes using the api? Tried both the /api/2.0/dbfs/put and the streaming apis (/api/2.0/dbfs/create,/api/2.0/dbfs/add-block,/api/2.0/dbfs/close) but no luck so getting it...

  • 1 kudos
4 More Replies
YevheniiY
by New Contributor II
  • 11740 Views
  • 1 replies
  • 0 kudos

Empty xml tag

 <ItemMaintenance> <Batch> <BathInfo>info</BathInfo> <Item attr1="tekst" attr2="Tekst2"> <ItemId type="Type" id="id"/> <Dates> <Start>2023-11-09</Start> <End>2024-01-02</End> </Dates> <MoreData> More data </MoreData> <...

Data Engineering
empty xml tag
public preview
XML
xml auto loader
xml read
  • 11740 Views
  • 1 replies
  • 0 kudos
Learnit
by New Contributor II
  • 9323 Views
  • 1 replies
  • 0 kudos

Databricks Vs ADLS for reporting.

Hi everyone, I'm a business analyst currently facing a decision on how best to develop a report. I need to choose between using Databricks or Azure Data Lake Storage (ADLS) as the data source on the transformed data in csv or excel file format from d...

  • 9323 Views
  • 1 replies
  • 0 kudos
Latest Reply
Palash01
Valued Contributor
  • 0 kudos

Hey @Learnit I'd be glad to help, thanks for posting your concern. To offer the most effective advice, I might need some additional context about your specific situation as looks like your use case is to create reports (dahboards) using local CSV/exc...

  • 0 kudos
Nixon
by New Contributor II
  • 908 Views
  • 1 replies
  • 0 kudos

Resonable long running time

Hi there, I have a block of code which can be executed around a month ago within 20 mins. But I came back recently and try to execute it again. It takes over 50 minutes still cannot complete (finally got kick out). Any advise and hints is appreciated...

  • 908 Views
  • 1 replies
  • 0 kudos
Latest Reply
Nixon
New Contributor II
  • 0 kudos

Haha...    Should be "unreasonable long" 

  • 0 kudos
vsharma
by New Contributor
  • 3695 Views
  • 3 replies
  • 0 kudos

Where to move cluster-init scripts after latest message (Storing initialization scripts on DBFS is being deprecated. We recommend using a different storage location)?

Recently Databricks has started showing "Storing initialization scripts on DBFS is being deprecated. We recommend using a different storage location" . Is there an alternative of still keep using DBFS or do we need to move to ABSFS ? I could not find...

  • 3695 Views
  • 3 replies
  • 0 kudos
Latest Reply
vkeziv
New Contributor II
  • 0 kudos

It is suggested that we can use Workspace but databricks CLI not supporting importing shell scripts, but we can import shell script using web page? 

  • 0 kudos
2 More Replies
bergmaal
by New Contributor III
  • 3307 Views
  • 2 replies
  • 1 kudos

Workflows 7 second delay between tasks

When you have a job in Workflows with multiple tasks running after one another, there seems to be a consistent 7 seconds delay between execution of the tasks. Or, more precisely, every task has an approximate 7 second overhead before the code actuall...

Data Engineering
delay
overhead
tasks
Workflows
  • 3307 Views
  • 2 replies
  • 1 kudos
Latest Reply
JensH
New Contributor III
  • 1 kudos

Hi @bergmaal , I am experiencing the same issue.My Databricks consultant suggested opening a support ticket as this should not be normal behavior.Did you solve this issue yet?We observed these delays do not seem to occur in workflows that use noteboo...

  • 1 kudos
1 More Replies
NotARobot
by New Contributor III
  • 2930 Views
  • 1 replies
  • 1 kudos

Delta Live Tables UDFs and Versions

Trying to do a url_decode on a column, which works great in development, but running via DLT fails when trying multiple ways.1. pyspark.sql.functions.url_decode - This is new as of 3.5.0, but isn't supported using whatever version running a DLT pipel...

  • 2930 Views
  • 1 replies
  • 1 kudos
Latest Reply
NotARobot
New Contributor III
  • 1 kudos

Thanks @Retired_mod, for reference if anybody finds this, the DLT release docs are here: https://docs.databricks.com/en/release-notes/delta-live-tables/index.htmlThis shows which versions are running for CURRENT and PREVIEW channels. In this case, wa...

  • 1 kudos
KrzysztofPrzyso
by New Contributor III
  • 13665 Views
  • 2 replies
  • 0 kudos

Shared job clusters on Azure Data Factory ADF

Hi Databricks Community,If only possible I would like to use Shared Jobs Cluster on external orchestrator like Azure Data Factory (ADF) or Synapse Workspace.The main reasons for using Shared Job cluster are:reduction of start-up time (<1min vs 5 min ...

  • 13665 Views
  • 2 replies
  • 0 kudos
Latest Reply
KrzysztofPrzyso
New Contributor III
  • 0 kudos

Hi Sai Kumar,Many thanks for your response.Unfortunately using analytical clusters is not really an option for for me due to cost differences between job clusters and analytical clusters.Job cluster also offer assurance that the latest deployed versi...

  • 0 kudos
1 More Replies
prasad95
by New Contributor III
  • 12170 Views
  • 3 replies
  • 1 kudos
Data Engineering
Delta Lake
  • 12170 Views
  • 3 replies
  • 1 kudos
Latest Reply
saikumar246
Databricks Employee
  • 1 kudos

Hi, @prasad95 Thank you for sharing your concern here.  In addition to the @Retired_mod comments you can follow below To capture Change Data (CDC) from DynamoDB Streams and write it into a Delta table in Databricks: 1. Connect to DynamoDB Streams and...

  • 1 kudos
2 More Replies
User16752245312
by Databricks Employee
  • 6451 Views
  • 3 replies
  • 2 kudos
  • 6451 Views
  • 3 replies
  • 2 kudos
Latest Reply
Aria
New Contributor III
  • 2 kudos

We are using azure.I dont see an option for deployment name. Secondly, we have already deployed all our workspaces and wants to have user friendly URLs.Like some changes in DNS server or proxy URLs.

  • 2 kudos
2 More Replies
Kaizen
by Valued Contributor
  • 3170 Views
  • 2 replies
  • 0 kudos

Copy Local file using a Shared Cluster

Hi, I am saving some files locally on my cluster and moving them after my job. These are log files of my process so I cant directly reference a DBFS location. However the dbutils.fs.cp command does not work on the shared cluster. This does however wo...

  • 3170 Views
  • 2 replies
  • 0 kudos
Latest Reply
Kaizen
Valued Contributor
  • 0 kudos

For reference when doing this on a single user (personal) cluster - the file is store in:/databricks/driver/logs.txt Which has no issue accessing and copying to dbfs after using the dbutil commands

  • 0 kudos
1 More Replies
thethirtyfour
by New Contributor III
  • 8773 Views
  • 2 replies
  • 1 kudos

Resolved! Install R Package "sf"

Hi,I am trying to install the following four dependency packages in order to install "slu-openGIS/postmastr" directly from GitHub:unitssftigristidycensusWhen attempting to install "units", I received the following configuration error: %r install.pack...

  • 8773 Views
  • 2 replies
  • 1 kudos
Latest Reply
thethirtyfour
New Contributor III
  • 1 kudos

Thank you!

  • 1 kudos
1 More Replies
jcozar
by Contributor
  • 8218 Views
  • 5 replies
  • 2 kudos

Resolved! CDC and raw data

Hi, I am using debezium server to send data from Postgres to a Kafka topic (in fact, Azure EventHub). My question is, what are the best practices and recommendations to save raw data and then implement a medallion architecture?For clarification, I wa...

  • 8218 Views
  • 5 replies
  • 2 kudos
Latest Reply
jcozar
Contributor
  • 2 kudos

Thank you very much @Palash01 ! It has been really helpful!

  • 2 kudos
4 More Replies
rt-slowth
by Contributor
  • 4968 Views
  • 3 replies
  • 0 kudos

Error : . If you expect to delete or update rows to the source table in the future.......

Flow 'user_silver' has FAILED fatally. An error occurred because we detected an update or delete to one or more rows in the source table. Streaming tables may only use append-only streaming sources. If you expect to delete or update rows to the sourc...

  • 4968 Views
  • 3 replies
  • 0 kudos
Latest Reply
Palash01
Valued Contributor
  • 0 kudos

Hey @rt-slowth Just checking in if the provided solution was helpful to you. If yes, please accept this as a Best Solution so that this thread can be considered closed.

  • 0 kudos
2 More Replies
rt-slowth
by Contributor
  • 13667 Views
  • 5 replies
  • 0 kudos

Questions about the design of bronze, silver, and gold for live streaming pipelines

I'm envisioning a live streaming pipeline.The bronze, or data ingestion, is being fetched using the directory listing mode of the autoloader.I'm not using File Notification Mode because I detect about 2-300 data changes per hour.I'm thinking about im...

Data Engineering
Delta Live Table
spark
  • 13667 Views
  • 5 replies
  • 0 kudos
Latest Reply
Palash01
Valued Contributor
  • 0 kudos

Hey @rt-slowth Thank you for sharing the code snippets. The code structure appears to be on the right track, and its dynamic nature is promising. With a few minor adjustments, it should achieve the desired outcome. Also, find the attached code syntax...

  • 0 kudos
4 More Replies

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now
Labels