CartoDB (CARTO) Adaptor
About CartoDB
CARTO (formerly CartoDB) is a cloud-native spatial intelligence platform that enables organizations to unlock the power of location data. Built to work natively with major cloud data warehouses like Google BigQuery, Snowflake, Amazon Redshift, and Databricks, CARTO provides advanced geospatial analysis, visualization, and app development capabilities without requiring data movement or ETL processes. The platform serves data analysts, developers, and GIS professionals with tools for spatial analytics, interactive mapping, and location intelligence.
Integration Options
CartoDB supports REST API integration with OpenFn:
REST API: CartoDB provides a comprehensive SQL API that enables external services like OpenFn to interact with geospatial datasets. This API allows you to execute SQL queries, insert/update spatial data, and perform complex geospatial analyses programmatically. The integration is suited for scheduled data synchronization, bulk geospatial operations, and workflows that need to update CartoDB datasets with external spatial information. See functions for more on how to use this adaptor to work with the CartoDB SQL API.
Authentication
To connect to CartoDB, you need to provide your account credentials:
{
"account": "your_carto_username",
"apiKey": "your_api_key_here"
}
Required Fields:
account: Your CARTO account username (required)apiKey: Your CARTO API key for authentication (required)
You can obtain your API key from your CARTO account dashboard under API Keys section.
Helpful Links
OpenFn adaptors are open source and we welcome contributions. See the Adaptors Wiki to learn how to update an adaptor, or ask on the OpenFn Community Forum.