gistfile1.txt

CALL cartobq.tiler.ST_PointAggregationAsMVT(
--SQL to use as the source (use geom as name for geography)
'''(SELECT ST_Centroid(geometry) as geom
FROM `bigquery-public-data.geo_openstreetmap.planet_layers` 
where  layer_name ='building')''',

--Name and location where the Tileset will be stored. Replace:
'`cartobq.maps.osm_buildings_weekly`',
  
--Options on how to generate the Tileset
  '''{
      "zoom_max": 14,
      "type": "quadkey",
      "resolution": 8,
      "placement": "cell-centroid",
      "columns":{
        "aggregated_total": {
          "function": "count",
          "column": "*",
          "type": "Number"
        }
      }
 }''');