Run SQL Queries in Automation Studio | Automation Studio Activities

Описание: #salesforce
#trailhead
#salestraining

Automation Studio Activities

After completing this unit, you’ll be able to:

Insert SQL into an SQL Query activity.
Use the available sample SQL queries.
Validate and implement SQL queries in Automation Studio.
SQL Query Activity
The SQL Query activity requires more attention than the others, simply because it’s so customizable and open-ended. This activity lets you write your own SQL queries and place them in an activity to run immediately or on a schedule.

This query burrows into your data extensions or data views, retrieves the information specified in your query, and inserts that information into a new data extension for further use. Exactly what information goes into that data extension depends on how you construct your query.

If you’re familiar with SQL, you know how powerful and resource-intensive some queries can be. If you’re not familiar with SQL—trust us, SQL queries can tie up a lot of processing if you’re going through a ton of data. That’s why it’s important to familiarize yourself with our guidelines on how to write your queries. Ultimately, it’s about narrowing your query’s scope as much as possible, segmenting queries that might produce a lot of information, and limiting your request to the previous six months of data.

Put SQL to Work
Let’s take a look at how you can implement your SQL Query activity. Navigate to Automation Studio in Marketing Cloud and create a new automation, then follow these steps.