entity

-- ============================================================
-- Table  : entity — The entity supertype: one row for every customer, vendor, employee, partner, contact, project and group, with pointer columns to the concrete record and a type discriminator.
-- Purpose: Column-selected read of entity — auto-generated from field metadata
-- Grain  : One row per id
-- Notes  : Auto-generated skeleton for NetSuite data landed in your lakehouse from a SuiteAnalytics Connect (or SuiteQL) extract — it never addresses live NetSuite. Identifiers are lowercase as NetSuite2.com renders them. Select-type columns hold numeric internal ids: BUILTIN.DF() display resolution exists only at extraction time, so decode ids by joining the landed list records; see quirks #display-values. Check-box columns arrive as 'T'/'F' strings; see quirks #tf-booleans.
-- ============================================================
SELECT
  t.id AS "Internal ID",
  t.entityid AS "Entity ID",
  t.entitytitle AS "Name/ID as displayed",
  t.altname AS "Name",
  t.entitynumber AS "Entity number",
  t.type AS "Entity type discriminator (multiselect)",
  t.isperson AS "Individual rather than a company",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.isinactive AS "Inactive",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.datecreated AS "Date created — note the column is datecreated here, not createddate",
  t.lastmodifieddate AS "Last modified — the incremental watermark",
  t.parent AS "Parent entity (internal id)",
  t.toplevelparent AS "Top-level parent entity (internal id)",
  t.customer AS "Customer record this entity resolves to (internal id)",
  t.vendor AS "Vendor record this entity resolves to (internal id)",
  t.employee AS "Employee record this entity resolves to (internal id)",
  t.`group` AS "Group record this entity resolves to (internal id)",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.entity t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.id = <id>
  -- AND t.lastmodifieddate >= TIMESTAMP '<watermark>'  -- inserts and updates only — deletes never appear here; diff deletedrecord, which is itself blind to line-level deletes (see quirks #deletes)
ORDER BY t.id;