Skip to main content

BigQuery

Overview​

This document explains how to grant Unwrap access to your BigQuery data. We use Google Cloud service accounts to securely access only the specific data you authorize.

Step 1: Grant Access to Our Service Account​

  1. Log in to your Google Cloud Console at https://console.cloud.google.com/
  2. Navigate to BigQuery by clicking on "BigQuery" in the navigation menu
  3. Find the dataset you want to share in the Explorer panel
  4. Click on the dataset name to open it
  5. Click on "SHARE DATASET" button at the top
  6. In the "Add principals" field, enter our service account email:
    unwrap-data-read@bigqueryconnector-452922.iam.gserviceaccount.com
  7. Select the appropriate role:
    • BigQuery Data Viewer - For read-only access
  8. Click "Add" and then "Done"

Step 2: Specify Tables or Views (Optional)​

Give Unwrap access to the tables or views you want to analyze.

Option A: Share Individual Tables​

  1. In BigQuery, navigate to the specific table you want to share
  2. Click on the table name, then select "Share" from the actions menu
  3. Add our service account email and assign the appropriate permission
  4. Repeat for each table you want to share
  1. Create a view that exposes only the data you want to share:
    CREATE VIEW `your-project.your_dataset.your_view_name` AS
    SELECT column1, column2, ...
    FROM `your-project.your_dataset.your_table`
    WHERE [optional filtering conditions];
  2. Share only this view with our service account following Step 1 above
  3. This ensures we can only see the specific data defined in the view

Security Information​

  • Our service account will only have access to the specific datasets, tables, or views you explicitly share
  • Access can be revoked at any time by removing our service account from the permissions list
  • All data access is logged in your Google Cloud audit logs
  • For questions about security, please contact [contact@unwrap.ai]

Need Help?​

If you have any questions or encounter any issues while setting up access, please contact us at [contact@unwrap.ai].