Sign up schema changes

[pacholoamit]

Description

Make changes to the sign-up schema in here

Definition of Done

• Add a property "metadata" that is a dynamic object
• Add a property "type" that accepts a string
• Test out the new sign_up schema by sending a new event and checking snowflake/clickhouse if the new "metadata" and "type" properties are populated

[pacholoamit]

Check in snowflake

SELECT * FROM DATA_COLLECTION_DB.SNOWPLOW_INGEST.BASE_EVENTS
WHERE EVENT_NAME = 'sign_up' AND APP_ID='sampleSignup'

Ensure there's a tag in the html page

<script src='https://tags.cnna.io/?appId=sampleSignup&test=true'></script>

Sample Javascript code for Signups

            window.tracker("trackSelfDescribingEvent", {
              schema: "iglu:com.mediajel.events/sign_up/jsonschema/1-0-3",
              data: {
                uuid: transaction.survey_response.id.toString(),
                firstName: first_name,
                lastName: last_name,
                emailAddress: email,
                hashedEmailAddress: email,
                phoneNumber: mobile_number.toString(),
              },
            });

Check the UNSTRUCT column, this will contain the additional properties from the sign up event

[jlaridamediajel]

Seen the changes on snowflake

[pacholoamit]

Next steps:

• Get in touch with Devops and get this deployed in production

Check the following tables:

• BASE_EVENTS_3_MONTHS
• BASE_EVENTS_6_MONTHS
• BASE_EVENTS_1_YEAR