PacktPublishing / Data-Engineering-with-Apache-Spark-Delta-Lake-and-Lakehouse

Data Engineering with Spark and Delta Lake
MIT License
87 stars 73 forks source link

ADF Pipeline, Stored Procedure Failed #4

Open michaelmiscanuk opened 2 years ago

michaelmiscanuk commented 2 years ago

Hi,

I am trying to run your pipeling from chapter 5 in ADF, but I just cannot make it work through Update watermark Activity.

I am using YOUR pipeline from template (since mine didnt work either, I wanted to try yours provided).

The Failed Message is:

"Cannot create Sql Source. Please double check the connection string, stored procedure are set with correct format. Error: The value of the property 'Value' is invalid for the stored procedure parameter 'LastModifiedtime'."

Since I am quite new to ADF, I am not able to solve it after few hours examining. Can you please help me out?

Thanks

mkukreja1 commented 2 years ago

Call me over WhatsApp and I will try to resolve your error. My number is 1 (647) 464-9563

On Mon, Aug 15, 2022 at 5:08 AM Michael Miscanuk @.***> wrote:

Hi,

I am trying to run your pipeling from chapter 5 in ADF, but I just cannot make it work through Update watermark Activity.

I am using YOUR pipeline from template (since mine didnt work either, I wanted to try yours provided).

The Failed Message is:

"Cannot create Sql Source. Please double check the connection string, stored procedure are set with correct format. Error: The value of the property 'Value' is invalid for the stored procedure parameter 'LastModifiedtime'."

Since I am quite new to ADF, I am not able to solve it after few hours examining. Can you please help me out?

Thanks

— Reply to this email directly, view it on GitHub https://github.com/PacktPublishing/Data-Engineering-with-Apache-Spark-Delta-Lake-and-Lakehouse/issues/4, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABYRIJT5YQS5M3APAJGGJKTVZICJVANCNFSM56RS6NOQ . You are receiving this because you are subscribed to this thread.Message ID: <PacktPublishing/Data-Engineering-with-Apache-Spark-Delta-Lake-and-Lakehouse/issues/4 @github.com>