CREATE TABLE IF NOT EXISTS `united-strategy-279207.new_dataset.partition_table`
(
date DATE,
source STRING,
medium STRING,
conversions INT64
)
partition by (date)
select _PARTITIONTIME as date,id, name,revenue
from `business-metric.new_dataset.partiton_table_test`
select _PARTITIONTIME as date,id, name,revenue
from `business-metric.etnoshop.partiton_table_test`
WHERE _PARTITIONTIME = '2022-07-18 09:00:00 UTC'
CREATE TABLE IF NOT EXISTS `united-strategy-279207.new_dataset.partition_table`
(
date DATE,
source STRING,
medium STRING,
conversions INT64
)
partition by (date)
select * from `business-metric.etnoshop.partition_table`
where date = '2022-07-05'
SELECT event_date,event_timestamp,event_name
FROM `business-metric.analytics_319368526.events_*`
WHERE _TABLE_SUFFIX between '20220715' and '20220717' and event_name = '30sec_plus_50percent'
SELECT event_date,event_timestamp,event_name
FROM `business-metric.analytics_319368526.events_*`
WHERE _TABLE_SUFFIX in ('20220715', '20220716') and event_name = '30sec_plus_50percent'
CREATE TABLE IF NOT EXISTS `united-strategy-279207.new_dataset.partition_table_1`
( date DATE,
source STRING,
medium STRING,
conversions INT64 )
partition by (date) options (partition_expiration_days=100, require_partition_filter=TRUE)
ALTER TABLE
`business-metric.etnoshop.partition_table`
SET
OPTIONS(require_partition_filter=TRUE,partition_expiration_days=50)