Links

Q1 2023

New features and improvements introduced from January to March 2023

New functions to generate routing matrices and isolines natively in BigQuery

January 31st, 2023
Beta Analytics Toolbox
In the January 2023 release of the Analytics Toolbox for BigQuery, we have published a new and improved version of the routing module. This new version includes procedures ROUTING_MATRIX to calculate origin-destination matrices and ROUTING_ISOLINES to compute isolines around a set of locations, both supporting multiple transportation modes (car, bike, and walk). These new functions run on top of CARTO’s road network (derived from OSM segments) that is available as a public subscription in the Data Observatory. Please note that these improvements imply breaking changes with the previous version of the routing module.
To learn more about these new procedures please check our product documentation. We have also published a guide to illustrate how to benefit from this module of the Analytics Toolbox.

Adding raster support in BigQuery with a new module in the Analytics Toolbox

January 31st, 2023
Beta Analytics Toolbox
In the January 2023 release of the Analytics Toolbox for BigQuery, we have launched in beta our new raster module. This feature offers a set of functions to operate with raster data natively in BigQuery, benefiting from the processing speeds and scalability of this data warehouse.
Alongside the raster module in the Analytics Toolbox, we have also made available our Raster Loader, built in collaboration with Makepath. This publicly available Python library works as a tool for loading and optimizing GIS raster data into cloud-based data warehouses.
In order to learn more about this new module please check our product documentation. We have also published an example that illustrates how to use some of our functionality to combine raster and vector data to solve a spatial analysis.

New space for private data available for every user in the CARTO Data Warehouse

January 26th, 2023
New Workspace
Starting with this release, users that explore their CARTO Data Warehouse connection in Data Explorer will find two datasets (represented as folders) inside their organization data: private and shared.
The new dataset "private" is a unique dataset for each user, and all the tables and tilesets in this dataset will only be available to that user. Private datasets have a unique qualified name that identifies the user, extracted from their email.
The "shared" dataset will remain available to all the editor users in that organization. You can find all the documentation for this feature in the CARTO Data Warehouse documentation.

Search, list view and breadcrumbs when browsing your data in Builder and Workspace

January 24th, 2023
Improvement Builder Workspace
An important step of most processes in CARTO is to browse and select data sources and data locations:
We have improved the user experience for these cases by adding a search bar that works at every level of your data, adding a new view: the list view, and adding breadcrumbs to help you navigate your data. The list view is similar to the one used in Data Explorer (including the search bar and breadcrumbs) and will now make the experience more consistent across the CARTO platform. If you would rather focus on the hierarchy of your data, the tree view is still available on the top right.
This is especially beneficial if you have a large number of projects/databases, schemas/datasets, or tables and tilesets: where previously you would need to scroll indefinitely, now you can perform a quick search.

Dynamic aggregation of point layers into Quadbin grids

January 23rd, 2023
New Builder
With this new feature, point layers can be transformed dynamically into an aggregated grid leveraging our Quadbin spatial index.
This produces a very significant increment in performance, but also allows aggregating data from the original features to make sure that all data is taken into consideration.
Some highlights:
  • Available for all point tile layers from all data warehouses
  • Implemented with pure SQL in our Maps API, no external dependencies such as the Analytics Toolbox or third-party libraries.
  • It allows aggregating properties from the original points and also the number of points per cell.
  • Inherits all the advantages and features of the previously existing Spatial Index layers.
  • The aggregation happens transparently so no need to manually type any SQL code to aggregate the points.

CARTO Workflows in public beta with support for Google BigQuery and CARTO Data Warehouse

January 18th, 2023
Beta Workflows
Today we are excited to announce that CARTO Workflows is now publicly available in beta with support for Google BigQuery and CARTO Data Warehouse. CARTO Workflows is a new tool that enables users of all types and skill levels to harness the power of cloud data warehouses, spatial SQL, and advanced spatial analytics.
CARTO Workflows provides a visual language to design and execute multi-step spatial analytics procedures, reducing the complexity and the high dependance on specialist knowledge to leverage the power of location intelligence. To learn more about this new development, please check our product documentation.
In the coming weeks we will add support to run CARTO Workflows on Snowflake, Redshift and PostgreSQL-based data warehouses, if you want to know more about that please contact us through our Support team.

New documentation layout

January 18th, 2023
Improvement Documentation
Our documentation portal just got a new look and feel! This new layout should provide the following benefits:
  • Cleaner look that uses more screen space if available
  • A search bar to quickly find content
  • All the documentation is organized and available on the left menu
  • All pages now have an "On this page" index on the right sidebar __ to quickly locate sections
Hopefully, you'll have a better experience using this documentation. If you have any feedback about it, contact us through our Support team. We'll keep working on documentation improvements during the following weeks.

Multiple editor users working on the same map

January 13th, 2023
New Builder
Collaborating on CARTO maps is finally possible, in asynchronous mode. This is helpful in setups such as production-ready maps, where the original owner might be out of the office; or in situations where the data, analysis, and cartography are each accomplished by different users. This is how it works:
  1. 1.
    The map owner first needs to enable collaboration for that map.
  2. 2.
    From that moment, all editors with access to the map will be able to edit it.
  3. 3.
    If two editors try to edit at the same time, the last one will be locked out, with the option of requesting to take over editing.
Happy collaboration!
Last modified 22h ago