JSON to Snowflake CREATE TABLE DDL Generator

-- ============================================================================
-- Snowflake CREATE TABLE DDL
-- Target: ANALYTICS_PROD.PUBLIC.SNOWFLAKE_EVENTS
-- Generated by ToolsAA JSON to Snowflake DDL Studio
-- Strategy: VARIANT | Table Kind: STANDARD
-- ============================================================================

-- USE DATABASE ANALYTICS_PROD;
-- USE SCHEMA PUBLIC;

CREATE OR REPLACE TABLE ANALYTICS_PROD.PUBLIC.SNOWFLAKE_EVENTS (
  EVENT_ID                     VARCHAR          NOT NULL COMMENT 'Extracted from JSON key "event_id"',
  TENANT_ID                    VARCHAR          NOT NULL COMMENT 'Extracted from JSON key "tenant_id"',
  USER_ID                      VARCHAR          NOT NULL COMMENT 'Extracted from JSON key "user_id"',
  EVENT_NAME                   VARCHAR          NOT NULL COMMENT 'Extracted from JSON key "event_name"',
  EVENT_TIMESTAMP              TIMESTAMP_NTZ    NOT NULL COMMENT 'Extracted from JSON key "event_timestamp"',
  SESSION_DURATION_SECONDS     FLOAT            NOT NULL COMMENT 'Extracted from JSON key "session_duration_seconds"',
  IS_BILLED_CUSTOMER           BOOLEAN          NOT NULL COMMENT 'Extracted from JSON key "is_billed_customer"',
  CLIENT_IP                    VARCHAR          NOT NULL COMMENT 'Extracted from JSON key "client_ip"',
  USER_AGENT                   VARCHAR          NOT NULL COMMENT 'Extracted from JSON key "user_agent"',
  CONTEXT                      VARIANT          NOT NULL COMMENT 'Extracted from JSON key "context"',
  PAYLOAD                      VARIANT          NOT NULL COMMENT 'Extracted from JSON key "payload"',
  TAGS                         VARIANT          NOT NULL COMMENT 'Extracted from JSON key "tags"',
  _INGESTION_TIMESTAMP         TIMESTAMP_NTZ    DEFAULT CURRENT_TIMESTAMP() NOT NULL COMMENT 'Auto-populated ingestion timestamp',
  _SOURCE_FILE_NAME            VARCHAR(1000)    COMMENT 'Stage source path file',
  CONSTRAINT PK_SNOWFLAKE_EVENTS PRIMARY KEY (EVENT_ID, TENANT_ID, USER_ID) NOT ENFORCED
)
CLUSTER BY (EVENT_TIMESTAMP, TENANT_ID)
DATA_RETENTION_TIME_IN_DAYS = 1
COMMENT = 'Production table synthesized from JSON payload'
;

-- Quick Verification Query:
-- SELECT * FROM ANALYTICS_PROD.PUBLIC.SNOWFLAKE_EVENTS LIMIT 20;