About Highnote Data Share
Overview
This guide provides an overview of Highnote's secure data share product with Snowflake. With data share, you can easily access, query, and analyze your Highnote data in Snowflake.
The Highnote Issuing Data Dictionary and Acquiring Data Dictionary describe data available for your queries.
Reconciliation
Highnote recommends Data Share as the path for reconciliation—comparing your own records against Highnote's ledger and transaction data. Data Share is built for the high-volume, repeated reads that reconciliation requires.
- Use Data Share, not the API, for bulk reconciliation. Pulling ledger and transaction data through the API for reconciliation is request-intensive and subject to rate limiting. Reserve the API for real-time, transactional reads.
- Treat exported data as complete. Once your data lands in Snowflake within the freshness window described below, it is suitable for reconciling against your own ledger.
Data freshness
Highnote's secure data share product makes most of your data available to query within 3 to 12 hours. Data freshness guidelines are as follows:
- Typically, data is available within 3 hours of its creation but can extend to 12 hours after a schema change or BigQuery/Snowflake system issues.
- Interchange detail information is mutable and may require up to 5 days for a complete data load due to card network delays.
- Once exported, data is retained in Snowflake for 5 years.
Amount representation
All amounts in Highnote reports use a conversion rate of 1 to 1,000,000 units. For example, $1 = 1,000,000 units in a Highnote report.
| Actual Value | Representation in Highnote Report |
|---|---|
| $1 | 1,000,000 |
| $1,000 | 1,000,000,000 |
| $1,000,000 | 1,000,000,000,000 |
Signed amounts (fields ending with _signed_amount) can have negative values.