Categories: AutomationSalesforce Marketing CloudSQL Queries

Clearing a Data Extension with a SQL Query

If you ever need an automated way to clear a data extension, you can simply use a SQL query that does an overwrite. The query doesn’t need a from clause if you specify any required columns in the target.

For example, if EmailAddress is required in the target data extension, simply set the value to null and add an alias:

See the gist on github.
Share
Published by
Adam Spriggs

Recent Posts

  • technology & science

Chevy big block 396 rebuild

https://www.youtube.com/watch?v=z5U5Kxrv6SY Good stuff from Hagerty's #RedlineRebuild series.

6 hours ago
  • sports

Giannis for MVP

3 weeks ago
  • fun
  • technology & science

Artificial Intelligence

4 weeks ago
  • peeves

JUST DON’T

JUST DON'T schedule a meeting for me without checking to see if I'm available JUST DON'T repeatedly propose something to…

1 month ago
  • API
  • Salesforce Marketing Cloud

Triggering Multiple Emails with REST

If you need to trigger one Marketing Cloud email to multiple recipients in a single REST API call, here's how…

1 month ago
  • technology & science

Excavating

https://www.youtube.com/watch?v=RE_dSJh5bvQ via Little Giants Construction Company

3 months ago