This may be because the data warehouse connection associated with the workflow does not have the required permissions to run Workflows in the data warehouse, such as the permission of creating schemas in the Workflows temp. location (configured in the advanced options of the connection card). Please choose or create another connection with data owner permissions or modify the permissions in the current connection and try again. If the issue persists, please contact our support team at [email protected].
In order to function, CARTO Workflows creates a temporal dataset in BigQuery named
workflows_tempin where to store temporary objects needed to fully execute a workflow. In BigQuery, we create such dataset in the default region of the GCP project associated to the BigQuery connection. If you then want to include in a workflow data sources that are stored in another region different to the "default" one of your GCP project, then you need to create a new
workflows_tempdataset in that other region and specify its location in the Advanced options of your BigQuery connection.
In order to guarantee a successful execution of a workflow via a Snowflake connection, please make sure that in the settings of the connection you have specified the database of your Snowflake account with which you want to work via that specific connection. This field is now required by CARTO Workflows. Note that you can edit an existing connection at any time.