> For the complete documentation index, see [llms.txt](https://resources.unizin.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://resources.unizin.org/policies/support-policy/unizin-data-warehouse-sp.md).
# Unizin Data Warehouse - SP
**Last updated: August 27, 2019**
This document is an amendment to Unizin's general [Support Policy](/policies/support-policy.md).
The information contained in this policy applies to Unizin Data Warehouse (UDW) only.
## Scope of support
The Unizin Data Warehouse is a data store hosted in Unizin cloud infrastructure. It hosts [Canvas Data](https://portal.inshosteddata.com/docs), a data service offered by Instructure. The UDW Support Policy extends only to the provisioning and availability of the data store used to host Canvas Data. Unizin does not provide tools or custom tool development to access the UDW. Unizin cannot assure the quality, availability, or any other assurance regarding the Canvas Data Service.
The Unizin Data Warehouse supports ODBC, JDBC and direct-access client tools to access the UDW. Unizin cannot provide technical support for the client tools selected by Members to access their UDW, but will attempt to assist when possible. To troubleshoot connection issues, Universities/Tier 1 support may try using [SQL Workbench/J](http://www.sql-workbench.net/) and the Redshift JDBC driver to check performance or connection issues (as [recommended by Amazon](http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-using-workbench.html)).
Unizin does not optimize or rewrite queries for Members. Unizin reserves the right to terminate your queries if they do not terminate on their own. Excessively long-running or resource abusive queries will be terminated. If your queries perform poorly or have long execution times, you may consider local expertise to optimize the query. If you suspect a performance issue unrelated to a particular query, please [create a support request](/support-and-training.md#user-help-and-support) following the normal Tier 2 support process.
## **UDW Requests Data Retention Policy**
Unizin maintains a requests data retention policy for the UDW. The policy is that we will keep two term’s worth of requests data active before deleting historical data in the UDW.
For example, at the end of the Fall 2020 term, we may proceed to delete the Spring 2020 term requests data (keeping Summer 2020 and Fall 2020 requests data until the following term has ended).
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:
```
GET https://resources.unizin.org/policies/support-policy/unizin-data-warehouse-sp.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.