Skip to main content Link Menu Expand (external link) Document Search Copy Copied

CREATE TABLE ndjson-target

The table ndjson-target is the destination for a BULK INSERT statement, and includes:

  • a numeric unique identifier
  • BOOL, ID, STRING and TIMESTAMP data types
  • IF NOT EXISTS and WITH COMMENT table options

Before you begin

CREATE TABLE statement

CREATE TABLE
  IF NOT EXISTS
  ndjson-target (
    _id ID,
    type STRING,
    actor_id ID,
    actor_login STRING,
    actor_url STRING,
    repo_id ID,
    repo_name STRING,
    repo_url STRING,
    payload_ref STRING,
    payload_ref_type STRING,
    payload_master_branch STRING,
    payload_description STRING,
    payload_pusher_type STRING,
    public BOOL,
   created_at TIMESTAMP
  )
   WITH COMMENT 'this table intended for ndjson data';

Next step