data_asset

Tables (3)

dm_data_asset

  • id — uuid — Primary key — NOT NULL
  • ingest_batch_id — uuid — Foreign key → dm_ingest_batch.id — NOT NULL
  • original_filename — varchar(512)
  • mime_type — varchar(128)
  • file_extension — varchar(16)
  • nas_path — text
  • checksum_sha256 — varchar(64)
  • byte_size — bigint
  • data_type — varchar(32)
  • category — varchar(32)
  • ingest_source — varchar(32)
  • data_domain — varchar(32)
  • status — varchar(32)
  • failure_reason — text
  • project_id — uuid
  • metadata — jsonb
  • created_by — uuid
  • updated_by — uuid
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deletedAt (deleted_at) — TIMESTAMP
  • isDeleted — BOOLEAN

dm_data_asset_event

  • id — uuid — Primary key — NOT NULL
  • asset_id — uuid — Foreign key → dm_data_asset.id — NOT NULL
  • ingest_batch_id — uuid — Foreign key → dm_data_asset.ingest_batch_id — NOT NULL
  • customer_diff_id — varchar(128)
  • source_system — varchar(64)
  • poll_params — jsonb
  • raw_manifest — jsonb
  • received_at — TIMESTAMP
  • created_at — TIMESTAMP
  • Field

dm_ingest_batch

  • id — uuid — Primary key — NOT NULL
  • customer_diff_id — varchar(128)
  • source_system — varchar(64)
  • poll_params — jsonb
  • raw_manifest — jsonb
  • received_at — TIMESTAMP
  • created_at — TIMESTAMP