openreplay/ee/connectors/sql/snowflake_events.sql
2021-05-18 17:10:08 +03:00

52 lines
No EOL
2.2 KiB
SQL

CREATE TABLE IF NOT EXISTS connector_events
(
sessionid bigint,
connectioninformation_downlink bigint,
connectioninformation_type text,
consolelog_level text,
consolelog_value text,
customevent_messageid bigint,
customevent_name text,
customevent_payload text,
customevent_timestamp bigint,
errorevent_message text,
errorevent_messageid bigint,
errorevent_name text,
errorevent_payload text,
errorevent_source text,
errorevent_timestamp bigint,
jsexception_message text,
jsexception_name text,
jsexception_payload text,
metadata_key text,
metadata_value text,
mouseclick_id bigint,
mouseclick_hesitationtime bigint,
mouseclick_label text,
pageevent_firstcontentfulpaint bigint,
pageevent_firstpaint bigint,
pageevent_messageid bigint,
pageevent_referrer text,
pageevent_speedindex bigint,
pageevent_timestamp bigint,
pageevent_url text,
pagerendertiming_timetointeractive bigint,
pagerendertiming_visuallycomplete bigint,
rawcustomevent_name text,
rawcustomevent_payload text,
setviewportsize_height bigint,
setviewportsize_width bigint,
timestamp_timestamp bigint,
user_anonymous_id text,
user_id text,
issueevent_messageid bigint,
issueevent_timestamp bigint,
issueevent_type text,
issueevent_contextstring text,
issueevent_context text,
issueevent_payload text,
customissue_name text,
customissue_payload text,
received_at bigint,
batch_order_number bigint
);