Table: salesforce_contact

Represents a contact, which is a person associated with an account.

If the naming_convention configuration argument is set to api_native, please see API Native Examples.

Examples

Basic info

select
  id,
  name,
  account_id,
  email,
  lead_source,
  title,
  department
from
  salesforce_contact;

API Native Examples

If the naming_convention config argument is set to api_native, the table and column names will match Salesforce naming conventions.

Basic info (with API Native naming convention)

select
  "ID",
  "Name",
  "AccountID",
  "Email",
  "Department"
from
  "Contact";

List deleted contacts

select
  "ID",
  "Name",
  "AccountID",
  "Email",
  "Department"
from
  "Contact"
where
  "IsDeleted";

Show contacts created in last 30 days

select
  "ID",
  "Name",
  "AccountID",
  "Email",
  "Department"
from
  "Contact"
where
  "CreatedDate" <= now() - interval '30' day;