- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2022 10:52 AM
Hi DB Support,
Can we use DB's Delta Lake as our Target DB? Here's our situation...
- We have hundreds of ETL jobs pulling from these Sources. (SAP, Siebel/Oracle, Cognos, Postgres) .
- Our ETL Process has all of the logic and our Target DB is an MPP system.
- We have MSTR and Tableau for reporting.
Can we use Databrick's Delta Lake to replace our "Target DB"? We have over a thousand tables and views on top so a conversion tool is great to have? Does Databrick have an easier way to replace our MPP "Target DB"? Target DB can be a redshift, postgre, sqlserver or other mpp db.
Can you advise? Please send reply via email.
Thank you!
-william
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-20-2022 02:42 AM
Hi yes you can the best is to create sql endpoint in premium workspace and just write to delta lake as to sql.
This is community forum not support. You can contact databricks via https://databricks.com/company/contact or via AWS, Azure if you have support plan there (is the fastest)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-20-2022 02:42 AM
Hi yes you can the best is to create sql endpoint in premium workspace and just write to delta lake as to sql.
This is community forum not support. You can contact databricks via https://databricks.com/company/contact or via AWS, Azure if you have support plan there (is the fastest)

