# Is there any way to import datapoint/table from S3

**URL:** <https://community.influxdata.com/t/is-there-any-way-to-import-datapoint-table-from-s3/1177>\
**Category:** Systems\
**Tags:** influxdb, telegraf, collectd, influxdata\
**Created:** [June 5, 2017, 6:47pm UTC](https://community.influxdata.com/t/is-there-any-way-to-import-datapoint-table-from-s3/1177 "2017-06-05T18:47:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hitesh\_Jhamb](https://avatars.discourse-cdn.com/v4/letter/h/8edcca/32.png) [@Hitesh\_Jhamb](https://community.influxdata.com/u/Hitesh_Jhamb)\
**Post date:** [June 5, 2017, 6:47pm UTC](https://community.influxdata.com/t/is-there-any-way-to-import-datapoint-table-from-s3/1177/1 "2017-06-05T18:47:07Z")

</div>

Currently, my whole data is present in AWS Redshift and Snowflake. (I can copy these data to AWS S3 in csv/tsv format)

Is there any any way to copy/migrate/import data from above location ?

Here, table size is in hundreds of GBs.

Found links - [docker-influxdb-to-s3/influxdb-to-s3.sh at master · jacobtomlinson/docker-influxdb-to-s3 · GitHub](https://github.com/jacobtomlinson/docker-influxdb-to-s3/blob/master/influxdb-to-s3.sh)

For example : Similar feature exposed by Redshift/Snowflake to copy from S3 -  
[Redirecting to …](https://docs.snowflake.net/manuals/sql-reference/sql/copy-into-table.html)

---

<div class="post-metadata">

**Author:** ![jackzampolin](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/jackzampolin/32/5_2.png) [@jackzampolin](https://community.influxdata.com/u/jackzampolin)\
**Post date:** [June 6, 2017, 7:21pm UTC](https://community.influxdata.com/t/is-there-any-way-to-import-datapoint-table-from-s3/1177/2 "2017-06-06T19:21:15Z")

</div>

@Hitesh_Jhamb The `influxdb-to-s3` example you show there is a method to backup a running InfluxDB instance to s3. That will not do the other way around.

The best way to do this is by using the [client libraries for InfluxDB](https://docs.influxdata.com/influxdb/v1.2/tools/api_client_libraries/#main-nav) and the corresponding client library for Redshift/Snowflake. Then you can use something like AWS Lambda to do the ETL and get your data into InfluxDB in the proper format.