Import and export data
This page lists available methods for importing and exporting data into and from Bigtable.
Export data from BigQuery
To export BigQuery data to Bigtable, see Export data to Bigtable (Reverse ETL). (Preview)
Move or copy data using a template
BigQuery
The following Dataflow template lets you export data from BigQuery to Bigtable.
Apache Cassandra to Bigtable
The following Dataflow template lets you export data from Apache Cassandra to Bigtable.
Avro files
The following Dataflow templates allow you to export data from Bigtable as Avro files and then import the data back into Bigtable. You can execute the templates by using the Google Cloud CLI or the Google Cloud console. The source code is on GitHub.
Parquet files
The following Dataflow templates allow you to export data from Bigtable as Parquet files and then import the data back into Bigtable. You can execute the templates by using the gcloud CLI or the Google Cloud console. The source code is on GitHub.
SequenceFiles
The following Dataflow templates allow you to export data from Bigtable as SequenceFiles and then import the data back into Bigtable. You can execute the templates by using the Google Cloud CLI or the Google Cloud console.
Export from the Tables page
You can also export Avro files, Parquet files, or SequenceFiles directly from the Tables page in the Google Cloud console:
Open the list of Bigtable instances in the Google Cloud console.
Click the instance that contains the table you want to export.
Click Tables in the left pane.
The Tables page displays a list of tables in the instance.
Next to the name of the table you want to export, click the
Table action menu.In the Export to Cloud Storage as menu section, click the file type you want.
The console displays a partly completed Dataflow template.
Fill out the rest of the form and click Run job.
Import CSV data
You can use the
cbt
CLI
to import data from a CSV file into a
Bigtable table. For more information, see Batch
write many rows based on the input
file.
What's next
- Create, copy, or restore from a Bigtable backup.
- Explore concepts related to designing a Bigtable schema.
- Migrate to Bigtable.