Integrating Rillet Data with Aleph via Snowflake

Overview of Data Sharing via Snowflake

Rillet shares your organization’s data using Snowflake’s Private Listing feature. This allows secure and efficient sharing of your data, whether your Snowflake account is in the same region or a different one from ours. Snowflake automatically manages the data replication between regions and ensures low-latency access.

Using Rillet’s Snowflake Share with Aleph

Aleph supports direct data ingestion from Snowflake. Once you’ve accepted the listing in your Snowflake instance, your Aleph team can connect to the shared schema and configure scheduled syncs.

What You’ll Receive

We tailor the export to your needs, but a typical export includes two main tables:

1. General Ledger (GL)

This table includes detailed journal entry line items. Typical fields:

ID, (Varchar)
JOURNAL_ENTRY_ID, (Varchar)
DATE, (Date)
DESCRIPTION, (Varchar)
CUSTOMER_ID, (Varchar)
CUSTOMER_NAME, (Varchar)
VENDOR_ID, (Varchar)
VENDOR_NAME, (Varchar)
DEBIT_AMOUNT, (Number)
CREDIT_AMOUNT, (Number)
CURRENCY, (Varchar)
ACCOUNT_ID, (Varchar)
ACCOUNT_CODE, (Varchar)
ACCOUNT_NAME, (Varchar)
ORGANIZATION_NAME, (Varchar)
SUBSIDIARY_ID, (Varchar)
SUBSIDIARY_NAME, (Varchar)

Custom fields are supported and included as additional columns as needed.

2. Chart of Accounts (CoA)

This table outlines your account structure. Typical fields:

ID, (Varchar)
ORGANIZATION_NAME, (Varchar)
CODE, (Varchar)
NAME, (Varchar)
CATEGORY, (Varchar)
SUBTYPE, (Varchar)

Optional: FX rates and Trial Balance information (including CTA) can also be shared upon request.

---

How to Access the Data

1. Log into your Snowflake account.

2. Go to Data Products → Private Sharing.

3. Locate and accept the listing titled <Your Organization's Listing Name>.

You will then be able to query the shared data directly in your environment.

---

Data Sync and Refresh Frequency

• Data is refreshed hourly by Rillet to ensure near real-time accuracy.

• Snowflake handles replication across regions. Typical delays:

  • Same-region sharing: ~1–2 hours

  • Cross-region sharing: ~2–3 hours

There’s no need for manual refreshes or incremental loading on your end—the shared data view always contains the latest information.

---

Multi-Currency and Consolidation Support

• All subsidiaries are included in the same GL table, with clear subsidiary identifiers.

• Realized and unrealized gains are included as journal entries.

• CTA (Cumulative Translation Adjustment) is not explicitly included but can be inferred or added via shared trial balance data.

• FX rate tables are included on request.

---

Authentication and Access

You can choose to connect the shared data to:

• Your organization’s primary Snowflake account

• Your FP&A platform’s Snowflake instance (if applicable)

Let your Rillet account team know your preferred destination and organization/account identifiers for setup.

---

Frequently Asked Questions

Do I need to set anything up in my Snowflake instance?

Just accept the Private Listing in your Snowflake UI. No additional setup is required.

How long does the initial load take?

Initial data sync is typically available within a few minutes, depending on data volume and region.

Can I customize the export?

Yes. We support customer-specific schemas, including custom fields and optional tables like FX rates or trial balances.