vvgsrk

vvgsrk

DESCRIBE MATERIALIZED VIEW dm_rmp.infare;

vvgsrk

SHOW MATERIALIZED VIEWS LIKE 'INFARE' IN DATABASE;

vvgsrk

CREATE OR REPLACE MATERIALIZED VIEW dp_prod.dm_rmp.infare
COMMENT = 'Materialized view for infare external table'
CLUSTER BY (observation_date)
AS
SELECT
    id,
    observation_date,
    observation_time,
    pos,
    origin,

vvgsrk

DESCRIBE EXTERNAL TABLE dp_prod.raw_rmp.infare_external_table;

vvgsrk

SHOW EXTERNAL TABLES LIKE 'infare_external_table' IN DATABASE;

vvgsrk

CREATE OR REPLACE EXTERNAL TABLE dp_prod.raw_rmp.infare_external_table (
        date_partition date as to_date(concat(substr(METADATA$FILENAME, 31, 4), '-', substr(METADATA$FILENAME, 39, 2), '-', substr(METADATA$FILENAME, 45, 2)), 'YYYY-MM-DD'),
        id int as (value:id::int),
        observation_date date as (TO_TIMESTAMP(value:observation_date)::date),
        observation_time varchar as (value:observation_time::varchar),
        pos varchar as (value:pos::varchar),
        origin varchar as (value:origin::varchar),
        destination varchar as (value:destination::varchar),
        is_one_way int as (value:is_one_way::int),
        outbound_travel_stop_over varchar as (value:outbound_travel_stop_over::varchar),

vvgsrk

vvgsrk

CREATE TABLE db_dev.revenue.od_forecast_booking(
depature_airport VARCHAR,
arrival_airport  VARCHAR,
depature_date DATE,
airline_code VARCHAR,
flight_number VARCHAR,
flight_cabin VARCHAR,
booking_class VARCHAR
);

vvgsrk

SHOW PROCEDURES LIKE 'fa_unload_sp' IN db_dev.revenue;

DESCRIBE PROCEDURE db_dev.revenue.fa_unload_sp();

SELECT * 
  FROM information_schema.procedures 
 WHERE procedure_catalog = 'AYDP_DEV'
   AND procedure_schema = 'PUBLIC'
   AND procedure_name = 'FA_UNLOAD_SP';