Wipe out dupe accounts - next ETL will fill in the valid ones from SFDC

sfdc_cleanup.sql

# Cleanup Accounts and Contacts

CREATE TEMPORARY TABLE account_cleanup_temp  SELECT organization_uuid FROM _accounts_ WHERE organization_uuid IS NOT NULL GROUP BY organization_uuid HAVING   COUNT(*) > 1;

DELETE a FROM _accounts_ INNER JOIN account_cleanup_temp t ON a.organization_uuid = t.organization_uuid;

DROP TABLE account_cleanup_temp;


CREATE TEMPORARY TABLE contact_cleanup_temp  SELECT user_uuid FROM _contacts_ WHERE user_uuid IS NOT NULL GROUP BY user_uuid HAVING COUNT(*) > 1;

DELETE c FROM _contacts_ c INNER JOIN contact_cleanup_temp t ON c.user_uuid = t.user_uuid;

DROP TABLE contact_cleanup_temp;