About Highnote Data Share
Overview
Contact your Highnote representative to start querying your data in Snowflake Data Share.
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.
Data freshness
Highnote Data Share is intended for data analytics and reporting.
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.