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

arul_parthiban
by New Contributor
  • 1406 Views
  • 0 replies
  • 0 kudos

How to customize the result of COPY INTO command?

COPY INTO statement produces results in following format, which is more similar to INSERT INTO statement results; also it's a summary of all the files loaded. Is there a way to customize in way that it produces the detailed results at file level?

image
  • 1406 Views
  • 0 replies
  • 0 kudos
Fairy
by New Contributor
  • 1811 Views
  • 0 replies
  • 0 kudos

Error in Loading VDS to Dremio

Hi, I am getting this error increasingly while loading VDS to Dremio. Do you know how I can avoid it?Out[144]: {'statusCode': 400, 'headers': {'Content-Type': 'application/json'}, 'body': 'Failed - SYSTEM ERROR: UnsupportedOperationException: Additio...

  • 1811 Views
  • 0 replies
  • 0 kudos
stryde
by New Contributor
  • 1687 Views
  • 0 replies
  • 0 kudos

Doubts Databricks

Hey FolksI'm configuring citrix Secure Private Access ( https://docs.citrix.com/en-us/citrix-secure-private-access.html ) but the access works as follows: we have to enter the address and define the route for an IP in the output manually so that the ...

Screen Shot 2022-09-22 at 6.43.37 PM
  • 1687 Views
  • 0 replies
  • 0 kudos
Hello1
by New Contributor II
  • 1467 Views
  • 1 replies
  • 0 kudos

burpsuite

<script>alert(1)</script>

  • 1467 Views
  • 1 replies
  • 0 kudos
Latest Reply
Hello1
New Contributor II
  • 0 kudos

"><img src=x onerror=alert(1)>

  • 0 kudos
Chris_Shehu
by Valued Contributor III
  • 2483 Views
  • 3 replies
  • 5 kudos

Anyone have any luck with Kafka? Any links, documents, videos that helped?

I'm trying to ingest streaming HL7 messages and planned to use Kafka with Smolder to achieve this. I'm having a little trouble understanding how Kafka can run on databricks. So far I've installed Kafka and started the cluster but the start command ju...

  • 2483 Views
  • 3 replies
  • 5 kudos
Latest Reply
Chris_Shehu
Valued Contributor III
  • 5 kudos

@Jose Gonzalez​  Sorry for the delay. I've actually already looked at the provided links. The first one is for AWS. I'm currently using Azure. The KAFKA setup is working..I think? I'm stuck at ok so I have a server listening now what? How do I send/r...

  • 5 kudos
2 More Replies
Mado
by Valued Contributor II
  • 1789 Views
  • 1 replies
  • 3 kudos

Resolved! How to specify directory when reading table?

Hi, Assume that I have created several tables in Databricks workspace. If two tables have similar names but stored in different folders, how I can read them by "spark.read.table". I ask this question because input to the "spark.read.table" is only ta...

  • 1789 Views
  • 1 replies
  • 3 kudos
Latest Reply
Hubert-Dudek
Databricks MVP
  • 3 kudos

spark.read.table reads table registered in catalog/metastore. If you have multiple databases in metastore, just prefix table name with database name db.table

  • 3 kudos
Anonymous
by Not applicable
  • 3642 Views
  • 2 replies
  • 2 kudos

Data source V2 streaming is not supported on table acl or credential passthrough clusters

Using:( hostname is hidden )kafka = spark.readStream\    .format("kafka")\    .option("kafka.sasl.mechanism", "SCRAM-SHA-512")\    .option("kafka.security.protocol", "SASL_SSL")\    .option("kafka.sasl.jaas.config", f'org.apache.kafka.common.security...

  • 3642 Views
  • 2 replies
  • 2 kudos
Latest Reply
Hubert-Dudek
Databricks MVP
  • 2 kudos

With TACL enabled cluster, you got many restrictions, so streaming will not work. Generally, you can read only things registered in metastore; please disable it for your use case,Additionally, remember that the unity catalog doesn't support streaming...

  • 2 kudos
1 More Replies
colt_hubbartt
by Databricks Employee
  • 908 Views
  • 0 replies
  • 2 kudos

www.linkedin.com

Calling all Data Engineers! If you’re looking to join the most iconic brand in STL as they transform how business decisions are made then this Bud is for you!https://www.linkedin.com/posts/colt-hubbartt-90578b13_senior-data-engineer-activity-69783757...

  • 908 Views
  • 0 replies
  • 2 kudos
isultano
by New Contributor II
  • 6685 Views
  • 4 replies
  • 1 kudos

Where did the settings button move to - where is the admin console?

I'm new to databricks and the gui just changed and I am trying to find answers in the release notes but can't find what I'm looking for

  • 6685 Views
  • 4 replies
  • 1 kudos
Latest Reply
isultano
New Contributor II
  • 1 kudos

I have found the Administrator Console. It is in the top right under my name. My ui is different.Thanks community for your support. I am a junior on this product.

  • 1 kudos
3 More Replies
HariharaSam
by Databricks Partner
  • 14660 Views
  • 3 replies
  • 4 kudos

Performance Tuning of Databricks Notebook

Hi Everyone ,I am trying to run a databricks notebook in parallel using ThreadPoolExecutor .Can anyone suggest how to reduce the time taken based on the below findings so far.Current Performance:Time taken - 25 minutes ThreadPoolExecutor max_workers ...

  • 14660 Views
  • 3 replies
  • 4 kudos
Latest Reply
Hubert-Dudek
Databricks MVP
  • 4 kudos

ThreadPoolExecutor will not help as Databricks/Spark will process job by job.So please analyze in Spark UI what is consuming the most time.There are a lot of tips on how to optimize they depend on the dataset (size etc. transformations)Look for data ...

  • 4 kudos
2 More Replies
noimeta
by Contributor III
  • 5431 Views
  • 2 replies
  • 4 kudos

Resolved! Adjust label size in SQL visualization

Hi,Anyone knows if there's a way to adjust the font size of label in the SQL visualization? Our dashboard users complain that it's too small.

  • 5431 Views
  • 2 replies
  • 4 kudos
Latest Reply
susodapop
Databricks Employee
  • 4 kudos

It's on our radar to make this customisable in the future. For now, browser zoom as suggested by @debayan is the suggested workaround.

  • 4 kudos
1 More Replies
rahul08yadav
by New Contributor III
  • 5743 Views
  • 2 replies
  • 4 kudos

Error while writing Data Frame from Azure Databricks to Azure synapse Dedicated Pool

I am reading delta tables from my Databricks workspace as DF and then I am trying to write this DF into Azure Synapse Dedicated SQL Pool, but I am getting error like:-Py4JJavaError: An error occurred while calling o1509.save. : com.databricks.spark.s...

  • 5743 Views
  • 2 replies
  • 4 kudos
Latest Reply
rahul08yadav
New Contributor III
  • 4 kudos

The issue was getting created because I was passing SAS Token for setting the configuration for Storage Account instead of Storage Access Key. It's working now without any issue..spark.conf.set("fs.azure.account.key.datalakestorage.dfs.core.windows.n...

  • 4 kudos
1 More Replies
newmetrocity
by New Contributor
  • 1027 Views
  • 0 replies
  • 0 kudos

The Nova City Islamabad, is an upcoming and emerging housing project in the federal capital. This project aims to target all budget genres of people o...

The Nova City Islamabad, is an upcoming and emerging housing project in the federal capital. This project aims to target all budget genres of people of Pakistan. In the future, this project is going to compete with the mega projects of Islamabad, Pak...

  • 1027 Views
  • 0 replies
  • 0 kudos
Labels