Get Started
Highnote's data sharing product lets you export your Highnote data to Snowflake. This guide explains how to get started using Highnote's data sharing product.
Note: We recommend using datasets in Snowflake for data analytics and reporting purposes, not data processing.
Highnote data sharing makes most of your data available to query within 12 hours. Refer to the following guidelines for data freshness:
-
Once exported, data is retained in Snowflake for 5 years.
-
Typically, data is processed within 9 hours of its creation. This can be extended to up to 12 hours to uphold data integrity and accuracy.
-
Interchange detail information is mutable and may require up to 5 days for a complete data load due to card network delays.
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.
Highnote connects directly to your Snowflake account to support data share -- this section explains how.
Simply send Highnote your Snowflake account details, then accept the data share request from Highnote and connect. For help, contact support@highnote.com.
Prerequisites
- A Snowflake account
ACCOUNTADMINrole
Steps to connect your Highnote account
-
Go to your Snowflake account and get your account number and region. Send this info to Highnote.
-
Wait for 2 -3 business days to see the dataset that will be privately shared to your Snowflake account. (Highnote will notify you once the share is completed.)
-
In Snowflake, with your
ACCOUNTADMINrole, navigate to Data Products, and select Private Sharing. -
Click the Get arrow from the dataset we shared to accept the share.
-
Confirm you can view your Highnote data on the Data and Databases page.
-
Query Highnote data directly in Snowflake by going to Home → Query data → new worksheet
Additional information
Refer to the Snowflake docs for detailed information:
SQL queries on Highnote data in Snowflake are for issuing only.
The following example SQL queries can be used to retrieve data from Highnote's data sharing tables:
- Query card activity report
- Query ledger entry report