Connecting to your data
Last updated
Was this helpful?
Last updated
Was this helpful?
While using demo data during your onboarding process is great for learning and exploring the platform, nothing feels more real than using your own data in CARTO to create stunning maps, powerful analyses, and interactive applications.
The main way to use your own data in CARTO is to , but if you still don't have a data warehouse (or if you don't have your geospatial files there) you can also .
But first, let's dig in a little bit to understand what happens when you connect your data to CARTO.
The CARTO platform is cloud-native by design. This means that we will always query the live data in your data warehouse, and your data warehouse will return the results, removing the need for ETLs and other costly and inefficient systems. We never make a copy or store the data on our servers, which means:
If you change the data in your data warehouse, your map will also reflect the changes (except cached results)
If you add to or modify the data in your data warehouse, it will also be immediately available in CARTO for you to create maps, workflows, and more.
Because of this, CARTO allows for unparalleled performance and scalability.
Now that we've reviewed the meaning and benefits of going cloud-native, let's create your first live connection to your data.
You can connect CARTO to your data in:
Google BigQuery
Snowflake
Amazon Redshift
PostgreSQL
Databricks (beta)
Check out this video to learn how to create your first connection. The video shows a Google BigQuery connection, but the process is similar when connecting to other data warehouses. Each step is also explained in detail below the video:
If your geospatial data is not yet in the cloud, CARTO can help you import it. There are many solutions to move data to the cloud data warehouses, but not many support geospatial formats, so let's take advantage of the CARTO platform.
Check out this video to learn how to import your first file. Each step is explained below the video:
Your data is now in CARTO! This is a major step toward unlocking all the potential that the platform has to offer. Using this data, there are a few options for what to do next:
If you still don't use any of these data warehouses (or you aren't ready to connect just yet), you can skip this part and go directly to .
You will also have the option to share your connection. Connections are private by default, but you can consider if you want to collaborate with other users.
Connections can be edited at any time, so don't worry about other advanced fields for now. Later in your CARTO journey, you will learn about the (our set of native geospatial functions for your data warehouse) and other exciting features.
❌ If unsuccessful: You will stay on the connections creation page and the error will give you more details about what's wrong. If you need assistance, our will be happy to help. Some things you should check:
🎉 Congratulations! You have now connected your data to CARTO. A quick way to test and explore this data is to open the and list tables coming from your data warehouse. If you click on a table you will immediately see metadata and a map preview. From here, you can start your next geospatial project!
Before you start with your data import process, please make sure you've checked the . A few additional best practices:
Check that your geometry data does not contain . These will be skipped in most cases, up to a certain threshold (see ), but could also cause the import process to fail.
If you're new to CARTO and you don't have any connections of your own, a safe way to get started is to import data into CARTO Data Warehouse > organization data > shared
. Here you can .
Customize the schema manually: You will see a preview, and you can customize the data type for each column. Read more about .
If there are rows with errors (e.g. invalid geometries, invalid values for a column, etc.), the process will continue without those rows until a certain threshold. Learn more about .
Finally, if there are too many errors or there's a major problem, an error block ❌ will appear with further details on why this import failed. If you need assistance, please contact our .
Create a stunning map using , our map-making tool.
Use to visually build a geospatial analysis block by block, with your data as a starting point or an input, with no coding skills required.
Use this data in a .