Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Enhance COPY .. FROM to accept an S3 URL just like it accepts a file path #12544

Closed
ubendre opened this issue May 18, 2022 · 3 comments
Closed

Enhance COPY .. FROM to accept an S3 URL just like it accepts a file path #12544

ubendre opened this issue May 18, 2022 · 3 comments
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue

Comments

@ubendre
Copy link

ubendre commented May 18, 2022 •
edited by jira bot
Loading

Jira Link: [DB-415](https://yugabyte.atlassian.net/browse/DB-415)

Description

Once #11453 is done, I guess we could point to any large csv/text file from any node, and initiate the COPY FROM which will distribute the workload internally. It would be great if instead of a file, we can supply an S3 location directly.
@ubendre ubendre added area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels May 18, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels May 18, 2022
@ddorian
Copy link
Contributor

ddorian commented May 18, 2022

This can still be done with some command line magic such as https://stackoverflow.com/questions/41696675/how-to-copy-a-csv-file-from-a-url-to-postgresql

@ddorian
Copy link
Contributor

ddorian commented Jun 2, 2022 •
edited
Loading

cc @sushantrmishra

@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug status/awaiting-triage Issue awaiting triage labels Jul 27, 2022
@sushantrmishra
Copy link

We have launched schema and data migration tool YugabyteDB Voyager

Support for data import from S3 is on roadmap for YugabyteDB Voyager yugabyte/yb-voyager#171

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@ddorian @sushantrmishra @yugabyte-ci @ubendre