File: 109_lateral_flatten.sql

package info (click to toggle)
sqlfmt 0.29.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 1,580 kB
  • sloc: python: 10,007; sql: 5,626; makefile: 39
file content (15 lines) | stat: -rw-r--r-- 379 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
select src:device_type::string
, src:version::string
, _airbyte_data:"AccountId"::varchar as accountid
, value
from
  raw_source
, lateral flatten( input => src:events );
)))))__SQLFMT_OUTPUT__(((((
select
    src:device_type::string,
    src:version::string,
    _airbyte_data:"AccountId"::varchar as accountid,
    value
from raw_source, lateral flatten(input => src:events)
;