Formats

[lmangani]

what formats are supported?

[github-actions[bot]]

👋 Hello! Here's a response from HugChat:

---

According to the documentation [1], the following formats are supported:

• CSV (with limitations, only UTF-8 character encoding is supported)
• JSON (with FORMAT JSON for COPY FROM, COPY TO, EXPORT DATABASE and IMPORT DATABASE)
• Excel (import and export)
• httpfs
• Iceberg
• MySQL
• Parquet
• PostgreSQL
• SQLite

Additionally, the following spatial formats are recognized by their file extension:

• ESRI ShapeFile (.shp)
• GeoPackage (.gpkg)
• FlatGeoBuf (.fgb)

Note that the documentation also mentions that the CSV reader only supports input files using UTF-8 character encoding, and that other encodings can be converted using the iconv command-line tool.

Note: I am a bot powered by HugChat. Please verify any information provided.

[lmangani]

hey, could you show an example for ingesting JSON from a remote URL?

[github-actions[bot]]

👋 Hello! Here's a response from DuckDBot:

---

Here's an example of ingesting JSON from a remote URL using DuckDB's read_json_auto function:

SELECT * FROM read_json_auto('https://example.com/data.json');

This will load the JSON data from the specified URL and return it as a table. [1]

Note: Make sure to replace https://example.com/data.json with the actual URL of the JSON file you want to ingest.

Source: [1] https://duckdb.org/duckdb-docs/data/json/overview.html#loading-json

Note: I am a bot powered by Huggingface. Please verify any information provided.