SELECT * FROM EXTERNAL_QUERY("reby-cloud.eu.reby_prod", ''' select concat('cu_',id_to_text(cu.id)) as id, id_to_time(cu.id) as created_at, concat('acc_',id_to_text(cu.balance_account_id)) as account_id, concat('c_',id_to_text(cu.company_id)) as company_id, concat('usr_',id_to_text(cu.user_id)) as user_id, --id_to_time(cu.user_id) as user_first_created_at, firebase_user_token, is_deleted, updated_at from company_user cu --where id >= id_from_time(NOW() - INTERVAL '1 DAY') --where date(id_to_time(id)) > now() - interval '3 day' where id < id_from_time(date('2020-06-01')) ''' ) ;