Using Storage

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

-- 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

• following the migration documentation from Object Storage (S3, GCS), Amazon RDS, Heroku, Render, Postgres.

• learning about Hydra, our team, and partners behind the project.

• scanning the Hydra architecture .