Postgres

Why syncing my Airtable to Whaly?

Syncing your Postgres can be useful for various cases
    Make complex data viz on top of Postgres data
    Combine Postgres data with your CRM data to detect churn or upsells
    ....

Documentation of the connection

The documentation to get your database set up for connection is the following: https://fivetran.com/docs/databases/postgresql/rds-setup-guideโ€‹
After your connection is up & running, can you shoot your product specialist an email so he/she can check that everything is running smoothly.
Once you have connected your DB can you please send me a copy of your DB schema by running the following query: SELECT tc.table_schema, tc.constraint_name, tc.constraint_type, tc.table_name, kcu.column_name, ccu.table_schema AS foreign_table_schema, ccu.table_name AS foreign_table_name, ccu.column_name AS foreign_column_name FROM information_schema.table_constraints AS tc JOIN information_schema.key_column_usage AS kcu ON tc.constraint_name = kcu.constraint_name AND tc.table_schema = kcu.table_schema JOIN information_schema.constraint_column_usage AS ccu ON ccu.constraint_name = tc.constraint_name AND ccu.table_schema = tc.table_schema;
This query will get us all the constraints that are applied in your DB and will allow us to configure properly the connector so that you would not have to worry about a "bad join" again ๐Ÿ™‚. If you are running this query on your computer you can easily export it by running \copy (SELECT tc.table_schema, tc.constraint_name, tc.constraint_type, tc.table_name, kcu.column_name, ccu.table_schema AS foreign_table_schema, ccu.table_name AS foreign_table_name, ccu.column_name AS foreign_column_name FROM information_schema.table_constraints AS tc JOIN information_schema.key_column_usage AS kcu ON tc.constraint_name = kcu.constraint_name AND tc.table_schema = kcu.table_schema JOIN information_schema.constraint_column_usage AS ccu ON ccu.constraint_name = tc.constraint_name AND ccu.table_schema = tc.table_schema;) to 'whaly.csv' csv header
Last modified 20d ago