Use case

Check new sign-ups against US sanctions lists

Your sign-ups and our US sanctions lists can sit in the same warehouse. A scheduled query flags possible matches for your team to review.

Talk to usSee it step by step

At the Hypothesis stage. Spans 2 suites: US sanctions lists from Zym Labs Data, with event tracking (Events) and reverse ETL (Sync) from Argon.

Check

Screen new sign-ups

  1. TriggerSigned up
  2. StoreTheir profile, written to Snowflake
  3. CheckMatched against US sanctions lists
  4. ReviewPossible matches go to your team

Step by step

From sign-up to review

The check has 4 steps. It’s at the Hypothesis stage, so details may change.

  1. Trigger

    They sign up

    Your app sends a signed_up event with the name and details you collect at sign-up.

    Runs on Events

    Events / LiveLive
    signed_upusr_2041just now
    plan"trial"
    source"pricing_page"
    email"[email]"
    page_viewedusr_03884s
    project_createdusr_11729s
    signed_upusr_091212s
    Started journey: New sign-up onboarding

  2. Store

    Their profile reaches your warehouse

    Sync writes the new profile to a table in Snowflake, next to the sanctions lists.

    Runs on Sync, at the Hypothesis stage

    Sync / Profiles to SnowflakeDraft
    FromAll profiles
    ToANALYTICS.ARGON.PROFILES
    Match rows onuser_id
    Schedule[SCHEDULE OPTIONS]
    Preview of the table[N] rows
    user_idplanlifetime_value
    usr_2041trial[N]
    usr_0388growth[N]
    usr_1172growth[N]
    usr_0912trial[N]

  3. Check

    Match against the lists

    A scheduled query compares new sign-ups with the SDN and Consolidated lists on [MATCH FIELDS]. Every publication since Sep 22, 2022 is kept, so you can show what a list said on any date.

    Uses US sanctions lists from Zym Labs Data

    Zym Labs Data / US sanctions listsSnowflake
    Tables11
    select list, published, entities
    from [TABLE]
    order by published desc
    ListPublicationEntities
    SDN[DATE][COUNT]
    Consolidated[DATE][COUNT]

  4. Review

    Review possible matches

    A name match isn’t proof. Your team checks each possible match before you decide. [HOW POSSIBLE MATCHES REACH YOUR TEAM.]

  5. Clear sign-ups go ahead

    Sign-ups with no possible match go ahead. Your team decides on the rest. Screening supports your compliance process, and doesn’t replace it.

Products

What it takes

This check uses 2 Argon modules and 1 dataset. Sync and the dataset are at the Hypothesis stage.

See US sanctions lists

Needed

To run the check

Screen sign-ups in your own warehouse

Tell us how you screen sign-ups today and where your data lives. We’ll tell you what works now.

Talk to usSee US sanctions lists
Sanctions screening at sign-up | Zym Labs