How to Create a Query Activity
Before you begin this procedure, you must create the data extension to contain the results of the query. After you complete this procedure, you can start the activity or include the activity in a program.
Use the following steps to create a query activity:
1. Click the Interactions tab on the navigation bar.
2. Click Activities.
3. Click Query.
The Queries workspace appears.
4. Click Create from the toolbar.
5. Complete the information in the Properties section:
Name - The name of the activity. You use this name to identify the activity in the application. Subscribers cannot see the name.
Key - A value you choose that uniquely identifies the activity. You use this value to identify the activity when using the API.
Description - The description of the activity. You use this description to further help identify the activity within the application. Subscribers cannot see the description.
Query - The SQL that makes up the query. You can click the Check Syntax button to check your SQL.
6. Complete the information in the Target section:
Select data extension to populate - The data extension to contain the result of the query.
Update Type - Determines how the system updates the data extension with new data. Value values include:
. Overwrite - The system deletes the existing records in the data extension and adds the results of the query.
. Update - The system updates the existing records in the data extension with information that results from the query and appends non-matching records.
. Append - The system adds the results of the query to the data extension after the existing records.
7. Click Save.