Sisense / Periscope (beta)

Follow these steps to connect your Sisense/Periscope instance to Select Star.

Before you start
To connect Periscope to Select Star, you will need...
Active Periscope Account email and password credentials or Google Account credentials, for Google SSO-enabled accounts
To calculate lineage and popularity based on the last 90 days of users' activity, you'll need to connect Select Star to the Data Warehouse that your Periscope instance is using to run queries.
To calculate popularity and top users, Select Star requires a mapping of periscope users to their email addresses, you'll need to prepare a CSV file with a user name: email mapping.
Complete all of the following steps to see Periscope metadata, lineage, and popularity in Select Star.
1.​Create an Account Authentication Token (optional, only if you're using Google Single Sign-On)
2.​Connect Periscope to Select Star​
3.​Import User Catalog​
1. Create an Account Authentication Token
Optional, only for Google SSO-enabled accounts
Prepare your Google Account credentials and contact Select Star support to help you with the setup process.
After completing the procedure, you should receive a file named periscope-credentials.json. Please save it, as you will need this file in step 2.
2. Connect Periscope to Select Star
Go to the Select Star Settings. Click Data in the sidebar, then + Add to create a new Data Source.
Choose Sisense/Periscope in the Source Type dropdown and provide the following information:
For email / password authentication please leave the default Email and Password Credentials checked. If your account uses Google SSO to authenticate, check Cookies json.
Email and Password
Display Name: This value is Sisense / Periscope by default, but you can override it if desired.
Email: Your Periscope Account email
Password: Your Periscope Account password
DB Connection: The database you are running Periscope on top of.
DB Username: The name of the service account user that runs Periscope queries in your DB Connection. It is not a Select Star service account. This is used to identify which queries Periscope runs so that Select Star can generate lineage between the database and Periscope.
Google SSO Authentication
Display Name: This value is Sisense / Periscope by default, but you can override it if desired.
Google Auth credentials JSON file: The periscope-credentials.json file created in step 1.
DB Connection: The database you are running Periscope on top of.
DB Username: The name of the service account user that runs Periscope queries in your DB Connection. It is not a Select Star service account. This is used to identify which queries Periscope runs so that Select Star can generate lineage between the database and Periscope.
Click the Connect button.
Your metadata should start loading automatically. Please allow 24-48 hours to completely generate popularity and lineage.
When the sync is complete, you'll be able to explore Periscope in Select Star.
3. Import User Catalog
Although this step is optional, you won't see popularity / top users unless the catalog is imported.
To complete the import, please prepare a CSV file with at least the following columns:
First Name
Last Name
Email
Alternatively:
Full Name
Email
and then contact Select Star support, [email protected] to do the import for you.

Sigma Computing

Slack

Last modified 1mo ago