# ingestr - 명령 하나로 DB간 데이터를 복사해주는 CLI 도구

> Clean Markdown view of GeekNews topic #13578. Use the original source for factual precision when an external source URL is present.

## Metadata

- GeekNews HTML: [https://news.hada.io/topic?id=13578](https://news.hada.io/topic?id=13578)
- GeekNews Markdown: [https://news.hada.io/topic/13578.md](https://news.hada.io/topic/13578.md)
- Type: news
- Author: [xguru](https://news.hada.io/@xguru)
- Published: 2024-02-29T10:04:01+09:00
- Updated: 2024-02-29T10:04:01+09:00
- Original source: [github.com/bruin-data](https://github.com/bruin-data/ingestr)
- Points: 21
- Comments: 0

## Topic Body

- 코드 없이 명령 하나만으로 데이터 복사 가능   
  - `ingestr ingest --source-uri $POSTGRES_URI --source-table 'schema.table_name' --dest-uri $BIGQUERY_URI`  
- 인크리멘탈 로딩: append, merge 또는 delete + insert   
- 지원 DB : Postgres, BigQuery, Snowflake, Redshift, Databricks, DuckDB, SQLServer, CSV,  
  - Oracle, SQLite, MySQL 은 Source로만 가능

## Comments



_No public comments on this page._