Getting Started

This section walks through how to activate Data Lens, connect to your Snowflake account, and verify access by running your first query.

PrerequisitesAnchorIcon

Before activating Data Lens, you need the following:

  • An active PayPal merchant account
  • Access to Snowflake account
  • Permission to create databases and assign roles in Snowflake
  • Network access to *.snowflakecomputing.com on ports 443 and 80

Request accessAnchorIcon

To begin onboarding, contact your Enterprise Service Manager (ESM) or Account Manager (AM) and provide:

  • Snowflake account identifier
  • Cloud provider and region, such as AWS us-west-2
  • Business contact email
  • Technical contact email

PayPal uses this information to configure a Snowflake data share for your account, including access to transfers, transactions, fees, and disputes data. You will receive an activation email with instructions to access Data Lens.

Authentication methodsAnchorIcon

Snowflake supports multiple authentication methods. PayPal recommends the highest security method possible between merchants and Snowflake.

MethodUse CaseSecurity Level
SSO (SAML/OAuth)Interactive users, BI toolsHighest
Username + MFAService accounts with 2FAHigh
Key Pair (RSA)Automated pipelines, CI/CDHigh
Username + PasswordDevelopment/testing onlyStandard

Connection parametersAnchorIcon

ParameterDescriptionValue
AccountSnowflake account identifier
DatabasePrimary databasePAYPAL_DATA_HUB
SchemaSchema containing all tablesAWS_US_WEST_2
WarehouseCompute warehouse
RoleDefault read-only role