21 lines
354 B
MySQL
21 lines
354 B
MySQL
|
|
||
|
|
/*
|
||
|
|
交易所
|
||
|
|
*/
|
||
|
|
|
||
|
|
{{ config(materialized='view') }}
|
||
|
|
|
||
|
|
with source_data as (
|
||
|
|
|
||
|
|
select 0 As exchange_id
|
||
|
|
, 'SSE' As ts_exchange_code
|
||
|
|
, '上海证券交易所' As exchange_name
|
||
|
|
Union All
|
||
|
|
select 1 As exchange_id
|
||
|
|
, 'SZSE' As ts_exchange_code
|
||
|
|
, '深圳证券交易所' As exchange_name
|
||
|
|
)
|
||
|
|
|
||
|
|
select *
|
||
|
|
from source_data
|