cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

dsugs
by New Contributor II
  • 4811 Views
  • 4 replies
  • 2 kudos

Resolved! I'm curious if anyone has ever written a file to S3 with a custom file name?

So I've been trying to write a file to S3 bucket giving it a custom name, everything I try just ends up with the file being dumped into a folder with the specified name so the output is like ".../file_name/part-001.parquet". instead I want the file t...

  • 4811 Views
  • 4 replies
  • 2 kudos
Latest Reply
rdkarthikeyan27
New Contributor II
  • 2 kudos

Spark feature where to avoid network io it writes each shuffle partition as a 'part...' file on disk and each file as you said will have compression and efficient encoding by default.So Yes it is directly related to parallel processing !!

  • 2 kudos
3 More Replies
igorstar
by New Contributor II
  • 1695 Views
  • 1 replies
  • 1 kudos

What is the difference between LIVE TABLE and MATERIALIZED VIEW?

From the DLT documentation it seems that the LIVE TABLE is conceptually the same as MATERIALIZED VIEW. When should I use one over another?

  • 1695 Views
  • 1 replies
  • 1 kudos
Latest Reply
Anonymous
Not applicable
  • 1 kudos

Hi @igorstar  We haven't heard from you since the last response from @Mo , and I was checking back to see if her suggestions helped you. Or else, If you have any solution, please share it with the community, as it can be helpful to others.  Also, Ple...

  • 1 kudos
scvbelle
by New Contributor III
  • 2603 Views
  • 5 replies
  • 5 kudos

Resolved! Recommended ETL workflow for weekly ingestion of .sql.tz "database dumps" from Blob Storage into Unity Catalogue-enabled Metastore

The client receives data from a third party as weekly "datadumps" of a MySQL database copied into an Azure Blob Storage account container (I suspect this is done manually, I also suspect the changes between the approx 7GB files are very small). I nee...

  • 2603 Views
  • 5 replies
  • 5 kudos
Latest Reply
Anonymous
Not applicable
  • 5 kudos

Hi @Sylvia VB​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers you...

  • 5 kudos
4 More Replies
naga_databricks
by Contributor
  • 3124 Views
  • 4 replies
  • 1 kudos

Resolved! From within a Databricks Notebook, how do you get the workflow and task name

I have a notebook where i want to use the workflow name and task name that it will be running under. How do i access these information?

  • 3124 Views
  • 4 replies
  • 1 kudos
Latest Reply
BilalAslamDbrx
Honored Contributor II
  • 1 kudos

Please take a look at these docs, I think they are what you need: https://docs.databricks.com/workflows/jobs/task-parameter-variables.html

  • 1 kudos
3 More Replies
apiury
by New Contributor III
  • 370 Views
  • 0 replies
  • 0 kudos

Connect NET app to delta table warehouse

Hi! I'm developing a .NET app and i want to use the databricks warehouse as database. I have gold delta tables that i want to query. In the documentation, i can see a ODBC/JDBC driver, are those connector fast? there are another way to connect? what ...

  • 370 Views
  • 0 replies
  • 0 kudos
scbutler1
by New Contributor
  • 298 Views
  • 0 replies
  • 0 kudos

Indexless Indexes

Super excited about learning how AI can help improve performance and throughout for our database customers.

  • 298 Views
  • 0 replies
  • 0 kudos
harripy
by New Contributor III
  • 357 Views
  • 0 replies
  • 0 kudos

AWS Databricks SQL to support TABLE rename

We have been evaluating Databricks SQL and its capability to be used as DW. We are using Unity catalog in our implementation.There seems to be a functionality mismatch between Azure and AWS versions as where table rename is supported on Azure side, i...

  • 357 Views
  • 0 replies
  • 0 kudos
fijoy
by Contributor
  • 822 Views
  • 2 replies
  • 1 kudos

How can I create a table that's visible only to a specific run of a notebook?

I'd like to create an SQL table in a notebook that's visible to a specific run (session?) of a notebook. Meaning, even if 2 different users run that notebook at the same time, there should be no conflict. And the table should go away once the noteboo...

  • 822 Views
  • 2 replies
  • 1 kudos
Latest Reply
igorstar
New Contributor II
  • 1 kudos

For now ‘CREATE TEMPORARY VIEW’ is the way to go. Once you read from it once, the following reads are going to be cached so it won’t be recomputed every time.

  • 1 kudos
1 More Replies
wward9
by New Contributor
  • 383 Views
  • 0 replies
  • 0 kudos

Migrating From Azure Analysis Services To Lakehouse?

Does anyone have any experience migrating a gold layer from Azure Analysis Services (AAS) tabular structure to one centered around the lakehouse architecture? My company currently uses AAS to serve data to all levels of users across the company, but ...

  • 383 Views
  • 0 replies
  • 0 kudos
Jordan2
by New Contributor
  • 192 Views
  • 0 replies
  • 0 kudos

Data+AI summit

Lakehouseiq looks really cool! Lakehouseiq is a Llm agent that builds sql queries from natural language. Ties into their other products like biz context  lineage and previous queries.

  • 192 Views
  • 0 replies
  • 0 kudos
Labels
Top Kudoed Authors