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:
- Go to your project settings in Supabase
- Click on Add Ons
- Enable IPv4
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.
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.
_11CREATE USER artie_transfer WITH PASSWORD 'password';_11_11-- Grant replication permissions_11ALTER USER artie_transfer REPLICATION;_11_11-- Grant read-only access to future tables_11ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO artie_transfer;_11-- Grant access to existing tables_11GRANT SELECT ON ALL TABLES IN SCHEMA public TO artie_transfer;_11_11CREATE 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.
- 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
Details
Third-party integrations and docs are managed by Supabase partners.