Stay organized with collections Save and categorize content based on your preferences.

Import and export data

This page lists available methods for importing and exporting data into and from Cloud Bigtable.

If you need to protect against data corruption or accidental deletion, you can create and restore Bigtable backups, without needing to export or import using another service.

Move or copy data

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 gcloud command-line tool 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 command-line tool 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 gcloud command-line tool 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 Overflow menu.

  5. Hold the pointer over Export to, then 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.

Migrate data from another database to Bigtable

HBase

If you need to migrate data from HBase to Bigtable, use the following tutorial, which offers variants for different types of data:

Import CSV data

Follow this tutorial to learn how to import a CSV file into Bigtable:

What's next