There are two ways to run queries and export data from your Open Data datasets: manually on the BigQuery web UI or automatically using the BigQuery API.
We are constantly making new datasets available in Open Data. To see the datasets you can currently work with, click here.
Exporting data manually
To run queries and export data using the BigQuery web UI, proceed as follows:
If you have access to more datasets, you can see all of these listed in the navigation bar. The name of each one is made up of the project name and a unique dataset ID (e.g. emarsys_project_214535).
- Click the name of the table you want to work with.
- Click Compose Query at the top of the navigation bar.
- Type your query in the New Query box.
Keep in mind that by using slow and ineffective queries you can exceed your BigQuery limit rapidly. To avoid executing such queries, we recommend following Google’s BigQuery best practices.
To run queries using standard SQL, you have to uncheck the Use Legacy SQL option, which is enabled by default. To do so, click Show Options and in the SQL Dialect line uncheck Use Legacy SQL.
If you are not familiar with the standard SQL syntax or if you want to learn more about it, please read the BigQuery Standard SQL Reference documentation.
- Click Run Query to execute the query.
- Download or save your query results by clicking either Download as CSV, Download as JSON, Save as Table or Save to Google Sheets.
If your query result set has fewer than 16,000 rows and is smaller than 10 MB in size, you can download it as a CSV or newline-delimited JSON file or save it to Google Sheets. Otherwise, you can only save it as a table.
Exporting data via the API
To feed behavior data automatically to your reporting or BI solutions, follow the Google BigQuery API Reference. If you need help with this, please contact your Success Manager.
Managing access to Open Data
When we enable Open Data for you, we also automatically create a Google group for your organization. The Google account you provided at the start has the manager role in the group by default, and allows you to manage user access to your BigQuery datasets.
Anyone you add or invite to the group will be able to log in to Google BigQuery to run queries and export data.
Your users must have a Google account to log in to BigQuery. So make sure to use email addresses associated with a Google account when you add people to your Google group!
This way, you can grant access to your datasets either to people in your organization or to external consultants.
Granting and revoking access
To add people to your group or remove them, proceed as follows:
- Sign in to Google Groups.
- Click My Groups.
- Select Switch organization view to: emarsys.com.
- Under the name of the Open Data group you want to manage, click Manage.
If you are responsible for the marketing of several different brands or subsidiaries, you may see more groups associated with your organization on this page.
- This brings you to the Members page, on which you can add users to the group, remove users or promote users to the manager role.
To learn more about how you can manage your Google group, visit Google’s support pages.