Skip to main content

Data Integrations Internal Release Notes - Qualtrics V3 Views Naming Convention Changes

Ajaykumar Guttlapalli
  • Updated

What is DWA ‘Qualtrics_v3_surveys: Views' naming convention changes’?

  • The current Qualtrics Views provided to clients are generated at the survey level that are built out of qualtrics_v3_surveys. Most of our clients are using these views for querying and getting insights of the survey responses.

Why did Two Circles want to update the Views?

  • Some column names in these Views are excessively long, which causes readability issues and prevents clients from querying these columns effectively.

What Clients are affected by this change?

  • All Two Circles DWA clients currently using Qualtrics DWA integration tables and views are impacted by this update.

What’s new or changing?

  • Currently the Qualtrics_v3_Surveys.Views column names are populated using questiontext field, we will be updating the applicable column names with questionname field, so that it will be easy for clients to write SQL Queries from the views.

Example

Before the change

If a view named Post Game Survey currently has the following columns:

  • responseid (varchar(50))

  • how do you feel about the half time event that is provided by our local university students (float8)

  • how likely are you to buy tickets to an upcoming game because of the $3 value food menu? (float8)

  • game (varchar(4000))

  • email (varchar(4000))

  • enddate (varchar(4000))

After the change

The columns will be updated to the following standardized names:

  • responseid (varchar(50))

  • rate_half_time_event (float8)

  • rate_value_menu (float8)

  • game (varchar(4000))

  • email (varchar(4000))

  • enddate (varchar(4000))
     

Below are illustrated images of current state and future state.

Current State:

53d50b87-acb7-427a-92dd-4296e0dac694.png


Future state:

ChatGPT Image Jan 22, 2026, 12_06_50 PM.png

What is not affected or included?

  • Frequency of ingestion remains unchanged.

  • No new tables are being added.

  • No changes to the Tables

How does a client enable this feature?

The updated Qualtrics views will be automatically deployed to all customers currently using Qualtrics integrations.
Clients will be notified of their individual implementation window.

 

Internal Release Notes: 

https://koresoftware.atlassian.net/wiki/spaces/DWA/pages/4827414551/Data+Integrations+Internal+Release+Notes+-+Qualtrics