Open Data includes an editable dataset which gives users full access, allowing them to make changes or even uploading additional data.
This is useful if you want to enrich your data by adding additional meta-data, or if you need to export large data sets.
Editable datasets are owned and maintained by you, the customer, which means that you are responsible for providing and managing access to this data. As these datasets exist outside of the Emarsys Data Protection features, it also means that you have to own all data related topics including data expiration, deletion, rectification, and exports. Because of this Emarsys is not liable for any incident relating to editable datasets as it is your responsibility to use the Emarsys services in an appropriate manner.
Importing data manually
It is possible to enrich your data stored in Open Data (e.g. by adding additional meta-information about your campaigns etc.) by importing the additional information into the editable_dataset.
You can import data either directly into the editable dataset, or by dropping a CSV file into the Google Cloud bucket. For more information, please refer to Google's support pages.
Importing data via the API
To make programmatically data uploading possible from Open Data we prepared a Service Account. You can generate a new API key for your Service Account by following the steps in the Creating an API key section.
While you can use Google Cloud APIs by making direct HTTP requests to BigQuery, Google provides client library code for all their Cloud APIs that make it easier to access them from your favorite languages. You can access the detailed REST documentation here or the available client libraries here.
Importing large datasets
In case you want to load files bigger than 10 MB or containing more than 16,000 rows, you’ll need to import the data into the a Cloud Storage Bucket first and then import into the editable_dataset. To learn more about loading data from Cloud Storage, visit Google’s support pages.
- Type your project name in the search field. All Open Data Google Cloud Platform Project names follow the
ems-od-<customer>naming convention. Sometimes the project name isn't visible at first, so we suggest using always the search functionality.
- Click your project’s name to open it.
To learn more about Google Cloud Platform projects, visit Google’s support pages.