Launch Week 12: Day 3

Learn more
Back
Artie

Artie

Artie

Overview

Artie is a real-time database replication platform that leverages change data capture. We help companies replicate data from databases like Supabase to their data warehouse (Snowflake, BigQuery, Redshift) and ensure data consistency.

Artie is fully-managed and quick to set up. We take care of historical backfills, provide analytics, monitoring, schema change alerts and more - all out-of-the-box.

Step #1 - Enable IPv4 Add On

Artie does not support IPv6. Please ensure that you have IPv4 enabled as an add on.

To do this:

  1. Go to your project settings in Supabase
  2. Click on Add Ons
  3. Enable IPv4

Screenshot 1

Step #2 - Create an Artie account

Go to Artie's website and fill out the contact form (https://www.artie.com/contact). We will reach out shortly with an account activation link.

Screenshot 2

Step #3 - Find your Supabase database credentials

You can find this under Settings > Database > Connection Parameters.

We will need the following:

  • Database Host (Uncheck Display connection pooler)
  • Database Port (Should be 5432)
  • Username
  • Password
  • Database

To create a service account, please run the following commands in Supabase.


_11
CREATE USER artie_transfer WITH PASSWORD 'password';
_11
_11
-- Grant replication permissions
_11
ALTER USER artie_transfer REPLICATION;
_11
_11
-- Grant read-only access to future tables
_11
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO artie_transfer;
_11
-- Grant access to existing tables
_11
GRANT SELECT ON ALL TABLES IN SCHEMA public TO artie_transfer;
_11
_11
CREATE PUBLICATION dbz_publication FOR ALL TABLES;

Step #4 - Create a new deployment in Artie

Head over to Artie with the information you have gathered from Step #2 and create a new deployment.

Screenshot 3

  • Pick the tables you want to replicate
  • (Optional) You can also enable history mode (which will create a SCD Type 4 table with __history suffix) and record every database change. Consider enabling history mode if you need audit logs or to replace existing daily snapshot processes.
  • Pick your destination. Destination setup instructions will appear on the right hand side of the screen.

Check out our docs if you need additional help.

Product Screenshots

Screenshot 4

Screenshot 5

Screenshot 6

Details

DeveloperArtie
Websiteartie.com
DocumentationLearn

Third-party integrations and docs are managed by Supabase partners.

Get started with Artie and Supabase.