Company
Date Published
July 30, 2024
Author
CARTO Contributors
Word count
601
Language
English
Hacker News points
None

Summary

The CARTO Python SDK introduces new COPY methods for bulk ingestion of data into CARTO, providing a performant way to transfer data in chunks with compression by default. The implementation takes care of data formatting and uses the PostgreSQL COPY statement, making it easier to work with CSV files, transferring tables between accounts, loading data from external services, and more. The SDK is designed to be a reference client for the SQL API, offering control over the process and faster data transfer in a more pythonic fashion. With this new interface, users can simplify their client app and integration development while keeping the advantages of using the SQL API and underlying services.