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

Pratibha
by New Contributor II
  • 1942 Views
  • 2 replies
  • 0 kudos

which cluster/worker/driver type is best for analytics work?

which cluster/worker/driver type is best for analytics work?

  • 1942 Views
  • 2 replies
  • 0 kudos
Latest Reply
jacovangelder
Databricks MVP
  • 0 kudos

Analytics work as in querying and analyzing data? Preferably using Databricks SQL? If so, then a SQL Warehouse is your best friend. 

  • 0 kudos
1 More Replies
kiko_roy
by Contributor
  • 3534 Views
  • 5 replies
  • 2 kudos

Resolved! Delta sharing open protocol in Unity catalog: FileNotFoundError

Hi TeamI have created a recipient under delta sharing (azure databricks) . Unity catalog is enabled and data is stored in ADLS gen2. I have downloaded the credential file and trying to resue in my python script (as per databricks documentation) for a...

  • 3534 Views
  • 5 replies
  • 2 kudos
Latest Reply
jacovangelder
Databricks MVP
  • 2 kudos

I wasn't able to reproduce your issue. Is your delta table operable? can you see sample data from within databricks and query the table from within databricks? It almost looks like some parquet files are missing, causing your delta not queryable anym...

  • 2 kudos
4 More Replies
medha
by New Contributor
  • 1167 Views
  • 1 replies
  • 0 kudos

Issues with Common Data Model as Source - different column size for blobs

I have a Dataverse Synapse link set up to extract data into ADLS gen2. I am trying to connect ADLS gen2 as the data source to read the data files in Databricks. I have CDC enabled for CDM Data with the partition of Year and Month.So, for example, if ...

  • 1167 Views
  • 1 replies
  • 0 kudos
Latest Reply
jacovangelder
Databricks MVP
  • 0 kudos

This is a thoughtful consideration, but have you considered using .option("mergeSchema", "true") when writing?Do keep in mind that this will affect the target table and possible downstream consumers. Ideally you want to have strict a schema contract ...

  • 0 kudos
maskepravin02
by New Contributor II
  • 3644 Views
  • 2 replies
  • 0 kudos

Resolved! How can we connect to 2 different hive spark.hadoop.hive.metastore.uris

We need to read a table from 2 different spark.hadoop.hive.metastore.uris and do some validations.We are not able to connect to both spark.hadoop.hive.metastore.uris at the same time using sparkSession.I will be using Spark version: 3.1.1 and the lan...

  • 3644 Views
  • 2 replies
  • 0 kudos
Latest Reply
ashraf1395
Honored Contributor
  • 0 kudos

Hi there @maskepravin02,We have once implemented this approach of two reading two different hive metasores, but it was not on AWS and GCP, maybe the docs can help.Though it is not recommended The best approach is to create separate spark applications...

  • 0 kudos
1 More Replies
pt07
by New Contributor
  • 1037 Views
  • 1 replies
  • 0 kudos

how do i pass the value from one task in the workflow to another task?

how do i pass the value from one task in the workflow to another task? #worksflow #orchestration 

  • 1037 Views
  • 1 replies
  • 0 kudos
Latest Reply
brockb
Databricks Employee
  • 0 kudos

Hi @pt07 ,    This may be what you're looking for. Can you please take a look? https://www.databricks.com/blog/2022/08/02/sharing-context-between-tasks-in-databricks-workflows.html  

  • 0 kudos
subashdsouza
by New Contributor
  • 1326 Views
  • 1 replies
  • 0 kudos
  • 1326 Views
  • 1 replies
  • 0 kudos
Latest Reply
mhiltner
Databricks Employee
  • 0 kudos

Delta Uniform is the way to go at the moment: https://www.databricks.com/blog/delta-lake-universal-format-uniform-iceberg-compatibility-now-ga In one word, tables are written in Delta but have compatibility with Iceberg as they will also save iceberg...

  • 0 kudos
Peter-M
by New Contributor II
  • 4458 Views
  • 3 replies
  • 2 kudos
  • 4458 Views
  • 3 replies
  • 2 kudos
Latest Reply
mhiltner
Databricks Employee
  • 2 kudos

You could have a workflow with two tasks, one being a "trigger checker" that could be a super light task scheduled to run every X hours/minutes. This first task would check for your different triggers and define a success criteria for your next task....

  • 2 kudos
2 More Replies
Husainyusuf
by New Contributor
  • 954 Views
  • 1 replies
  • 0 kudos

DataAIsummit 2024

Having a wonderful learning experience and sharing experience and knowledge with fellow data engineers/scientists/architects

  • 954 Views
  • 1 replies
  • 0 kudos
Latest Reply
Ryangough37
New Contributor II
  • 0 kudos

Interesting use cases so far. Looking forward ot the sessions tomorrow!

  • 0 kudos
301444
by New Contributor
  • 794 Views
  • 0 replies
  • 0 kudos

dbr

overwhelming and need to learn a lot

  • 794 Views
  • 0 replies
  • 0 kudos
Kaviprakash_S
by New Contributor III
  • 3490 Views
  • 3 replies
  • 1 kudos

SQL compilation error while connecting to snowflake from Databricks

Hi All,I'm trying to connect to the snowflake database from databricks notebook either to read the data or write the data. However I'm getting an weird error. The code and error are provided as follows, snowflake_table = (spark.read  .format("snowfla...

Kaviprakash_S_0-1717986833387.png
  • 3490 Views
  • 3 replies
  • 1 kudos
Latest Reply
Kaviprakash_S
New Contributor III
  • 1 kudos

@Retired_mod Could you please help with this ? 

  • 1 kudos
2 More Replies
jsperson
by New Contributor III
  • 760 Views
  • 0 replies
  • 0 kudos

Partition Pruning with Non-Delta Files

Howdy - first time caller here.I'm trying to figure out how/if partition pruning works with non-CSV files. I have files landing in bronze in physical partitions of the form dlk_load_dtm=<load date time>. I'd like to load the partitions that don't yet...

  • 760 Views
  • 0 replies
  • 0 kudos

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