Data sources
CARTO Builder allows you to add sources by connecting directly with your data warehouses, ensuring security and data governance. Once a source is added, the related layer associated with the source is also rendered on the map. From this point, you can start styling your layer, adding widgets, and creating your interactive application.
Data sources types
Builder currently support the following data sources types:
Simple features: Unaggregated features using standard geometry (point, line or polygon) and attributes, ready to use in Builder.
Spatial Indexes: Aggregated data sources for improved performance or specific use cases, including Quadbin and H3 spatial indexes.
Pre-generated tilesets: Tilesets pre-generated using CARTO Analytics Toolbox procedures or Workflows and stored directly in your data warehouse, ideal for handling very large, static datasets.
Raster: A raster source is composed of grids of pixels, where each pixel contains a value representing specific information
Methods for adding sources
In Builder, you can add data sources either as table sources by connecting to a materialized table in your data warehouse or through custom SQL queries. These queries execute directly in your data warehouse, fetching the necessary properties for your map.
Table sources: Connect directly to your data warehouse table through the data explorer dialog. Once connected, the data source is added including its related layer.
SQL query sources: Perform a custom SQL qeury that will act as your input source. Once you execute it, if valid, a new data source and its linked layer will be added to the Builder.
Adding data sources
To add sources in Builder, click on "Add source from" and choose from the following options:
Data Explorer: Browse and add tables as sources from your existing connections or from CARTO Data Observatory.
Custom Query (SQL): Write your own SQL query using the connection of your choice.
Import file: Start the process of importing a file to a CARTO connection.
Adding a source from Data Explorer
When adding a source from Data Explorer, you have the option to add a source from your existing connection or by adding data from the Data Observatory.
To add a source, navigate to the desired location, select your table and click 'Add Source'. The source and its associated layer will be added to the map.
Adding a source from a Custom Query (SQL)
Use the SQL Editor panel in Biulder to add a source by selecting a specific connection. Create your own SQL queries to perform simple analysis, create WHERE statements to pre-filter your data, or use SQL Parameters. You can also leverage CARTO Analytics Toolbox directly from this interface.
Adding source by importing a file
CARTO allows creating tables in your connectiosn by importing files from your computer or via URL. Once a file is imported, the resulting table can be previewed in Data Explorer and used in Builder and external applications.
Last updated
Was this helpful?