Results of 1 - 8 of about 8 for Encryption (0.002 sec.)
- Parquet Encryption 12995
- Starting with version 0.10.0, DuckDB supports reading and writing encrypted Parquet files. DuckDB broadly follows the Parquet Modular Encryption specification with some limitations . Reading and Writing Encrypted Files Using the PRAGMA add_
...parquet_key function, named encryption keys of 128, 192, or 256 bits can be added to a session. These keys are stored in-memory: PRAGMA add_parquet_key('key128',...pted Parquet Files After specifying the key (e.g., key256 ), files can be encrypted as follows: COPY tbl TO 'tbl.parquet' (ENCRYPTION_CONFIG {footer_key: 'key256'}); Reading Encrypted Parquet Files An encrypted Parquet file using a specific key (e.g., key2...56 ), can then be read as follows: COPY tbl FROM 'tbl.parquet' (ENCRYPTION_CONFIG {footer_key: 'key256'}); Or: SELECT * FROM read_parquet('tbl.parquet', encryption_config = {footer_key: 'key256'});... - https://man.mtool.work/duckdb/2.0/data/parquet/encryption.html
- ATTACH and DETACH Statements 11061
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...grading to DuckDB 2.0.0, see the migration guide . For more details on storage versions, see the “Storage” page . Database Encryption DuckDB supports database encryption. By default, it uses AES encryption with a key length of 256 bits using the recommende...d GCM mode. The encryption covers the main database file, the write-ahead-log (WAL) file, and even temporary files. To attach to an encrypted databas...e, use the ATTACH statement with an ENCRYPTION_KEY . ATTACH 'encrypted.db' AS enc_db (ENCRYPTION_KEY 'quack_quack'); To encrypt data, DuckDB can use either the built-in... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- Querying Parquet Metadata 8205
- Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different columns. This can be useful
...le Metadata The parquet_file_metadata function can be used to query file-level metadata such as the format version and the encryption algorithm used: SELECT * FROM parquet_file_metadata('test.parquet'); Below is a table of the columns returned by parquet_f...ile_metadata . Field Type file_name VARCHAR created_by VARCHAR num_rows BIGINT num_row_groups BIGINT format_version BIGINT encryption_algorithm VARCHAR footer_signing_key_metadata VARCHAR file_size_bytes UBIGINT footer_size UBIGINT column_orders VARCHAR[]... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Reading and Writing Parquet Files 8205
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...ts for NaN when using a column's min/max statistics for filter pushdown, since NaN does not compare as ordered. BOOL false encryption_config Configuration for Parquet encryption . STRUCT - filename Whether or not an extra filename column should be included...details: Export the table contents of the entire database as Parquet: EXPORT DATABASE 'target_directory' (FORMAT parquet); Encryption DuckDB supports reading and writing encrypted Parquet files . Supported Features The list of supported Parquet features is... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- Lakehouse Formats 8097
- Lakehouse formats, often referred to as open table formats, are specifications for storing data in object storage while maintaining some guarantees such as ACID transactions or keeping snapshot history. Over time, multiple lakehouse formats
...table ✅ ✅ ❌ ❌ Rename columns ✅ ✅ ❌ ✅ Add/drop columns ✅ ✅ ❌ ✅ Alter column type ✅ ✅ ❌ ✅ Compaction and maintenance ✅ ✅ ❌ ✅ Encryption ✅ ❌ ❌ ❌ Manage table properties ✅ ✅ ✅ ** ❌ Time travel ✅ ✅ ✅ ❌ Query table changes ✅ ❌ ❌ ❌ * Through the unity_catalog ext... - https://man.mtool.work/duckdb/2.0/lakehouse_formats.html
- S3 API Support 8043
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...ount ID to use for generating the endpoint URL R2 STRING - KMS_KEY_ID AWS KMS (Key Management Service) key for Server Side Encryption S3 S3 STRING - REQUESTER_PAYS Allows use of "requester pays" S3 buckets S3 BOOLEAN false REFRESH Set to auto to periodical...pfs_enable_credential_refresh = false; Platform-Specific Secret Types S3 Secrets The httpfs extension supports Server Side Encryption via the AWS Key Management Service (KMS) on S3 using the KMS_KEY_ID option: CREATE OR REPLACE SECRET secret ( TYPE s3, PRO... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- MySQL Extension 7844
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...files ssl_cert The path name of the client public key certificate file ssl_cipher The list of permissible ciphers for SSL encryption ssl_crl The path name of the file containing certificate revocation lists ssl_crlpath The path name of the directory that... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Configuration 7753
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...Set the directory to which temporary files are written. VARCHAR ⟨database_name⟩.tmp or .tmp (in in-memory mode) temp_file_encryption Encrypt all temporary files, if the database is encrypted. BOOLEAN false threads , worker_threads The number of total back... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work