Data Extension Extract in Automation Studio

Note Using a standard data extension extract doesn't guarantee that the extracted rows are in the same order they were inserted. To enforce a specific order, create a custom extract.

The Data Extension extract type requires this information in the fields section:

• The character you want to use to delimit each column. The default is a comma, but you can enter tab for a tab-delimited file or | for a pipe-delimited file.
• For DECustomerKey, enter the data extension’s external key.
• HasColumnHeaders determines whether the extract file includes column headers.
• TextQualified determines whether text within the data extension appears within double quotation marks.
• UsesLineFeed determines whether a new line is generated based on the field selected in the data extension.

Create a file transfer activity and select Move a File From Safehouse as the File Action. Add the name of the file from the data extension data extract in the File Naming Pattern field to move the extract to another file location.

Note Make sure to use the same file naming pattern for the file transfer activity that you use when setting up the data extension extract using the data extract activity.

Save both the data extract and the file transfer activity. Then, create an automation that includes the data extract as the first step with the file transfer activity next. You can run the automation one time or set it to run at scheduled times. Use third-party FTP software to move the file from your chosen file location to your computer.