About 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 all the data available for your queries.
Highnote data share is intended for data analytics and reporting.
Highnote's data share 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.
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.