tablas bigquery metadata

PHOTO EMBED

Mon Jun 27 2022 08:20:05 GMT+0000 (UTC)

Saved by @alvaroferrer #sql

SELECT *, TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),HOUR) as hour_diff, TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),MINUTE) as minutes_diff
FROM `analytics_reby_v1_eu.__TABLES__` --where table_id = 'table_id'
union all
SELECT *, TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),HOUR) as hour_diff,TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),MINUTE) as minutes_diff
FROM `reby_demand_eu.__TABLES__` --where table_id = 'table_id'
union all
SELECT *, TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),HOUR) as hour_diff,TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),MINUTE) as minutes_diff
FROM `ridestatus_post_gdpr.__TABLES__` --where table_id = 'table_id'
union all
SELECT *, TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),HOUR) as hour_diff,TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),MINUTE) as minutes_diff
FROM `reby_fin_eu.__TABLES__` --where table_id = 'table_id'
union all
SELECT *, TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),HOUR) as hour_diff,TIMESTAMP_DIFF(current_timestamp,TIMESTAMP_MILLIS(last_modified_time),MINUTE) as minutes_diff
FROM `reby_marketing_eu.__TABLES__` --where table_id = 'table_id'
content_copyCOPY