paradedb / pg_analytics

DuckDB-powered analytics for Postgres
https://paradedb.com
PostgreSQL License
383 stars 15 forks source link

Doc: How do I configure the access_key and access_secret? #161

Closed cobolbaby closed 1 month ago

cobolbaby commented 1 month ago

What happens?

Where do I configure the access_key and access_secret? Isn't a key required to access S3?

To Reproduce

CREATE EXTENSION pg_analytics;
CREATE FOREIGN DATA WRAPPER parquet_wrapper HANDLER parquet_fdw_handler VALIDATOR parquet_fdw_validator;

-- Provide S3 credentials ???
CREATE SERVER parquet_server FOREIGN DATA WRAPPER parquet_wrapper;

-- Create foreign table with auto schema creation
CREATE FOREIGN TABLE fact_pca_yield_statistics_parquet ()
SERVER parquet_server
OPTIONS (files 's3://infra-oss.ipt.inventec.net/databricks/BDC/IPT_PG/bdc/dw/fact_pca_yield_statistics/fact_pca_yield_statistics-full.parquet');

OS:

x86_64

ParadeDB Version:

0.1.4

Are you using ParadeDB Docker, Helm, or the extension(s) standalone?

ParadeDB pg_analytics Extension

Full Name:

Cobol

Affiliation:

Inventec

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include the code required to reproduce the issue?

Did you include all relevant configurations (e.g., CPU architecture, PostgreSQL version, Linux distribution) to reproduce the issue?

philippemnoel commented 1 month ago

Docs are here: https://docs.paradedb.com/integrations/object_stores/s3