- 12032 Views
- 3 replies
- 3 kudos
Resolved! What are differences between Materialized view and Streaming table in delta live table?
Hi,I was wondering that what are differences between Materialized view and Streaming table? which one should I use when I extract data from bronze table to silver table since I found that both CREATE LIVE TABLE and CREATE STREAMING LIVE TABLE could a...
- 12032 Views
- 3 replies
- 3 kudos
- 3 kudos
Hi @Mike Chen​ 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 feedback wi...
- 3 kudos
- 10439 Views
- 2 replies
- 2 kudos
Resolved! Doing a a join within the same row in SQL
My data is a dump of JSON response from an API. The schema of the json iscol_name data_type data array<struct<attributes:struct<name: String, age: Int relationships:struct<address:struct<data:arraay<struct<id: long, type: string>>>>>>> ...
- 10439 Views
- 2 replies
- 2 kudos
- 2 kudos
My data is a dump of JSON response from an API. The schema of the json iscol_name data_type data array<struct<attributes:struct<name: String, age: Int relationships:struct<address:struct<data:arraay<struct<id: long, type: string>>>>>>> ...
- 2 kudos
- 3947 Views
- 3 replies
- 1 kudos
Error while trying to implement Change Data Capture
Hi All,I'm new to databricks and learning towards taking up Associate Engineer Certification.While going through the section "Build Data Pipelines with Delta Live Tables". I'm trying to implement Change Data Capture, but it is erroring out when execu...
- 3947 Views
- 3 replies
- 1 kudos
- 1 kudos
Having had a quick look, I think your error is because you are trying to add SCD to a STREAMING LIVE table. I believe APPLY CHANGES INTO cannot be used on a streaming table.You can use a streaming table as a source though.Simply changing this line:C...
- 1 kudos