Skip to content
  • There are no suggestions because the search field is empty.

How to enable Sellforte to fetch your data from Snowflake

Sellforte can fetch data directly from a customer-managed Snowflake environment. This setup is recommended for recurring datasets where customers manage their own data models and access controls.

All data fetched from Snowflake must follow the relevant Sellforte data specification.

Overview of the setup

The Snowflake fetch setup consists of two steps:

  1. The customer prepares a Snowflake table or view that matches the Sellforte data specification

  2. The customer grants Sellforte read-only access to that data

Once completed, Sellforte fetches the data automatically on an agreed schedule.

1. Preparing your data in Snowflake

Customers are responsible for preparing the data in Snowflake in a format that matches the Sellforte data specification.

This typically means:

  • Creating a table or view in Snowflake

  • Ensuring required fields, data types, and granularity match the specification

  • Including only the data that should be ingested by Sellforte

How the data is produced (for example transformations, joins, or upstream pipelines) is fully up to the customer.

2. Granting Sellforte access

Sellforte requires read-only access to your Snowflake data in order to fetch the data.

Access is granted to a Snowflake role that is assigned to the Sellforte user or service account.

At a minimum, the role must have the following permissions.

Database and schema access

Grant usage access on the relevant database and schema:

  • USAGE on the database

  • USAGE on the schema

This allows Sellforte to reference objects within the database and schema.

Table or view access (read-only)

Grant read access to the table or view that contains the Sellforte-ready data:

  • SELECT on the table or view

Sellforte does not require permissions to modify data or schemas.

Sellforte only executes read-only queries against the specified tables or views.

Completing the setup

Once the data is prepared and access has been granted:

  • Share the Snowflake account, database, schema, and table or view name with Sellforte

  • Sellforte validates access and schedules automated data fetching

No further manual actions are required unless the schema changes.