I really thought that I would only benefit from the advanced classes as I already use SFMC SQL on the day to day, but since Cam content is so enjoyable I decided to fully commit to this classes and let me tell that I've learned something new and so usefull today that I'm just amazed. That draging the DE atributes to the query blowed my mind. Tks Cam
Great content Cam! Makes light work of the concepts and easy to follow steps in SFMC Automation Studio for beginner SQL. Love the way you structured and explained the lesson too. Looking forward to watching and learning more.
If the data action chosen is "Update" and not Append or Overwrite - Can you explain what the word "matching" means - how does the query know to match on which field etc?
Following this process exactly, I get the following error: "Error saving the Query field.Update Type must be 'Update' or the target data extension 'Learning_1' cannot appear in the query." When I Run Once, 0 records populate in the target data extension. I am not sure what I've done wrong?
I really thought that I would only benefit from the advanced classes as I already use SFMC SQL on the day to day, but since Cam content is so enjoyable I decided to fully commit to this classes and let me tell that I've learned something new and so usefull today that I'm just amazed. That draging the DE atributes to the query blowed my mind. Tks Cam
Great content Cam! Makes light work of the concepts and easy to follow steps in SFMC Automation Studio for beginner SQL. Love the way you structured and explained the lesson too. Looking forward to watching and learning more.
Such clear explanations buddy! You get the ability to turn any concept fun and easy and that's amazing, thanks for sharing your knowledge 😄
Thankyou for the wonderful sessions Robert❤
Thank you for this content, it was great following along and finally using SQL in SFMC. I learned a lot thanks again for this.
Great content on SFMC SQL
THANK YOU SO MUCH
it requires to have a primary key for each data extension. Is there a way to avoid not using it? or is this how the MC is set up for my org? Thanks
If the data action chosen is "Update" and not Append or Overwrite - Can you explain what the word "matching" means - how does the query know to match on which field etc?
Instead of Top 5, I need all records on the DESC order, is this possible there?
Yep. You can write:
SELECT TOP 100%
Following this process exactly, I get the following error: "Error saving the Query field.Update Type must be 'Update' or the target data extension 'Learning_1' cannot appear in the query."
When I Run Once, 0 records populate in the target data extension. I am not sure what I've done wrong?
check your target DE primary key, if the DE not having primary key, it wont work