Skip to content

export_table_to_datastore

export_table_to_datastore(fully_qualified_table, key_column, datastore_path)

Description

Export fully_qualified_table to datastore

Usage

Call or Deploy export_table_to_datastore ?
Call export_table_to_datastore directly

The easiest way to use bigfunctions

  • export_table_to_datastore function is deployed in 39 public datasets for all of the 39 BigQuery regions.
  • It can be called by anyone. Just copy / paste examples below in your BigQuery console. It just works!
  • (You need to use the dataset in the same region as your datasets otherwise you may have a function not found error)

Public BigFunctions Datasets

Region Dataset
eu bigfunctions.eu
us bigfunctions.us
europe-west1 bigfunctions.europe_west1
asia-east1 bigfunctions.asia_east1
... ...
Deploy export_table_to_datastore in your project

Why deploy?

  • You may prefer to deploy export_table_to_datastore in your own project to build and manage your own catalog of functions.
  • This is particularly useful if you want to create private functions (for example calling your internal APIs).
  • Get started by reading the framework page

Deployment

export_table_to_datastore function can be deployed with:

pip install bigfunctions
bigfun get export_table_to_datastore
bigfun deploy export_table_to_datastore

Examples

load random csv

call bigfunctions.eu.export_table_to_datastore("your-project.dataset.table", "user_id", "your-project/default/default/users");
select * from bigfunction_result;

call bigfunctions.us.export_table_to_datastore("your-project.dataset.table", "user_id", "your-project/default/default/users");
select * from bigfunction_result;

call bigfunctions.europe_west1.export_table_to_datastore("your-project.dataset.table", "user_id", "your-project/default/default/users");
select * from bigfunction_result;


+---------+
+   key   +
+---------+
+  12345  +
+  23455  +
+   ...   +
+---------+
Need help or Found a bug?
Get help using export_table_to_datastore

The community can help! Engage the conversation on Slack

We also provide professional suppport.

Report a bug about export_table_to_datastore

If the function does not work as expected, please

  • report a bug so that it can be improved.
  • or open the discussion with the community on Slack.

We also provide professional suppport.

Show your ❤ by adding a ⭐ on