Creating a Connection

Follow these steps to create a connection:

  1. Go to Connections page from the left side menu
  2. Select Import or Export tab
  3. Click on Add New Import/Export Connection button
  4. Select the desired type of connection in the side panel and click Continue
  5. Input the connection detail and click on Connect to continue (additional instruction if you choose BigQuery or S3)
  6. Input the name of the connection and click on Save to finish creating a connection

NOTE

  • To connect with Google Sheet, the file must be shared with [email protected] before importing the file.
  • To get the JSON file to connect to BigQuery, see the Miscellaneous section below.
  • To get the keys needed to connect to S3, see the Miscellaneous section below.

Next:

Generating json file for BigQuery Connection

This step is the required step to connect to Google BigQuery.

  1. Go to Google Cloud Console at https://console.cloud.google.com/
  2. Select the project where the BigQuery data lies
  3. From the left side menu, go to IAM & Admin > Service Accounts
  4. Click on Create New Service Account
  5. Fill in the form and click Create and Continue
  6. Add the necessary permissions and click Continue
ActionsPermissions Needed
ImportBigQuery Job User, BigQuery Viewer
ExportBigQuery Job User, BigQuery Data Editor
  1. Click Done
  2. When the screen is back at the service account list, click on the three dots icon on the Action column and select Manage Keys
  3. Click Add Key > Create new key
  4. Select JSON and click Create
  5. The browser will download a JSON file

Keep the JSON file and use it when creating a connection in Mandala

Getting Keys for S3

  • From your AWS console page, click on the search bar on the top to search
  • Type IAM and click IAM on top of the list
  • Click on Users on the left
  • Click on Add user on top to create a user
  • Input the user name and click the check box for Programmatic access and click Next at the bottom
  • In the set permission screen, select Attach existing policies directly
  • To import data from S3 into Mandala, the minimum policy required to be added is AmazonS3ReadOnlyAccess
  • Click Next at the bottom twice and Create user
  • In the final screen, download credential as .csv or take note of the Access Key and Secret Key
  • Use the Access Key and Secret Key in mandala to connect to the available S3 Buckets to the user