Configuration

Overview

Potens requires some additional configuration settings for Goliath and Magnus applications.  Configuration requirements include specifying destination locations for temporary datasets, FTP, and downloads.  Configuration section also includes setting the Default Email Distribution List

Note: Admin is responsible for setting retention / expiration (usually 1 hour or day) policies for respective resources
Also, if any given setting is not set - respective feature will not be available for the users of given organization

Temporary Dataset 

Goliath provides the option for queries to be to run in enhanced mode for Legacy SQL.  Enhanced mode allows for nested / repeated data types to be displayed without being flattened.  In order to display this data, presentation data is stored in temporary tables. The value in Temporary Dataset represents the dataset where these temporary tables will be created. 

Org users should have Edit permission for the dataset.

To add or update Temporary Dataset

1. Add value for dataset name
2. Click update

Default Email Distribution List 

As described in Billing Project > Distribution Lists sections, Magnus workflows can be set to a maximum lifetime of 90 days.  When these workflows are about to expire, an email notification is sent.  Distribution List is where the email is sent to.  If no distribution list is specified in Billing Project > Distribution Lists, then the emails will be sent to users in Default Email Distribution List. 

To add or update Default Email Distribution List

1. Add email address
2. Click Update

Temporary FTP Bucket 

Magnus features an FTP task.  This task allows for data (BigQuery Table) to be FTP'ed to a destination.  File is temporarily placed in Google Cloud Storage as part of the FTP task process.  Temporary FTP Bucket represents the Google Cloud Storage bucket where these files will be temporarily placed.

Org users should have permission to create objects in those buckets.

To add or update Temporary FTP Bucket

1. Add name of Google Cloud Storage bucket
   Add the name only (i.e. bucketname). Do not include the full path (i.e. gs://bucketname).
2. Click update

Temporary FTP Directory

Temporary FTP Directory is an optional directory under the Temporary FTP Bucket where FTP files will be temporarily placed as part of the FTP task process.

Org users should have permission to create objects in those buckets.

 To add or update Temporary FTP Directory

1. Add name of directory available in Temporary FTP Bucket
2. Click update

Temporary Downloads Bucket

Goliath features the ability to download query results.  Results that are large in file size first need to be loaded to Google Cloud Storage before they can be downloaded.  Temporary Downloads Bucket references the name of the Google Cloud Storage bucket where these files will be uploaded to as part of the download process.

Org users should have permission to create objects in those buckets.

To add or update Temporary Downloads Bucket

1. Add name of Google Cloud Storage bucket.
   Add the name only (i.e. bucketname). Do not include the full path (i.e. gs://bucketname).
2. Click update

Temporary Downloads Directory 

Temporary Downloads Directory is an optional directory under the Temporary Downloads Bucket where downloaded data will temporarily be places as part of the download process.

To add or update Temporary Downloads Directory

1. Add name of directory available in Temporary Downloads Bucket
2. Click update