Skip to main content

Data Import

Data Import allows you to bring user data from external data warehouses into Joryio to enrich user profiles.

Supported Platforms​

Snowflake​

Import data from Snowflake data warehouse.

Required credentials:

FieldDescription
AccountSnowflake account identifier (e.g., xy12345.us-east-1)
UsernameSnowflake username
PasswordSnowflake password
WarehouseSnowflake warehouse name
DatabaseDatabase name
SchemaSchema name (default: PUBLIC)

BigQuery​

Import data from Google BigQuery.

Required credentials:

FieldDescription
Service Account JSONGoogle Cloud service account JSON key file contents
Project IDGoogle Cloud project ID
Dataset IDBigQuery dataset ID

Setting Up​

  1. Navigate to Data > Data Import
  2. Click Connect on the platform you want to use
  3. Enter a name for the integration
  4. Fill in the required credentials
  5. Click Connect

How It Works​

Data Import uses the import_data action to execute SQL queries against your data warehouse and bring the results into Joryio. This is useful for:

  • Enriching user profiles with data from your warehouse
  • Importing user segments defined by your data team
  • Syncing computed attributes (lifetime value, engagement scores, etc.)

Security​

  • All credentials are encrypted at rest using AES-256-GCM
  • Credentials are never exposed in API responses
  • Each integration is scoped to your organization and workspace
  • We recommend using read-only database credentials with access limited to the specific tables/views needed