Script to transform h3 tables to h3 int

h3_hex_to_int.sql

----
-- BIGQUERY
---

-- Switzerland
create table carto-dev-data.public.derived_spatialfeatures_che_h3int_res8_v1_yearly_v2
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.public.derived_spatialfeatures_che_h3res8_v1_yearly_v2;

create table carto-dev-data.public.derived_spatialfeatures_che_h3int_res10_v1_yearly_v2_interpolated
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.public.derived_spatialfeatures_che_h3res10_v1_yearly_v2_interpolated;

create table carto-dev-data.public.derived_spatialfeatures_che_h3int_res12_v1_yearly_v2_interpolated
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.public.derived_spatialfeatures_che_h3res12_v1_yearly_v2_interpolated;

-- Spain

create table carto-dev-data.public.derived_spatialfeatures_esp_h3int_res8_v1_yearly_v2
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.public.derived_spatialfeatures_esp_h3res8_v1_yearly_v2;

create table carto-dev-data.public.derived_spatialfeatures_esp_h3int_res10_v1_yearly_v2_interpolated
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.public.derived_spatialfeatures_esp_h3res10_v1_yearly_v2_interpolated;

create table carto-dev-data.large.derived_spatialfeatures_esp_h3int_res12_v1_yearly_v2_interpolated
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.large.derived_spatialfeatures_esp_h3res12_v1_yearly_v2_interpolated;

-- Ukranian
create table carto-dev-data.public.derived_spatialfeatures_ukr_h3int_res8_v1_yearly_v2
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.public.derived_spatialfeatures_ukr_h3res8_v1_yearly_v2;

create table carto-dev-data.public.derived_spatialfeatures_ukr_h3int_res10_v1_yearly_v2_interpolated
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.public.derived_spatialfeatures_ukr_h3res10_v1_yearly_v2_interpolated;

create table carto-dev-data.large.derived_spatialfeatures_ukr_h3int_res12_v1_yearly_v2_interpolated
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.large.derived_spatialfeatures_ukr_h3res12_v1_yearly_v2_interpolated;

-- USA
create table carto-dev-data.public.derived_spatialfeatures_usa_h3int_res8_v1_yearly_v2
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.public.derived_spatialfeatures_usa_h3res8_v1_yearly_v2;

create table carto-dev-data.public.derived_spatialfeatures_usa_h3int_res10_v1_yearly_v2_interpolated
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.public.derived_spatialfeatures_usa_h3res10_v1_yearly_v2_interpolated;

create table carto-dev-data.large.derived_spatialfeatures_usa_h3int_res12_v1_yearly_v2_interpolated
cluster by h3
as 
select cast(concat('0x', h3) as int64) as h3, * except (h3)
from carto-dev-data.large.derived_spatialfeatures_usa_h3res12_v1_yearly_v2_interpolated;