low_zooms.sql

CALL `carto-un`.carto.CREATE_POINT_AGGREGATION_TILESET(
  R'''(
    select id, st_geogpoint(longitude, latitude) as geom from bigquery-public-data.geo_openstreetmap.planet_nodes
  )''',
  '`project.dataset.osm_nodes_points_17`',
  R'''
    {
      "zoom_min": 0,
      "zoom_max": 17,
      "aggregation_resolution": 7,
      "max_tile_size_strategy": "drop_fraction_as_needed",
      "aggregation_placement": "cell-centroid",
      "properties": {
        "aggregated_total": {
          "formula": "COUNT(*)",
          "type": "Number"
        }
      }
    }
  ''');