I have created a new schema for a custom link-click context. I added the schema in Google Tag Manager, and the event is triggered with the custom context and the new schema. However, it has not created a table in my database.
Here’s the schema I created:
{
"$schema": "http://iglucentral.com/schemas/com.snowplowanalytics.self-desc/schema/jsonschema/1-0-0#",
"description": "Schema for tracking the XPath of a link click event",
"self": {
"vendor": "com.company-name",
"name": "link_click_extension",
"format": "jsonschema",
"version": "1-0-0"
},
"type": "object",
"properties": {
"xpath": {
"type": "string"
}
},
"required": ["xpath"],
"additionalProperties": false
}
And here’s the event that was fired:
{
"schema": "iglu:com.snowplowanalytics.snowplow/contexts/jsonschema/1-0-0",
"data": [
{
"schema": "iglu:com.company-name/link_click_extension/jsonschema/1-0-0",
"data": {
"xpath": "HTML[2]/BODY[3]/DIV[5]/NAV[2]/DIV[4]/DIV[2]/DIV[5]/A[2]"
}
},
{
"schema": "iglu:com.snowplowanalytics.snowplow/web_page/jsonschema/1-0-0",
"data": {
"id": "xxxx-8767-87792b1e97da"
}
}
]
}
I added the schema to the resolver.json file in both the enrichers and loaders with the following configuration:
{
"name": "Company Static Repo (HTTP)",
"priority": 1,
"vendorPrefixes": ["com.company_name"],
"connection": {
"http": {
"uri": "https://storage.goog`Preformatted text`leapis.com/company-sp-js/iglu"
}
}
}
Despite this setup, no table was created in my database.
This is the error I received from the loader in PostgreSQL and Redshift
{
"schema": "iglu:com.snowplowanalytics.snowplow.badrows/loader_iglu_error/jsonschema/2-0-0",
"data": {
"processor": {
"artifact": "snowplow-postgres-loader",
"version": "0.3.3"
},
"failure": [
{
"schemaCriterion": "iglu:com.Company/link_click_extension/jsonschema/1-*-*",
"error": {
"error": "ResolutionError",
"lookupHistory": [
{
"repository": "Company Static Repo (HTTP)",
"errors": [
{
"error": "NotFound"
}
],
"attempts": 1,
"lastAttempt": "2023-09-28T11:43:18.005Z"
},
{
"repository": "Iglu Central",
"errors": [
{
"error": "NotFound"
}
],
"attempts": 1,
"lastAttempt": "2023-09-28T11:43:18.114Z"
},
{
"repository": "Iglu Client Embedded",
"errors": [
{
"error": "NotFound"
}
],
"attempts": 1,
"lastAttempt": "2023-09-28T11:43:18.005Z"
}
]
}
}
],
"payload": {
"app_id": "dataware-web",
"platform": "web",
"etl_tstamp": "2023-09-28T11:43:17.187Z",
"collector_tstamp": "2023-09-28T11:43:12.154Z",
"dvce_created_tstamp": "2023-09-28T11:43:05.316Z",
"event": "unstruct",
"event_id": "72d19813-d1f2-4017-afb5-f86678feb2ce",
"txn_id": null,
"name_tracker": "spTracker",
"v_tracker": "js-3.9.0",
"v_collector": "ssc-2.9.0-googlepubsub",
"v_etl": "snowplow-enrich-pubsub-3.8.0",
"user_id": null,
"user_ipaddress": "106.197.87.176",
"user_fingerprint": null,
"domain_userid": "14911ea3-8d6a-4487-8722-b2eacaf7927c",
"domain_sessionidx": 61,
"network_userid": "3502a708-b228-4a4b-86a0-b8587f23677f",
"geo_country": "IN",
"geo_region": "TN",
"geo_city": "Chennai",
"geo_zipcode": "600004",
"geo_latitude": 12.8996,
"geo_longitude": 80.2209,
"geo_region_name": "Tamil Nadu",
"ip_isp": null,
"ip_organization": null,
"ip_domain": null,
"ip_netspeed": null,
"page_url": "https://website-dataware.web.app/?gtm_debug=1695901353634",
"page_title": null,
"page_referrer": "https://tagassistant.google.com/",
"page_urlscheme": "https",
"page_urlhost": "website-dataware.web.app",
"page_urlport": 443,
"page_urlpath": "/",
"page_urlquery": "gtm_debug=1695901353634",
"page_urlfragment": null,
"refr_urlscheme": "https",
"refr_urlhost": "tagassistant.google.com",
"refr_urlport": 443,
"refr_urlpath": "/",
"refr_urlquery": null,
"refr_urlfragment": null,
"refr_medium": "search",
"refr_source": "Google",
"refr_term": null,
"mkt_medium": null,
"mkt_source": null,
"mkt_term": null,
"mkt_content": null,
"mkt_campaign": null,
"contexts": {
"schema": "iglu:com.snowplowanalytics.snowplow/contexts/jsonschema/1-0-0",
"data": [
{
"schema": "iglu:com.Company/link_click_extension/jsonschema/1-0-0",
"data": {
"xpath": "HTML[2]/BODY[3]/DIV[5]/NAV[2]/DIV[4]/DIV[2]/DIV[5]/A[2]"
}
},
{
"schema": "iglu:com.snowplowanalytics.snowplow/web_page/jsonschema/1-0-0",
"data": {
"id": "3a3211ef-906c-4646-9b6d-671246652603"
}
}
]
},
"se_category": null,
"se_action": null,
"se_label": null,
"se_property": null,
"se_value": null,
"unstruct_event": {
"schema": "iglu:com.snowplowanalytics.snowplow/unstruct_event/jsonschema/1-0-0",
"data": {
"schema": "iglu:com.snowplowanalytics.snowplow/link_click/jsonschema/1-0-1",
"data": {
"targetUrl": "https://website-dataware.web.app/contact.html",
"elementId": "",
"elementClasses": [
"nav-item",
"nav-link"
],
"elementTarget": ""
}
}
},
"tr_orderid": null,
"tr_affiliation": null,
"tr_total": null,
"tr_tax": null,
"tr_shipping": null,
"tr_city": null,
"tr_state": null,
"tr_country": null,
"ti_orderid": null,
"ti_sku": null,
"ti_name": null,
"ti_category": null,
"ti_price": null,
"ti_quantity": null,
"pp_xoffset_min": null,
"pp_xoffset_max": null,
"pp_yoffset_min": null,
"pp_yoffset_max": null,
"useragent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36",
"br_name": null,
"br_family": null,
"br_version": null,
"br_type": null,
"br_renderengine": null,
"br_lang": "en-US",
"br_features_pdf": null,
"br_features_flash": null,
"br_features_java": null,
"br_features_director": null,
"br_features_quicktime": null,
"br_features_realplayer": null,
"br_features_windowsmedia": null,
"br_features_gears": null,
"br_features_silverlight": null,
"br_cookies": true,
"br_colordepth": "24",
"br_viewwidth": 1179,
"br_viewheight": 876,
"os_name": null,
"os_family": null,
"os_manufacturer": null,
"os_timezone": "Asia/Calcutta",
"dvce_type": null,
"dvce_ismobile": null,
"dvce_screenwidth": 1920,
"dvce_screenheight": 1080,
"doc_charset": "UTF-8",
"doc_width": 1164,
"doc_height": 8355,
"tr_currency": null,
"tr_total_base": null,
"tr_tax_base": null,
"tr_shipping_base": null,
"ti_currency": null,
"ti_price_base": null,
"base_currency": null,
"geo_timezone": "Asia/Kolkata",
"mkt_clickid": null,
"mkt_network": null,
"etl_tags": null,
"dvce_sent_tstamp": "2023-09-28T11:43:11.526Z",
"refr_domain_userid": null,
"refr_dvce_tstamp": null,
"derived_contexts": {
"schema": "iglu:com.snowplowanalytics.snowplow/contexts/jsonschema/1-0-0",
"data": [
{
"schema": "iglu:nl.basjes/yauaa_context/jsonschema/1-0-4",
"data": {
"deviceBrand": "Unknown",
"deviceName": "Linux Desktop",
"operatingSystemVersionMajor": "??",
"layoutEngineNameVersion": "Blink 116",
"operatingSystemNameVersion": "Linux ??",
"agentInformationEmail": "Unknown",
"networkType": "Unknown",
"operatingSystemVersionBuild": "??",
"webviewAppNameVersionMajor": "Unknown ??",
"layoutEngineNameVersionMajor": "Blink 116",
"operatingSystemName": "Linux",
"agentVersionMajor": "116",
"layoutEngineVersionMajor": "116",
"webviewAppName": "Unknown",
"deviceClass": "Desktop",
"agentNameVersionMajor": "Chrome 116",
"operatingSystemNameVersionMajor": "Linux ??",
"deviceCpuBits": "64",
"webviewAppVersionMajor": "??",
"operatingSystemClass": "Desktop",
"webviewAppVersion": "??",
"layoutEngineName": "Blink",
"agentName": "Chrome",
"agentVersion": "116",
"layoutEngineClass": "Browser",
"agentNameVersion": "Chrome 116",
"operatingSystemVersion": "??",
"deviceCpu": "Intel x86_64",
"agentClass": "Browser",
"layoutEngineVersion": "116",
"agentInformationUrl": "Unknown"
}
}
]
},
"domain_sessionid": "9ebf24c9-318d-4f6e-9b26-59f1caffc6dd",
"derived_tstamp": "2023-09-28T11:43:05.944Z",
"event_vendor": "com.snowplowanalytics.snowplow",
"event_name": "link_click",
"event_format": "jsonschema",
"event_version": "1-0-1",
"event_fingerprint": null,
"true_tstamp": null
}
}
}