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
andWITH COMMENT
table options
Before you begin
- CREATE TABLE examples
- CREATE TABLE statement
- BOOL data type
- ID data type
- INT data type
- STRING data type
- TIMESTAMP data type
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';