Overview
SafeBase's data warehouse sync is secure, easy, and saves valuable development time. It sends your key SafeBase data directly to your Snowflake, BigQuery, Redshift, S3, or most other data warehouses. A list of available destinations can be found here.
The integration requires a simple initial no-code connection.
After the initial setup, data will be synced once per hour. Event tables (e.g., Status Page Viewed, Status Page File Downloads) are refreshed once per hour, object tables (e.g., Accounts, Access Requests) are refreshed once per day.
Note: The Data Warehouse sync feature is exclusive to our Enterprise plan, as an add-on feature. Please contact us if you'd like to learn more.
Configuration
Customers will provide SafeBase with a database host address and type of database. This will be used to create a secure, bespoke magic link unique to the individual organization via Prequel (the service SafeBase utilizes for this feature).
The link will direct organizations to an onboarding wizard to begin configuration. Orgs will be required to select a database type and submit database connection information.
The connection requires organizations to provide a limited service account that can write to a specific dataset/database.
Data will be synchronized to the designated database at the top of the next hour.
Data points that can be synced
Accounts Table
Access Requests Table
Event = Status Page Viewed (status_page_viewed)
Event = Status Page File Downloaded (status_page_file_downloaded)
Event = Status Page File Engaged (status_page_file_engaged)
Destination column | Source column | Data type |
id
Note: This is the Primary key | id | text |
anonymous_id | anonymous_id | text |
context_ip | context_ip | text |
context_user_agent | context_user_agent | text |
event | event | text |
updated_at | original_timestamp | timestamp |
loaded_at | loaded_at | timestamp (last modified) |
received_at | received_at | timestamp |
shared_mode | shared_mode | text |
account_id | account_id | text |
account_member_email | account_member_email | text |
account_member_name | account_member_name | text |
account_name | account_name | text |
account_nda_provider | account_nda_provider | text |
engaged_at | engaged_at | timestamp |
file_id | file_id | text |
file_name | file_name | text |
item_card_type | item_kind | text |
item_uid | item_uid | text |
item_title | item_title | text |
item_product_id | item_product_id | text |
product_id | product_id | text |
product_name | product_name | text |
source | file_engagement_source | text |
type | file_engagement_type | text |