- 1974 Views
- 3 replies
- 0 kudos
I am using Databricks in Azure. I want to mount ADLS Gen2 on Databricks and create unmanged (external) tables on the mount point. But before that I want to know which will give best performance, is it Managed table (stores data in DBFS root)or Un-ma...
- 1974 Views
- 3 replies
- 0 kudos
Latest Reply
Hi @Paramesh Malla Thank you for your question! To assist you better, please take a moment to review the answer and let me know if it best fits your needs.Please help us select the best solution by clicking on "Select As Best" if it does.Your feedba...
2 More Replies
- 7589 Views
- 3 replies
- 0 kudos
00007160: 2023-01-30T14:22:06 [TARGET_LOAD ]E: Failed (retcode -1) to execute statement: 'COPY INTO `e2underwriting_dbo`.`product` FROM(SELECT cast(_c0 as INT) as `ProductID`, _c1 as `ShortName`, cast(_c2 as INT) as `Status`, cast(_c3 as TIMESTA...
- 7589 Views
- 3 replies
- 0 kudos
Latest Reply
we have solved this issue related to Qlik replicate copying data into delta table
2 More Replies
by
Trey
• New Contributor III
- 3302 Views
- 2 replies
- 6 kudos
Hi all!I would like to use a managed delta table as a temporal table, meaning:to create a managed table in the middle of ETL processto drop the managed table right after the processThis way I can perform merge, insert, or delete oprations better than...
- 3302 Views
- 2 replies
- 6 kudos
Latest Reply
@Kwangwon Yi Instead of performance, main issue with managed table is whenever you delete table, data under that table gets deleted.If you have good use case on Reporting, best approach is to go with external storage location to store your managed t...
1 More Replies
by
JohnB
• New Contributor II
- 3225 Views
- 1 replies
- 1 kudos
The scenario is "A substaincial amount of data needs to be moved from a legacy Databricks that has Managed Tables, to a new E2 Databrick. The new bucket will be a dedicated Datalake rather than the Workspace Bucket so they will be External Tables."U...
- 3225 Views
- 1 replies
- 1 kudos
Latest Reply
Hey there @John Brandborg Hope everything is going great! Just wanted to check in if you were able to resolve your issue would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to ...
