To connect Periscope Data to a BigQuery database, please make sure to have to the following prior to attempting a connection:
Here are instructions for getting each:
Add a new credential for Periscope Data by creating a Service account from the Google Developers Console:
Important: This must be a
.p12 file, not a
.p12 file that is generated that will be uploaded when filling out the Connect form. Next go back to the credentials tab and click the new service account.
From the Service account page, also note the copy of the Client ID and Email address.
Note the project ID from the home tab (in this example,
Finally, set the service account for Periscope Data to be read-only. Click Permissions in the top-left corner of the Google Developers Console:
And set the service account's setting to "Can View"
BigQuery databases support two distinct SQL dialects: Legacy SQL and Standard SQL. The default dialect that Periscope will use on the database can be specified in the database connection menu.
All queries running against the BigQuery database will use the selected dialect by default. At the query level, the default selection can be overridden by including the tag #standardSQL or #legacySQL on the first line.