In the Sources explorer you can find all the data sources available via the data warehouse connection that you have selected when creating the workflow. Here you can learn more about how to create your data warehouse connections in CARTO.
In case you are using a service account to connect to Google BigQuery, note that it must have at least BigQuery Data Owner (
roles/bigquery.dataOwner) permissions in order to edit schemas, create and edit tables, and get information regarding jobs.
It is important to note that currently each workflow can only be associated with one single data warehouse connection and that it is defined at the time of creating the workflow (without being able to modify it afterwards).
If you want to use data that is not available via the data warehouse connection used in the workflow, you always have the possibility to drag and drop files to your workflow at any time which will get imported to your data warehouse via the established connection. Please find the list of supported file formats and size limits here.
If your CARTO organization has been provisioned in a cloud region outside of the US (Europe-West, Asia-Northeast or Australia-Southeast), you will be able to select between two different options in your Sources panel in Workflows:
- Your organization's region. You will only have access to your own 'shared' and 'private' datasets within 'organization data'.
- CARTO's region (US). This one will grant to access to a different 'organization data' provisioned in the US region and also to CARTO's 'demo data'
If you have subscriptions to Data Observatory datasets, they can be used as data sources in Workflows. In order to do so, use the toggle at the bottom of the sources panel to switch between 'Connection' and 'Data Observatory'.
If there are subscriptions available through your current connection, they will be listed by provider and organized as Samples and Subscriptions.
You can add a data source to your workflow's canvas by drag and drop. Once added to the canvas, it will work as any other data source that you can connect to one or more components: