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
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.
We support BigQuery, Databricks, MySQL, Postgres, Redshift, S3, Google Sheets, Google Cloud Storage, AWS Athena and Snowflake.
We will use this to generate a secure magic link to configure the warehouse integration provided by Prequel.
We will send you a link to access a form where you’ll select your database type and finish submitting your database connection information.
You will need to provide us with a limited service account that can write to a specific dataset/database of your choice.
SafeBase will provide the documentation needed to set up the service account.
Screenshot example below:
That’s it! You’ll start getting data synchronized to your database at the top of the next hour.