CREATE OR REPLACE VIEW fact_events AS
 SELECT fact_events.device_model,
    fact_events.carrier,
    fact_events.application_version,
    fact_events.os_version,
    fact_events.data_collector_version,
    fact_events.api_version,
    fact_events.device_id,
    fact_events.session_id,
    fact_events.user_id,
    fact_events.username,
    fact_events.hub_id,
    fact_events.hub_name,
    fact_events.post_id,
    fact_events.post_author_id,
    fact_events.post_author_username,
    fact_events.server_timestamp,
    fact_events.screen_width,
    fact_events.screen_height,
    fact_events.item_id,
    fact_events.music_track_id,
    fact_events.session_length,
    fact_events.operating_system,
    fact_events.stage_section_name,
    fact_events.internet_connection,
    fact_events.post_author_role,
    fact_events.post_type,
    fact_events.post_pinned,
    fact_events.video_source,
    fact_events.email_verification_result,
    fact_events.stream_type,
    fact_events.share_type,
    fact_events.event_name,
    fact_events.post_area,
    fact_events.source_type,
    fact_events.music_album_id
   FROM dblink('dbname=<db_name> user=<db_user> password=<ddb_user_password> host=<host> port=<port>'::text,
   'SELECT device_model, carrier, application_version, os_version, data_collector_version,
    api_version, device_id, session_id, user_id, username, hub_id, hub_name,
    post_id, post_author_id, post_author_username, server_timestamp,
    screen_width, screen_height, item_id, music_track_id, session_length,
    operating_system, stage_section_name, internet_connection, post_author_role,
    post_type, post_pinned, video_source, email_verification_result, stream_type,
    share_type, event_name, post_area, source_type, music_album_id
    FROM fact_events'::text)
    fact_events(device_model character varying(128), carrier character varying(128), application_version character varying(64),
                os_version character varying(64), data_collector_version character varying(128), api_version character varying(64),
                device_id character varying(64), session_id character varying(64), user_id character varying(64),
                username character varying(128), hub_id character varying(64), hub_name character varying(128),
                post_id character varying(64), post_author_id character varying(64), post_author_username character varying(255),
                server_timestamp bigint, screen_width integer, screen_height integer, item_id character varying(64),
                music_track_id character varying(64), session_length double precision, operating_system character varying(32),
                stage_section_name character varying(16), internet_connection character varying(16),
                post_author_role character varying(64), post_type character varying(32), post_pinned character varying(16),
                video_source character varying(16), email_verification_result character varying(32), stream_type character varying(32),
                share_type character varying(32), event_name character varying(64), post_area character varying(64),
                source_type character varying(50), music_album_id character varying(128));