Adding a query to a datamart

About this task

If there is a predefined datamart based on the query, the predefined datamart output structure may not exactly match the query definition. For example, the predefined datamart Export:Full SQL does not have the field Original Timezone, but the predefined query Export:Full SQL does have the field. If you create a new datamart based on the query, it matches the query structure.

Procedure

  1. In the Query Name row, click Datamart.
    The Datamart Configuration dialog opens.
  2. Select an existing datamart, or click New to create a new datamart.
  3. Configure the extraction and click Apply.