Adding a data source is required to run an Importer. This article will provide an overview on how to add Amazon S3 as a data source to import data.
Key terms for Snowflake
Snowflake-related terms:
- Warehouse: A Snowflake warehouse is a cluster of compute resources that provides CPU, memory, and storage.
- Database: A Snowflake database is a logical container that organizes and stores data within the Snowflake ecosystem.
- Schema: A schema is a logical container within a database that organizes and stores database objects such as tables, views, functions, stored procedures.
Adding Snowflake as a data source
Step 1: Initiating the creation of a data source in your Persona dashboard
Click Imports in the Dashboard’s navigation bar. Then click on + Add new data source in the top right corner of the Imports page.
Step 2: Add your Snowflake instance-specific credentials to create the Snowflake data source
You will need to add your credentials to your Snowflake instance.
To find this information, please reach out to the administrator of your Snowflake instance or if your Snowflake permissions allow, you can query Snowflake for the desired credentials.
These credentials should be specific to the data that you'd like to import into Persona and can include:
- Account
- Username
- Password
- Warehouse
- Database
- Schema
Plans Explained
Snowflake data source for Importers by plan
Startup Program | Essential Plan | Growth Plan | Enterprise Plan | |
---|---|---|---|---|
Snowflake as an available data source | Available | Available | Available | Available |