Export full tables to the cloud full-table-export

You can apply an existing tag to the export or you can create a new tag and apply it.

To apply an existing tag to the export, select any tags from the drop-down menu. Any tags in your company are available to apply.

To create a new tag, type the name of the new tag, then press Enter.

Consider the following when applying tags to an export:

• Tags that you apply can be filtered on or searched for in the exports table.
• Tags applied to a project are not automatically applied when exporting a full table, as described in “Configure columns on the exports page” in Manage exports. (Alternatively, when scheduling a full project for export, any tags applied to the project are automatically applied to the export.)

Select the data view that contains the components that you want to include in the export. The Data view drop-down menu is located in the upper-left corner of the dialog.

Note: If you select a data view that is missing components that are already included in your data table, then you are prompted to clear and re-create the panel using components that are included in the selected data view.

Displays the Freeform table that you are exporting. You can modify the data structure by dragging components from the left panel to the table. You can apply a filter by dragging a component into the filter area. The table dynamically updates as you add components to the canvas. You can include up to 10 columns.

Any segments that were applied to the full table in the project appear above the table. You can apply a segment or group of segments to an export.

Select the reporting time-frame to include in each export file. Options include Today, Yesterday, Last 7 days, Last 30 days, This week, and This month.

This option is not displayed when the Export frequency is set to Send now (one-time).

Choose whether the exported data should be in .csv, .json, or .parquet format.

When choosing the Parquet file format, any of the following characters included in component names are replaced with an underscore (_):

• ’ ’ - ASCII space
• ‘,’ - ASCII comma
• ‘;’ - ASCII colon
• ‘{’ or ‘}’ - ASCII open/close brace
• ‘(’ or ‘)’ - ASCII open/close parenthesis
• ‘\n’ - ASCII newline
• ‘\t’ - ASCII tab
• ‘=’ - ASCII equals

When enabled, a manifest file is included with any successful export delivery.

The manifest file enables you to confirm that all files were delivered successfully. It includes the following information:

• A list of all files that were delivered
• The MD5 checksum of each file

Exported data is available as a compressed file in the cloud destination that you configured, as described in Configure cloud export accounts and Configure cloud export locations.

The filename of the compressed file is as follows, depending on whether you chose csv, json, or parquet as the file format:

• cja-export-{reportInstanceId}-{idx}.csv.gz

• cja-export-{reportInstanceId}-{idx}.json.gz

• cja-export-<instanceId>-<idx>.snappy.parquet

  Each column in the parquet file is compressed.

Choose the file format in the File format field above.

Set the schedule for how often the export should occur.

You can choose Send now (one-time) to send the export only once. When you select this option, the export is initiated immediately.

Or, you can choose to send the export on a defined schedule. When sending on a schedule, options include Daily, Weekly, Monthly by day of the week, Monthly by day of the month, Yearly by day of the month, and Yearly by specific date.

When selecting an export frequency, consider the following:

• The options in the Lookback window field change depending on what you select here.
• Additional configuration fields display depending on the option that you choose.

The day and time that the scheduled export should begin.

This option is available only when choosing a scheduled export frequency.

The day and time that the scheduled export expires. The scheduled export no longer runs after the date and time that you set.

This option is available only when choosing a scheduled export frequency.

Select the cloud export account where you want the data to be sent.

Or, if you haven’t already configured a cloud account that you want to use, you can configure a new account:

1. In the Account drop-down menu, select Add account, then specify the following information:

   • Location account name: Specify a name for the location account. This name appears when creating a location
   • Location account description: Provide a short description of the account to help differentiate it from other accounts of the same account type.
   • Make account available to all users in your organization: Select this option if you want to allow other users in your organization to use the account.
   • Account type: Select the type of cloud account you are exporting to. Available account types are Amazon S3 Role ARN, Google Cloud Platform, Azure SAS, Azure RBAC, Snowflake, and AEP Data Landing Zone.

2. To finish configuring your account, continue with the link below that corresponds to the Account type you selected:

   • AEP Data Landing Zone
   • Amazon S3 Role ARN
   • Google Cloud Platform
   • Azure SAS
   • Azure RBAC
   • Snowflake

Select the location on the account where you want the export data to be sent.

Or, if you haven’t already configured a cloud account that you want to use, you can configure a new account:

1. In the Location drop-down menu, select Add location, then specify the following information:

   • Name: The name of the location.
   • Description: Provide a short description of the location to help differentiate it from other locations on the account.
   • Make location available to all users in your organization: Select this option if you want to allow other users in your organization to use the location.
   • Location account: Select the account where you want to create the location.

2. To finish configuring your location, continue with the link below that corresponds to the account type that you selected in the Location account field:

   • AEP Data Landing Zone.
   • Amazon S3 Role ARN
   • Google Cloud Platform
   • Azure SAS
   • Azure RBAC
   • Snowflake