AEPD - Generación de los 200 usuarios

PHOTO EMBED

Wed Mar 09 2022 13:56:34 GMT+0000 (Coordinated Universal Time)

Saved by @alvaroferrer #python #kernel

create or replace table temp_eu.200_users_aepd_avant as 
select * from (
select
    *,
    rand() as rand_
from `reby-cloud.misc_eu.user_consent`
where date(from_co_cu_id_created) between date('2020-08-19') AND current_date
and from_co_id = 'c_3r2qzjfpj8tq2sq3pan1'
)
where rand_ < 0.1
limit 200
content_copyCOPY