All Collections
Getting Started
Snowflake Integration
Snowflake? Yes, please! Connect Snowflake and Great Question.

Snowflake Integration

Updated on
September 15, 2022

If you use Snowflake for your data storage and want that data pulled into your Great Question account, follow along with the steps below to get the ball rolling!

An integration with Snowflake makes managing your candidates easier and more streamlined. As well as ensuring a continuous flow of candidates into Great Question, updated candidate data, and more.

Need assistance setting up your Snowflake integration? Please reach out to [email protected]

Source guide from Snowflake

Create a Snowflake OAuth Integration

To create a Snowflake OAuth integration use the CREATE SECURITY INTEGRATION (Snowflake OAuth) command.

create or replace security integration <integration_name>
  type = oauth
  enabled = true
  oauth_client = custom
  oauth_client_type = 'PUBLIC'
  oauth_redirect_uri = 'https://greatquestion.co/users/auth/snowflake/callback'
  oauth_allow_non_tls_redirect_uri = true
  oauth_issue_refresh_tokens = true
  oauth_refresh_token_validity = 86400;

Note: Only account administrators (users with the ACCOUNTADMIN role) or a role with the global CREATE INTEGRATION privilege can execute this SQL command.

Next, run these two commands to extract the information necessary to connect Snowflake with Great Question:

  • Run this to get the URL, which will look something like: 'https://<account>.<region>.snowflakecomputing.com'
desc integration <integration_name>;
  • Run this to get the OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET
select system$show_oauth_client_secrets(<integration_name>);

Connecting with Great Question and importing candidates

After you have all the information from the steps above, you can go to User Menu > Account > Integrations within Great Question (or click here) and add the information to connect with Snowflake using your credentials.

Once you are connected, you will see the screen below:

Let's break this screen down:

Warehouse, Database and Table (required)

  • This is where your data lives inside Snowflake. Add the values to tell us where to get the data from.

Only import contacts with `gq_import` tag

  • In case you want to restrict access from specific records in the table you chose, you can add a boolean column called `gq_import` and the records with `false` won't be imported into Great Question.

When a candidate is deleted from Snowflake

  • If a previously imported record is removed from Snowflake, the candidate will not be deleted automatically from our Great Question database. This is a limitation of how our integration currently works. However, if you want to automatically delete records from Great Question, you can add a boolean column `is_deleted` to Snowflake and select what type of behavior you want when the record is imported to Great Question.

After clicking Save, you are good to go!

The candidates will be synced every 24 hours at midnight PST, and you can trigger a sync manually at the candidate's page.

Custom Attributes

All columns from Snowflake will be available in Great Question. If you want to be able to use any specific column, you need to create a candidate attribute for it. In order to do that, you go to Account > Candidate attributes > New attribute (or click here).

Note: The name of the attribute must match the column name from Snowflake.

Ready to dive in?

See the only all-in-one customer research platform