sources: - name: suno_prod database: "{{ target.database }}" schema: prod # The schema where these tables exist tables: - name: af_website_events description: | AppsFlyer website events data containing web-based user interactions and conversion tracking. This table stores events from web users including page views, conversions, and attribution data. Used for tracking user acquisition, conversion funnels, and marketing attribution across web platforms. tags: ["partition_type=none"] columns: - name: advertising_id description: "Mobile advertising identifier" - name: af_web_id description: "AppsFlyer web identifier" - name: amazon_aid description: "Amazon advertising identifier" - name: app_id description: "Application identifier" - name: app_name description: "Application name" - name: app_version description: "Application version" - name: appsflyer_id description: "AppsFlyer unique identifier" - name: attributed_touch_time description: "Time of attributed touch event" - name: attributed_touch_type description: "Type of attributed touch" - name: bundle_id description: "Application bundle identifier" - name: campaign description: "Marketing campaign name" - name: campaign_id description: "Marketing campaign identifier" - name: city description: "User city" - name: country_code description: "User country code" - name: customer_user_id description: "Customer user identifier" - name: device_category description: "Device category (mobile, tablet, desktop)" - name: dma description: "Designated Market Area" - name: dt description: "Date/time of event" - name: event_name description: "Name of the tracked event" - name: event_revenue description: "Revenue associated with the event" - name: event_revenue_currency description: "Currency of event revenue" - name: event_revenue_usd description: "Event revenue in USD" - name: event_source description: "Source of the event" - name: event_time description: "Time when event occurred" - name: event_type description: "Type of event" - name: event_url description: "URL where event occurred" - name: h description: "Hash identifier" - name: idfv description: "Identifier for Vendor" - name: install_time description: "Time of app installation" - name: ip description: "User IP address" - name: language description: "User language" - name: media_channel description: "Media channel" - name: media_source description: "Media source" - name: media_type description: "Type of media" - name: original_url description: "Original URL" - name: os_version description: "Operating system version" - name: platform description: "Platform (iOS, Android, Web)" - name: postal_code description: "User postal code" - name: query_params description: "URL query parameters" - name: query_params_deprecated description: "Deprecated query parameters" - name: referrer description: "Referrer URL" - name: region description: "User region" - name: state description: "User state" - name: user_agent description: "Browser user agent" - name: _ingestion_time description: "Time when data was ingested" - name: af_inapps description: | AppsFlyer in-app events data containing mobile app user interactions and conversion tracking. This table stores events from mobile app users including app opens, purchases, and other in-app activities. Used for tracking user engagement, conversion funnels, and marketing attribution within mobile applications. tags: ["partition_type=none"] columns: - name: advertising_id description: "Mobile advertising identifier" - name: af_ad description: "AppsFlyer ad identifier" - name: af_ad_id description: "AppsFlyer ad ID" - name: af_ad_type description: "Type of AppsFlyer ad" - name: af_adset description: "AppsFlyer ad set" - name: af_adset_id description: "AppsFlyer ad set ID" - name: af_attribution_lookback description: "AppsFlyer attribution lookback period" - name: af_c_id description: "AppsFlyer campaign ID" - name: af_channel description: "AppsFlyer channel" - name: af_cost_value description: "AppsFlyer cost value" - name: af_keywords description: "AppsFlyer keywords" - name: af_siteid description: "AppsFlyer site ID" - name: af_sub1 description: "AppsFlyer sub parameter 1" - name: af_sub2 description: "AppsFlyer sub parameter 2" - name: af_sub5 description: "AppsFlyer sub parameter 5" - name: amazon_aid description: "Amazon advertising identifier" - name: app_id description: "Application identifier" - name: app_name description: "Application name" - name: app_type description: "Application type" - name: app_version description: "Application version" - name: appsflyer_id description: "AppsFlyer unique identifier" - name: att description: "App Tracking Transparency status" - name: attributed_touch_time description: "Time of attributed touch event" - name: attributed_touch_type description: "Type of attributed touch" - name: bundle_id description: "Application bundle identifier" - name: campaign description: "Marketing campaign name" - name: campaign_type description: "Type of marketing campaign" - name: carrier description: "Mobile carrier" - name: city description: "User city" - name: conversion_type description: "Type of conversion" - name: country_code description: "User country code" - name: custom_data description: "Custom event data" - name: customer_user_id description: "Customer user identifier" - name: deeplink_url description: "Deep link URL" - name: device_category description: "Device category" - name: device_download_time description: "Device download time" - name: device_model description: "Device model" - name: dma description: "Designated Market Area" - name: dt description: "Date/time of event" - name: engagement_type description: "Type of user engagement" - name: event_name description: "Name of the tracked event" - name: event_revenue description: "Revenue associated with the event" - name: event_revenue_currency description: "Currency of event revenue" - name: event_revenue_usd description: "Event revenue in USD" - name: event_source description: "Source of the event" - name: event_time description: "Time when event occurred" - name: event_value description: "Value of the event" - name: gp_broadcast_referrer description: "Google Play broadcast referrer" - name: h description: "Hash identifier" - name: http_referrer description: "HTTP referrer" - name: idfa description: "Identifier for Advertisers" - name: idfv description: "Identifier for Vendor" - name: install_time description: "Time of app installation" - name: ip description: "User IP address" - name: is_lat description: "Limited Ad Tracking status" - name: is_organic description: "Whether the install was organic" - name: is_primary_attribution description: "Whether this is primary attribution" - name: is_retargeting description: "Whether this is retargeting" - name: keyword_id description: "Keyword identifier" - name: language description: "User language" - name: match_type description: "Attribution match type" - name: media_source description: "Media source" - name: network_account_id description: "Network account identifier" - name: operator description: "Mobile operator" - name: original_url description: "Original URL" - name: os_version description: "Operating system version" - name: platform description: "Platform (iOS, Android)" - name: postal_code description: "User postal code" - name: region description: "User region" - name: sdk_version description: "AppsFlyer SDK version" - name: state description: "User state" - name: user_agent description: "User agent string" - name: wifi description: "WiFi connection status" - name: _ingestion_time description: "Time when data was ingested" - name: af_skad_inapps description: | AppsFlyer SKAdNetwork in-app events data containing privacy-compliant attribution data for iOS. This table stores events from iOS users using Apple's SKAdNetwork framework for privacy-compliant attribution. Used for tracking conversions and user acquisition while respecting iOS privacy requirements. tags: ["partition_type=none"] columns: - name: advertising_id description: "Mobile advertising identifier" - name: af_ad description: "AppsFlyer ad identifier" - name: af_ad_id description: "AppsFlyer ad ID" - name: af_ad_type description: "Type of AppsFlyer ad" - name: af_adset description: "AppsFlyer ad set" - name: af_adset_id description: "AppsFlyer ad set ID" - name: af_attribution_lookback description: "AppsFlyer attribution lookback period" - name: af_c_id description: "AppsFlyer campaign ID" - name: af_channel description: "AppsFlyer channel" - name: af_cost_value description: "AppsFlyer cost value" - name: af_keywords description: "AppsFlyer keywords" - name: af_siteid description: "AppsFlyer site ID" - name: af_sub1 description: "AppsFlyer sub parameter 1" - name: af_sub2 description: "AppsFlyer sub parameter 2" - name: af_sub5 description: "AppsFlyer sub parameter 5" - name: amazon_aid description: "Amazon advertising identifier" - name: app_id description: "Application identifier" - name: app_name description: "Application name" - name: app_type description: "Application type" - name: app_version description: "Application version" - name: appsflyer_id description: "AppsFlyer unique identifier" - name: att description: "App Tracking Transparency status" - name: attributed_touch_time description: "Time of attributed touch event" - name: attributed_touch_type description: "Type of attributed touch" - name: bundle_id description: "Application bundle identifier" - name: campaign description: "Marketing campaign name" - name: campaign_type description: "Type of marketing campaign" - name: carrier description: "Mobile carrier" - name: city description: "User city" - name: conversion_type description: "Type of conversion" - name: country_code description: "User country code" - name: custom_data description: "Custom event data" - name: customer_user_id description: "Customer user identifier" - name: deeplink_url description: "Deep link URL" - name: device_category description: "Device category" - name: device_download_time description: "Device download time" - name: device_model description: "Device model" - name: dma description: "Designated Market Area" - name: dt description: "Date/time of event" - name: engagement_type description: "Type of user engagement" - name: event_name description: "Name of the tracked event" - name: event_revenue description: "Revenue associated with the event" - name: event_revenue_currency description: "Currency of event revenue" - name: event_revenue_usd description: "Event revenue in USD" - name: event_source description: "Source of the event" - name: event_time description: "Time when event occurred" - name: event_value description: "Value of the event" - name: gp_broadcast_referrer description: "Google Play broadcast referrer" - name: h description: "Hash identifier" - name: http_referrer description: "HTTP referrer" - name: idfa description: "Identifier for Advertisers" - name: idfv description: "Identifier for Vendor" - name: install_time description: "Time of app installation" - name: ip description: "User IP address" - name: is_lat description: "Limited Ad Tracking status" - name: is_organic description: "Whether the install was organic" - name: is_primary_attribution description: "Whether this is primary attribution" - name: is_retargeting description: "Whether this is retargeting" - name: keyword_id description: "Keyword identifier" - name: language description: "User language" - name: match_type description: "Attribution match type" - name: media_source description: "Media source" - name: network_account_id description: "Network account identifier" - name: operator description: "Mobile operator" - name: original_url description: "Original URL" - name: os_version description: "Operating system version" - name: platform description: "Platform (iOS, Android)" - name: postal_code description: "User postal code" - name: region description: "User region" - name: sdk_version description: "AppsFlyer SDK version" - name: state description: "User state" - name: user_agent description: "User agent string" - name: wifi description: "WiFi connection status" - name: _ingestion_time description: "Time when data was ingested"