How I can access the data in my Google Bigquery?
Input your gmail account
- Navigate to Developers - Shared Dataset and input a
gmail account, with an active GCP project
and BigQuery enabled.
Pin the dataset to your Google Bigquery
- On your browser enter the BQ URL for the sharing project: https://console.cloud.google.com/bigquery?project=bi-analytics-253109
- Select the project bi-analytics-253109 on the data resource browser on the left and select pin project.
- Go back to your BigQuery console and will now see the shared project listed there as well.
The name of the project (i.e
my-project) that you see on the top navbar with the dropdown arrow will be used as the billing project.
Billing occurs only when you run a query. Read more here.
Query the data
Since the data is shared to your account you can query the data directly, or include these in your views.
i.e SELECT * FROM `bi-analytics-253109.prj_xx_db_shared._campaigns` LIMIT 1000
You can check Maya dataset schema here.
At the moment we only support datasets located in eu (multiple regions in European Union).
To query the shared dataset through your dataset, your dataset should also be located in the same region.
Can I use my own Google Bigquery as the only source of data?
For our service to work, which includes our algorithms to run and our dashboards to be functional, we need to have a specific structure. By specific structure we mean specific tables and specific columns types and names, where any change on these can impact essential functionality or features from functioning correctly. At the moment we can only share the database that we keep with you.
In case I decide to stop using Maya can I get a copy of my data?
In case you decide to stop using Maya, upon request we can provide you with a copy of your dataset at that specific state (it will not update).
Can I get a copy of the data to my MySQL, PostgreSQL, MSSQL, Redshift, Snowflake etc?
At the moment we only support Google Bigquery.
We would be happy to answer any questions you may have! Send us an email at [email protected].