Creating a tileset from your data

Available for BigQuery, Snowflake, Redshift, and PostgreSQL connections

Creating tilesets is currently available from BigQuery, Snowflake, Redshift and PostgreSQL connections. Support for Databricks connections will come soon.

To create a tileset from your data, select an available connection and click on a specific table (database/project(s), schemas/datasets and tables) from the collapsible tree.

You can create a tileset by clicking on the Create tileset button at the top right of the screen. The platform detects automatically if the table is based on lines/polygons, points or spatial indexes and provides the appropriate workflow for each case, leveraging the best function of the tiler available in the Analytics Toolbox. Let’s see as an example for the case of a polygon-based table step by step:

Now from this interface will allow you to set the location and name of the output tileset in a directory where the user has write permissions. Once you have completed this configuration, click on Save here.

A new dialog will open so you can create the tileset from a form mode or from a sql mode. You are initially presented with a form mode to configure the tileset. You need to select the tileset zoom levels and choose the geometry column. You can also add a custom description to the tileset. Once you have completed this configuration, click on Continue.

The next screen will allow you to easily select the attributes of your table that will be included in the tileset. After completing this step, click on Continue :

The last screen will show you a summary of the configuration of the tileset for your confirmation. To confirm, click on Create :

At any point of the process you can switch to enable the SQL editor. This editor allows you to configure your tileset directly on the query that will be run to create it, therefore allowing you to edit all of the advanced options available. Once you have finished editing the SQL query, click on Create:

Please note that if you edit the SQL query and go back to the form, a message appears warning you that all changes will be lost. Click on Clear to accept this or click on Cancel to continue editing:

Once you click on Create, the tileset creation process status can be followed from a new dialogue box that appears at the top right corner of the screen. There are three possible status: creating tileset, tileset created successfully or tileset creation error. When an error occurs, you can click on Read more to get more information about the error. You can also click on Clear to clear the list when the processes have finished.