veeve

swagger: '2.0'
info:
  version: '0.3.0'
  title: Rockset APIs
  description: |
    **Rockset APIs allows for creating, and managing, all Rockset resources
    in Rockset such as collections, and views**

    Rockset allows you to continuously ingest data from any data silo and
    provides fast search, aggregation and graph queries without requiring

veeve

with tweets as (
    select
        t.user.name,
        t.text,
        upper(sym.text) as ticker
    from
        Demo.twitter_live as t,
        unnest(t.entities.symbols) as sym
    where
        t.entities.symbols [1] is not null