CARTO Writer Parameters
This parameter must contain the name of the destination CARTO account. The account name is the same as the username that is used to log into the account on the CARTO website.
Note: For CARTO Multiuser Enterprise accounts, note that this is not the same as the organization name.
CARTO accounts are protected by API keys, which can be found in Your API keys in the CARTO web interface. By default, the API key parameter is left blank.
- If the API key is left blank, FME can read public tables associated with the CARTO account.
- If the API key is specified, FME can read both public and private tables associated with the CARTO account.
When using CARTO Multiuser Enterprise, multiple users can be associated with one account.
If you are Multiuser Account user, enter your username here. FME will access the associated CARTO Multiuser Account.
Note: To create tables in a Multiuser Account, you must select this parameter and supply a valid username.
Advanced
This parameter specifies the number of features to be placed in each transaction before a transaction is committed to the database.
If not specified, the default value is 500.
This parameter specifies whether the writer should use the COPY API to perform bulk writes. For more information, see https://carto.com/developers/sql-api/guides/copy-queries/.
The COPY interface should be faster in most cases, but may have a different data usage profile and can cause issues with CARTO platform limits. See https://carto.com/help/getting-started/limits/.
If not specified, the default value is Yes.