low_zooms.sql

CALL `carto-un`.carto.CREATE_TILESET(
  R'''(
        select id, all_tags, st_geogpoint(longitude, latitude) as geom from bigquery-public-data.geo_openstreetmap.planet_nodes
  )
  ''',
  R'''`project.dataset.osm_nodes_tiles_17_and_down`''',
  STRUCT(
    "OSM Nodes" AS name,
    "OSM nodes raw data for zooms 17 and below" AS description,
    NULL AS legend,
    17 AS zoom_min,
    20 AS zoom_max,
    "geom" AS geom_column_name,
    NULL AS zoom_min_column,
    NULL AS zoom_max_column,
    1024 AS max_tile_size_kb,
    "RAND() DESC" AS tile_feature_order,
    true AS drop_duplicates,
    R'''
      "custom_metadata": {
        "version": "1.0.0",
        "layer": "layer1"
      }
    ''' AS extra_metadata
  )
);