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'))
''' )
;