Ingesting data from Snowflake into Propel.
SECURITYADMIN
, SYSADMIN
, and ACCOUNTADMIN
system-defined roles.<account_locator>
or<account_locator>.<cloud_region_id>
or<account_locator>.<cloud_region_id>.<cloud>
cloud_region_id
is the identifier for the cloud region (dictated by the cloud platform).cloud
is the identifier for the cloud platform (aws, azure, or gcp).North American regions
xy12345
(No region, no cloud)xy12345.us-east-1
(No cloud)xy12345.us-east-2.aws
xy12345.us-central1.gcp
xy12345.us-east4.gcp
xy12345.ca-central-1.aws
xy12345.west-us-2.azure
xy12345.central-us.azure
xy12345.south-central-us.azure
xy12345.east-us-2.azure
xy12345.canada-central.azure
European regions
xy12345.eu-west-1
(No cloud)xy12345.eu-west-2.aws
xy12345.eu-west-3.aws
xy12345.eu-central-1
(No cloud)xy12345.eu-central-2.aws
xy12345.eu-north-1.aws
xy12345.europe-west2.gcp
xy12345.europe-west4.gcp
xy12345.uk-south.azure
xy12345.north-europe.azure
xy12345.west-europe.azure
xy12345.switzerland-north.azure
South American regions
xy12345.sa-east-1.aws
Asian regions
xy12345.ap-northeast-1.aws
xy12345.ap-northeast-3.aws
xy12345.ap-northeast-2.aws
xy12345.ap-south-1.aws
xy12345.ap-southeast-1
(No cloud)xy12345.ap-southeast-2
(No cloud)xy12345.ap-southeast-3.aws
xy12345.ap-southeast-1
xy12345.ap-southeast-2
xy12345.ap-southeast-3
xy12345.central-india.azure
xy12345.japan-east.azure
xy12345.southeast-asia.azure
user_password
, database_name
, and schema_name
variables with the following values before running the script.user_password
it must be at least 8 characters long, contain at least 1 digit, 1 uppercase letter and 1 lowercase letterdatabase_name
with the name of the Snowflake database where your schema is located, for example ANALYTICS
.schema_name
with the database and schema name where your tables are located, for example ANALYTICS.PUBLIC
.SECURITYADMIN
and ACCOUNTADMIN
system-defined roles.Create a Data Pool
Enter credential details
ANALYTICS
.
PUBLIC
.
Test your credentials
Introspect your Snowflake tables
Select table and columns
Configure data type and settings
Set sync interval
Name your Data Pool
Validate setup
Preview data