All Collections
Data Warehouse Sync Overview
Data Warehouse Sync Overview

Sync important data from SafeBase directly to your database in a few easy steps

Natalie Novick avatar
Written by Natalie Novick
Updated over a week ago

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. It only requires an initial connection setup from you and no code at all.

Take advantage of automatic syncing. After the initial load, data will be synced once per hour. Event tables (e.g. Status Page Viewed, Status Page Filed Downloaded) are always refreshed once per hour, and object tables (e.g. Accounts, Access Requests) are refreshed once per day. This would mean that event data may be as recent as one hour old, while object data may be as much as one day old.

Note: This is an add-on feature for customers on our Enterprise plan. Please contact your CSM for more details.

The following data points can be synced to your database:

Accounts Table

Access Requests Table

Event = Status Page Viewed (status_page_viewed)

Event = Status Page File Downloaded (status_page_file_downloaded)

Set Up in 3 Easy Steps

  1. Customer to provide us with database host address and type of database. We’ll use this to ensure that nobody else is allowed to use your magic link.

    1. We support BigQuery, Databricks, MySQL, Postgres, Redshift, S3, Google Sheets, Google Cloud Storage, AWS Athena and Snowflake.

  2. We will use this to generate a secure magic link to configure the warehouse integration provided by Prequel.

  3. We will send you a link to access a form where you’ll select your database type and finish submitting your database connection information.

    1. You will need to provide us with a limited service account that can write to a specific dataset/database of your choice.

      1. SafeBase will provide the documentation needed to set up the service account.

    2. Screenshot example below:

That’s it! You’ll start getting data synchronized to your database at the top of the next hour.

Did this answer your question?