[Diagnosis] Data Transformation for the onboarding data source is not working properly.

[Sachinbisht27]

Describe the bug We have encountered the error logs on the DBT production transformation. This issue caused us to stop the data pipeline in a production environment.

Diagnosis details: As we have some custom fields containing dashes (-). This case is causing an error in the DBT while transforming the data from the user_attribute table to the onboarding data source.

Environment (please complete the following information):

• Environment - Production

Screenshot:

We have 2 ways to fix the issue:

• We can rename these custom fields at Glific and start using underscores (_) instead of dashes (-).
• Or we can do a fix at the code level to handle or process such data.

Acceptance Criteria

• [x] The data transformation at the production level for the Onboarding data source should work fine.

Documentation Add whatever documentation will be required here.

[Sachinbisht27]

We will be going with the Approach 1: To rename the custom fields at the Glific level and start using underscores (_) instead of dashes (-).

[Sachinbisht27]

Closing as completed