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:

  1. Open the list of Bigtable instances in the Google Cloud console.

    Open the instance list

  2. Click the instance that contains the table you want to export.

  3. Click Tables in the left pane.

    The Tables page displays a list of tables in the instance.

  4. Next to the name of the table you want to export, click the Table action menu.

  5. In the Export to Cloud Storage as menu section, click the file type you want.

    The console displays a partly completed Dataflow template.

  6. 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