Connecting to Your Data

Single Origin supports connections to the following data systems:

📘

Note

Currently, each customer can connect their account to one system at a time. In the future:

  • we will support additional query engines such as Amazon Redshift
  • we will support multiple data systems per customer

To connect to a system, Single Origin requires two types of connectors to be set up in Mission Control:

  1. An admin must set up a Single Origin Connector to collect schema metadata and support semantic management. This connector does not need to be able to query your data unless you would like Single Origin to profile table statistics automatically.
  2. After an admin has set up a Single Origin Connector, each user must set up a Personal Connector to the same data system. This connector will execute queries on behalf of the user. It is personal to the user, and no other user can see or use this connector.

The privileges required for each connector type are outlined below.

Connector TypeRequired PermissionsOptional Permissions
Single OriginQuery table schema metadataAbility to query data. This enables importing SQL queries from Query History tables, as well as dataset profiling.
PersonalAbility to access some (or all) tables in the data systemAbility to query data.

Security

Single Origin takes data security seriously and implements the following security measures:

  • Key Management Service in place for encryption keys
  • Data at rest is encrypted using AES-256
  • Data in transit is encrypted with TLS 1.2 or higher encryption