You can store up to 200 fields, formula values, and roles per object type.
Data is updated every two to five minutes, depending on the data load.
It may take 30 minutes or more following initial activation before the Data Warehouse is fully functional. Additionally, significant changes to your organization (e.g., a data import) can take 30 minutes or more to transfer successfully.
BI Tool Requirements for Connecting to our Data Warehouse
TLS 1.2 is the minimum version for BI tool connectivity to our Data Warehouse. Some BI tools may have additional requirements.
If you have trouble connecting to the Data Warehouse, contact your IT department to allow outbound connections on TCP port 5432.
Core Data Warehouse Limitations
Rich Text Fields store previews of the first 500 characters added to the field.
If you need to make any field, formula or object name changes, a manual update in the Data Warehouse tool is required to reflect these changes. However, amendments of this nature may negatively affect your BI reports:
You will need to update existing table names, fields, and relationships in your existing data sets and reports in your BI tool.
Changes to data will only show from when your Data Warehouse was reset.
The Data Warehouse feature does not:
Record object changes from one state to another
Store attachments (image or file) or text formatting (markdown or rich text)
Transfer role permissions. Any user accessing the BI tool can view object data. Otherwise, their role permissions would restrict
Automatically transfer field, formula, or object type name changes into the Data Warehouse. A manual update in the tool is required to reflect these changes but note that amendments of this nature may negatively affect your BI reports
If your organization was recently imported into Resolver, wait a minimum of 30 minutes before transferring data into the Data Warehouse.
The statement timeout is 60 seconds. If you see the message ERROR: canceling statement due to statement timeout, you may need to limit how much data you pull out.
Data Warehouse does not store passwords in Resolver. If you lose the original password, you must create a new BI tool password.
If the user account that created the original BI tool password is deleted, disabled, or lost, you must create a new BI tool password.