Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.hydra.so/llms.txt

Use this file to discover all available pages before exploring further.

Connect Hydra with an existing object storage bucket to begin inserting data. Here are the steps to moving data from object storage, Postgres, and local files into Hydra. To learn more, navigate to the Storage documentation.

​
Insert existing data

Note: Select between the tabs in the codebox below to view instructions.
-- Connect bucket, Session token is optional
INSERT INTO duckdb.secrets
 (type, key_id, secret, session_token, region)
 VALUES ('S3', 'access_key_id', 'secret_access_key', 'session_token', 'us-east-1');

-- example: create a table in the analytics schema from a file in S3.
CREATE TABLE analytics.your_table_name 
USING duckdb
AS
SELECT *
FROM read_parquet('s3://your_bucket_name/your_file_name.parquet') AS
(
   -- specify columns and types here, e.g.:
   -- id int,
   -- name text, ...
);
For additional settings and options navigate to our S3 or Postgres migration documentation.

​
What’s Next?

We recommend