Explanation:
In Delta Live Tables pipelines, the CREATE LIVE TABLE syntax is used to create a table with SQL. To reference another live table within the pipeline, the LIVE. keyword must be prepended to the table name. Therefore, the correct modification to the query is to use FROM LIVE.sales_cleaned to successfully initiate the DLT pipeline.
Ultimate access to all questions.
No comments yet.
A data engineer has written a query to create a Delta Live Table named sales_aggregated to calculate the total sales per day, referencing another Delta Live Table called sales_cleaned. However, the DLT pipeline fails to start due to an error in the query. Which of the following modifications should be made to the query to successfully initiate the DLT pipeline?
A
CREATE STREAMING LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM sales_cleaned GROUP BY order_date
B
CREATE LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM STREAM(sales_cleaned) GROUP BY order_date
C
CREATE STREAMING TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM LIVE.sales_cleaned GROUP BY order_date
D
CREATE LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM LIVE.sales_cleaned GROUP BY order_date
E
CREATE STREAMING LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM STREAM(sales_cleaned) GROUP BY order_date