cockroachdb / cockroachdb/cockroach
sql: import should support loading only data from a dump
Open
A-import
C-enhancement
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Currently IMPORT INTO supports loading into tables using CSVs. This is cumbersome if we want to load 100 CSVs into 100 tables. Users will have to write a script which is not always convenient. With the deprecation of IMPORT PGDUMP/MYSQLDUMP Especially with https://github.com/cockroachdb/cockroach/issues/93660 we need a mechanism that can ignore the DDL in a mysql/pgdump and ingest the data portion.
```
IMPORT FROM DUMP mysql/pgdump;
```
Jira issue: CRDB-24974
Contributor guide
Assessment
This issue has not been assessed yet.