Exporting Partitioned Parquet Datasets from DuckDB with COPY TO
Learn how to write query results to a Hive-style partitioned Parquet dataset using DuckDB's COPY TO, validate the output, and recover from common write failures.
Loading…
ReadMeFeed / Community knowledge
#data-export
Real questions. Useful conversations. Find the people who know your stack.
duckdbExporting Large Datasets in DBeaver: Avoiding Memory Crashes and Dialect Errors
Learn how to use DBeaver's Export Data wizard to move large datasets to CSV or SQL without triggering OutOfMemory errors by optimizing fetch sizes and dialects.
dbeaverExporting Query Results from SQL Developer with the Data Export Wizard
Learn how to export SQL Developer query results to CSV, Excel, or other formats using the Data Export Wizard and reuse settings with saved templates.
sqldeveloperChoosing the Right Data Export Format in DataGrip for Large Datasets
Learn how to choose between CSV, JSON, and SQL Insert formats in DataGrip to avoid IDE memory crashes and ensure data integrity during large exports.
datagripExporting Query Results to CSV in Oracle SQL Developer
Learn how to export query results from Oracle SQL Developer to a CSV file using the Export Wizard, with step‑by‑step instructions, verification steps, and recovery tips.
DataFrame.to_csv index=True default and accidental public exposure
Goal is to prevent accidental public access to internal row identifiers when a DataFrame is exported with to_csv. The index column can carry row numbers or surrogate keys that are meaningful inside a pipeline but are not intended for external sharing. The documented behavior is that DataFrame.to_csv writes the index as the first column unless index=False is
pandasNew Relic One API ↔ Data Export pagination behavior for large NRQL facet sets
An integration between New Relic One API NRQL queries and Data Export workflows needs a clear contract for completeness when facet cardinality is high. The One API exposes NRQL via a REST endpoint with query, page and pageSize parameters. Pagination is page-number based with a default pageSize of 100 and a documented maximum of 10,000 per request. Documentat
newrelicSalesforce Data Export restoration and System ModStamp preservation
The Salesforce Weekly Data Export service provides record-level backups in CSV format, which are typically restored using the Data Loader or Bulk API. While this process recovers object data, the restoration involves creating new records or updating existing ones via API calls. A specific challenge arises when attempting to maintain the original audit trail
salesforceDoes New Relic preserve custom attributes during export‑import cycles?
Goal: Confirm that custom attributes attached to New Relic events survive a full export‑import cycle without loss or alteration. The process relies on the Data Export API to pull a known time window of JSON payloads and the Events API to re‑ingest that payload into a test account. Because the export may drop null‑valued fields or reorder keys, and because re