General Dynamics Corporation Quant Signals in Snowflake

-- PREVIEW / WORK IN PROGRESS: the VectorFin Snowflake path is not yet GA.
-- No EXTERNAL_VOLUME: the Polaris catalog vends short-lived, prefix-scoped
-- GCS credentials per read, so Snowflake needs no GCS grant of its own.
CREATE OR REPLACE ICEBERG TABLE GD_signals
  CATALOG = 'vectorfin_polaris'
  CATALOG_NAMESPACE = 'vectorfin'
  CATALOG_TABLE_NAME = 'signals';

-- Flat typed columns (no JSON blob): one column per sub-signal.
SELECT ticker, date, score, altman_z_score, altman_zone,
       beneish_m_score, regime, regime_confidence, effective_ts, knowledge_ts
FROM   GD_signals
WHERE  ticker = 'GD'
ORDER  BY date DESC
LIMIT  30;