CARTO Writer Parameters
About Database Connections |
---|
Database formats include a Database Connection parameter that defines and stores authentication information. For general information about sharing database connections, please see 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:
|
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.