Snowflake Data Sharing and Access
Overview
Leapfin offers two main methods to access data through Snowflake.
- Through Snowflake Data Sharing where the customer uses their own Snowflake account. Preferred
- Through Leapfin's hosted Snowflake sub-account for direct access to the data (this will incur extra Leapfin fees and has query quotas attached to it)
Once access has been setup, users may either connect through Snowflake or use a BI solution of their choice (ex. Tableau, Looker, etc.)
Snowflake Data Sharing
Requirements
- User is required to have a Snowflake account
- User needs to be able to access to Snowflake US-West-2 region
- User needs to provide their account ID to Leapfin to allow access
Once Leapfin allows access to the provided account ID, immediate read-only access will be available to the user.

Leapfin Hosted Snowflake Sub-Account
Requirements
- User must contact Leapfin Customer Success to help set up a user account in Snowflake.
Consumption Limitations
Note that there are limitations to the number of queries that can be executed with a Leapfin Snowflake account. Please contact Leapfin Customer Success if high volume queries are anticipated to discuss setup and pricing.
Snowflake Schema
Snowflake View | Description |
---|---|
VW_AG_JOURNAL_ENTRIES | |
VW_AG_JOURNAL_ENTRIES_MONTHLY | |
VW_FT_CREDIT | |
VW_FT_CREDIT_NOTE | |
VW_FT_CUSTOMER | |
VW_FT_DISCOUNT | |
VW_FT_DISPUTE | |
VW_FT_FEE | |
VW_FT_INVOICE | Leapfin Invoice Object |
VW_FT_LINE_ITEM | |
VW_FT_PAYMENT | |
VW_FT_RECOGNITION_EVENT | |
VW_FT_REFUND | |
VW_FT_SETTLEMENT | |
VW_FT_TAX | |
VW_LK_ACCOUNT | |
VW_LK_ACCOUNT_GROUP | |
VW_RL_LINK |
Updated 8 months ago