CARTO Writer Parameters

Database formats include a Database Connection parameter that defines and stores authentication information. For general information about sharing database connections, please see Using Database Connections.Using Database Connections.

Note that Database Connection parameters differ slightly, depending on context and/or database format.

Connection

From the Connection parameter in a database format, you can do one of the following:

  • Select an existing, previously defined connection. See the section Reusing a Database Connection in Using Database Connections
  • Select Add Database Connection to define a new connection. See database-specific parameters below, as well as the section Adding a Database Connection in a Workspace in Using Database Connections. The new connection can be made visible only to the current user, or can be shared among multiple users.

Database Connection

Select an existing CartoDB connection, or Add Database Connection...

Add CartoDB Connection

To define a new connection from the Connection parameter in a CartoDB format, see the topic CARTO: Add Database Connection

Features Per Transaction

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.

Use COPY Bulk API

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.