Add External Data to the Marts

Owned by Kavitha Thangaswamy (Unlicensed)
Last updated: Jul 25, 2023 by Pamela Totas (Deactivated)
1 min read

You may need to access data within the Mart schema that cannot be created within any Mart model. The two options you can consider are:

  • Creating a new table within the schema that can be joined to Mart tables in SQL statements within reporting tools. PACE does not recognize such a table, but another application can.

  • Creating a view within the schema that can access data that resides outside it.