search

mozilla / lookml-generator

LookML Generator for Glean and Mozilla Data
https://mozilla.github.io/lookml-generator/generator.html
Mozilla Public License 2.0
17 stars 17 forks source link

feat: add app_store_choice_screen_engagement to the firefox_ios namespace #1111

Closed kik-kik closed 5 days ago

kik-kik commented 5 days ago

feat: add app_store_choice_screen_engagement to the firefox_ios namespace

dataops-ci-bot commented 5 days ago

Integration report for "feat: add app_store_choice_screen_engagement to the firefox_ios namespace"

lookml.diff

Click to expand! ```diff Only in /tmp/workspace/looker-hub/firefox_ios: dashboards Only in /tmp/workspace/generated-lookml/firefox_ios/views: app_store_choice_screen_engagement.view.lkml Only in /tmp/workspace/looker-hub/: user_journey diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/firefox_desktop/views/clients_first_seen_v2.view.lkml /tmp/workspace/generated-lookml/firefox_desktop/views/clients_first_seen_v2.view.lkml --- /tmp/workspace/looker-hub/firefox_desktop/views/clients_first_seen_v2.view.lkml 2024-11-27 10:12:58.828681021 +0000 +++ /tmp/workspace/generated-lookml/firefox_desktop/views/clients_first_seen_v2.view.lkml 2024-11-27 10:07:48.000000000 +0000 @@ -8,122 +8,146 @@ dimension: app_build_id { sql: ${TABLE}.app_build_id ;; type: string + description: "The application build reported by the client." } dimension: app_name { sql: ${TABLE}.app_name ;; type: string + description: "The name of the installed app/browser." } dimension: app_version { sql: ${TABLE}.app_version ;; type: string + description: "The application version." } dimension: apple_model_id { sql: ${TABLE}.apple_model_id ;; type: string + description: "The model IDs for Apple desktop devices. Applies to Mac only." } dimension: architecture { sql: ${TABLE}.architecture ;; type: string + description: "The application architecture reported by the client." } dimension: attribution_campaign { sql: ${TABLE}.attribution_campaign ;; type: string + description: "Identifier of the particular campaign that led to the download of the product." } dimension: attribution_content { sql: ${TABLE}.attribution_content ;; type: string + description: "Identifier to indicate the particular link within a campaign." } dimension: attribution_dlsource { sql: ${TABLE}.attribution_dlsource ;; type: string + description: "Identifier that indicates where installations of Firefox originated." } dimension: attribution_dltoken { sql: ${TABLE}.attribution_dltoken ;; type: string + description: "Unique token created at Firefox download time." } dimension: attribution_experiment { sql: ${TABLE}.attribution_experiment ;; type: string + description: "Funnel experiment parameters." } dimension: attribution_medium { sql: ${TABLE}.attribution_medium ;; type: string + description: "Category of the source, such as 'organic' for a search engine." } dimension: attribution_source { sql: ${TABLE}.attribution_source ;; type: string + description: "Referring partner domain, when install happens via a known partner." } dimension: attribution_ua { sql: ${TABLE}.attribution_ua ;; type: string + description: "Client's user agent, which corresponds to the web browser used to download the Firefox installer." } dimension: city { sql: ${TABLE}.city ;; type: string + description: "City retrieved as a result of a geographic lookup based on the client's IP address." } dimension: client_id { sql: ${TABLE}.client_id ;; hidden: yes + description: "Unique ID for the client installation." } dimension: country { sql: ${TABLE}.country ;; type: string map_layer_name: countries + description: "The ISO 3166-1 alpha-2 country code." } dimension: db_version { sql: ${TABLE}.db_version ;; type: string + description: "The specific geo database version used." } dimension: distribution_id { sql: ${TABLE}.distribution_id ;; type: string + description: "The value of the `distribution.id` preference that identifies the Firefox distribution." } dimension: document_id { sql: ${TABLE}.document_id ;; hidden: yes + description: "The document ID specified in the URI when the client sent this message." } dimension: engine_data_load_path { sql: ${TABLE}.engine_data_load_path ;; type: string + description: "The anonymized path of the engine xml file. For details on the components refer to the metadata for telemetry.new_profile." } dimension: engine_data_name { sql: ${TABLE}.engine_data_name ;; type: string + description: "The name of the default search engine." } dimension: engine_data_origin { sql: ${TABLE}.engine_data_origin ;; type: string + description: "The origin of the search engine. The value will be default for engines that are built-in or from distribution partners, verified for user-installed engines with valid verification hashes, unverified for non-default engines without verification hash, and invalid for engines with broken verification hashes." } dimension: engine_data_submission_url { sql: ${TABLE}.engine_data_submission_url ;; type: string + description: "The HTTP url we would use to search. For privacy, we don’t record this for user-installed engines." } dimension: locale { sql: ${TABLE}.locale ;; type: string + description: "The best locale that the application should be localized to." } dimension: metadata__first_seen_date_source_ping { @@ -131,6 +155,7 @@ type: string group_label: "Metadata" group_item_label: "First Seen Date Source Ping" + description: "Ping that reported the first seen date (main, first_shutdown or new_profile)." } dimension: metadata__reported_main_ping { @@ -138,6 +163,7 @@ type: yesno group_label: "Metadata" group_item_label: "Reported Main Ping" + description: "Indicates wether the client ever reported a main ping." } dimension: metadata__reported_new_profile_ping { @@ -145,6 +171,7 @@ type: yesno group_label: "Metadata" group_item_label: "Reported New Profile Ping" + description: "Indicates wether the client ever reported a new profile ping." } dimension: metadata__reported_shutdown_ping { @@ -152,76 +179,91 @@ type: yesno group_label: "Metadata" group_item_label: "Reported Shutdown Ping" + description: "Indicates wether the client ever reported a first shutdown ping." } dimension: normalized_channel { sql: ${TABLE}.normalized_channel ;; type: string + description: "The Firefox channel, set to Other for unrecognized channel names." } dimension: normalized_os { sql: ${TABLE}.normalized_os ;; type: string + description: "The OS name, set to Other for unrecognized OS names." } dimension: normalized_os_version { sql: ${TABLE}.normalized_os_version ;; type: string + description: "The OS version." } dimension: partner_distribution_version { sql: ${TABLE}.partner_distribution_version ;; type: string + description: "The value selected for the `distribution.version` preference in the Partner Distribution Configuration File." } dimension: partner_distributor { sql: ${TABLE}.partner_distributor ;; type: string + description: "The value of the `app.distributor` preference in the Partner Distribution Configuration File." } dimension: partner_distributor_channel { sql: ${TABLE}.partner_distributor_channel ;; type: string + description: "The value of the `app.distributor.channel` preference in the Partner Distribution Configuration File." } dimension: partner_id { sql: ${TABLE}.partner_id ;; type: string + description: "The value of the `mozilla.partner.id` preference in the Partner Distribution Configuration File." } dimension: platform_version { sql: ${TABLE}.platform_version ;; type: string + description: "The appliction platform version reported by the client." } dimension: profile_group_id { sql: ${TABLE}.profile_group_id ;; type: string + description: "A UUID identifying the profile's group on a single device and allowing user-oriented correlation of data" } dimension: sample_id { sql: ${TABLE}.sample_id ;; type: number + description: "Sample ID to limit query results during an analysis." } dimension: startup_profile_selection_reason { sql: ${TABLE}.startup_profile_selection_reason ;; type: string + description: "How the profile was selected during startup. Possible reasons are: unknown: Generally should not happen, set as a default in case no other reason occurred. profile-manager: The profile was selected by the profile manager. profile-reset: The profile was selected for reset, normally this would mean a restart. restart: The user restarted the application, the same profile as previous will be used. argument-profile: The profile was selected by the --profile command line argument. argument-p: The profile was selected by the -p command line argument. firstrun-claimed-default: A first run of a dedicated profiles build chose the old default profile to be the default for this install. firstrun-skipped-default: A first run of a dedicated profiles build skipped over the old default profile and created a new profile. restart-claimed-default: A first run of a dedicated profiles build after a restart chose the old default." } dimension: subdivision1 { sql: ${TABLE}.subdivision1 ;; type: string + description: "First major country subdivision, typically a state, province, or county." } dimension: vendor { sql: ${TABLE}.vendor ;; type: string + description: "The application vendor." } dimension: xpcom_abi { sql: ${TABLE}.xpcom_abi ;; type: string + description: "A string tag identifying the binary ABI of the current processor and compiler vtable, as taken from the TARGET_XPCOM_ABI configure variable. It may not be available on all platforms, especially unusual processor or compiler combinations. The result takes the form -, eg. x86-msvc, ppc-gcc3. This value should almost always be used in combination with the OS." } dimension_group: first_seen { @@ -237,6 +279,7 @@ ] convert_tz: no datatype: date + description: "Date when the server first received either of the 3 pings from this client." } dimension_group: second_seen { @@ -252,6 +295,7 @@ ] convert_tz: no datatype: date + description: "Second date when the server received either of the 3 pings from this client." } sql_table_name: `moz-fx-data-shared-prod.telemetry_derived.clients_first_seen_v2` ;; diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/firefox_ios/views/app_store_choice_screen_engagement.view.lkml /tmp/workspace/generated-lookml/firefox_ios/views/app_store_choice_screen_engagement.view.lkml --- /tmp/workspace/looker-hub/firefox_ios/views/app_store_choice_screen_engagement.view.lkml 1970-01-01 00:00:00.000000000 +0000 +++ /tmp/workspace/generated-lookml/firefox_ios/views/app_store_choice_screen_engagement.view.lkml 2024-11-27 10:07:51.000000000 +0000 @@ -0,0 +1,64 @@ + +# *Do not manually modify this file* +# +# This file has been generated via https://github.com/mozilla/lookml-generator +# You can extend this view in the looker-spoke-default project (https://github.com/mozilla/looker-spoke-default) + +view: app_store_choice_screen_engagement { + dimension: app_apple_identifier { + sql: ${TABLE}.app_apple_identifier ;; + type: number + } + + dimension: app_name { + sql: ${TABLE}.app_name ;; + type: string + } + + dimension: counts { + sql: ${TABLE}.counts ;; + type: number + } + + dimension: device { + sql: ${TABLE}.device ;; + type: string + } + + dimension: event { + sql: ${TABLE}.event ;; + type: string + } + + dimension: platform_version { + sql: ${TABLE}.platform_version ;; + type: string + } + + dimension: territory { + sql: ${TABLE}.territory ;; + type: string + } + + dimension: unique_devices { + sql: ${TABLE}.unique_devices ;; + type: number + } + + dimension_group: date { + sql: ${TABLE}.date ;; + type: time + timeframes: [ + raw, + date, + week, + month, + quarter, + year, + ] + convert_tz: no + datatype: date + } + + sql_table_name: `moz-fx-data-shared-prod.firefox_ios.app_store_choice_screen_engagement` ;; +} \ No newline at end of file diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/monitoring/datagroups/bigquery_table_storage_v1_last_updated.datagroup.lkml /tmp/workspace/generated-lookml/monitoring/datagroups/bigquery_table_storage_v1_last_updated.datagroup.lkml --- /tmp/workspace/looker-hub/monitoring/datagroups/bigquery_table_storage_v1_last_updated.datagroup.lkml 2024-11-27 10:12:58.972681897 +0000 +++ /tmp/workspace/generated-lookml/monitoring/datagroups/bigquery_table_storage_v1_last_updated.datagroup.lkml 2024-11-27 10:10:35.000000000 +0000 @@ -6,7 +6,7 @@ # Using a datagroup in a derived table: https://cloud.google.com/looker/docs/reference/param-view-datagroup-trigger datagroup: bigquery_table_storage_v1_last_updated { - label: "bigquery_table_storage_v1 Last Updated" + label: "BigQuery Tables Storage Last Updated" sql_trigger: SELECT MAX(storage_last_modified_time) FROM `moz-fx-data-shared-prod`.`region-us`.INFORMATION_SCHEMA.TABLE_STORAGE WHERE table_schema = 'monitoring_derived' diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/namespaces.yaml /tmp/workspace/generated-lookml/namespaces.yaml --- /tmp/workspace/looker-hub/namespaces.yaml 2024-11-27 10:12:59.364684280 +0000 +++ /tmp/workspace/generated-lookml/namespaces.yaml 2024-11-27 10:12:59.264683672 +0000 @@ -3825,6 +3825,10 @@ - channel: nightly table: mozdata.org_mozilla_ios_fennec.addresses_sync type: table_view + app_store_choice_screen_engagement: + tables: + - table: moz-fx-data-shared-prod.firefox_ios.app_store_choice_screen_engagement + type: table_view app_store_choice_screen_engagement_table: tables: - channel: release diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/subscription_platform/views/stripe_subscriptions.view.lkml /tmp/workspace/generated-lookml/subscription_platform/views/stripe_subscriptions.view.lkml --- /tmp/workspace/looker-hub/subscription_platform/views/stripe_subscriptions.view.lkml 2024-11-27 10:12:59.032682261 +0000 +++ /tmp/workspace/generated-lookml/subscription_platform/views/stripe_subscriptions.view.lkml 2024-11-27 10:09:20.000000000 +0000 @@ -8,11 +8,13 @@ dimension: cancel_at_period_end { sql: ${TABLE}.cancel_at_period_end ;; type: yesno + description: "If the subscription has been canceled with the `at_period_end` flag set to true, `cancel_at_period_end` on the subscription will be true. You can use this attribute to determine whether a subscription that has a status of \"active\" is scheduled to be canceled at the end of the current period." } dimension: collection_method { sql: ${TABLE}.collection_method ;; type: string + description: "Either \"charge_automatically\", or \"send_invoice\". When charging automatically, Stripe will attempt to pay this subscription at the end of the cycle using the default source attached to the customer. When sending an invoice, Stripe will email your customer an invoice with payment instructions and mark the subscription as active." } dimension: customer__address__country { @@ -20,6 +22,7 @@ type: string group_label: "Customer Address" group_item_label: "Country" + description: "Two-letter country code (ISO 3166-1 alpha-2)." } dimension: customer__default_source_id { @@ -27,6 +30,8 @@ type: string group_label: "Customer" group_item_label: "Default Source Id" + description: "ID of the default payment source for the customer. +This isn't available for customers that were deleted before the initial Fivetran Stripe sync." } dimension: customer__discount__coupon__amount_off { @@ -34,6 +39,7 @@ type: number group_label: "Customer Discount Coupon" group_item_label: "Amount Off" + description: "Amount (in the `currency` specified) that will be taken off the subtotal of any invoices for this customer." } dimension: customer__discount__coupon__currency { @@ -41,6 +47,7 @@ type: string group_label: "Customer Discount Coupon" group_item_label: "Currency" + description: "If `amount_off` has been set, the three-letter ISO code for the currency of the amount to take off." } dimension: customer__discount__coupon__duration { @@ -48,6 +55,10 @@ type: string group_label: "Customer Discount Coupon" group_item_label: "Duration" + description: "One of \"forever\", \"once\", and \"repeating\". Describes how long a customer who applies this coupon will get the discount. +\"forever\" applies to all charges from a subscription with this coupon applied. +\"once\" applies to the first charge from a subscription with this coupon applied. +\"repeating\" applies to charges in the first `duration_in_months` months from a subscription with this coupon applied." } dimension: customer__discount__coupon__duration_in_months { @@ -55,6 +66,7 @@ type: number group_label: "Customer Discount Coupon" group_item_label: "Duration In Months" + description: "If `duration` is \"repeating\", the number of months the coupon applies. Null if coupon `duration` is \"forever\" or \"once\"." } dimension: customer__discount__coupon__id { @@ -62,11 +74,13 @@ type: string group_label: "Customer Discount Coupon" group_item_label: "Id" + description: "Coupon ID." } dimension: customer__discount__coupon__metadata { sql: ${TABLE}.customer.discount.coupon.metadata ;; hidden: yes + description: "Set of key-value pairs attached to the coupon, stored as a JSON object." } dimension: customer__discount__coupon__name { @@ -74,6 +88,7 @@ type: string group_label: "Customer Discount Coupon" group_item_label: "Name" + description: "Name of the coupon displayed to customers on invoices or receipts." } dimension: customer__discount__coupon__percent_off { @@ -81,6 +96,7 @@ type: number group_label: "Customer Discount Coupon" group_item_label: "Percent Off" + description: "Percent that will be taken off the subtotal of any invoices for this customer for the duration of the coupon. For example, a coupon with `percent_off` of 50 will make a $100 invoice $50 instead." } dimension: customer__discount__id { @@ -88,6 +104,7 @@ type: string group_label: "Customer Discount" group_item_label: "Id" + description: "Discount ID." } dimension: customer__discount__invoice_id { @@ -95,6 +112,7 @@ type: string group_label: "Customer Discount" group_item_label: "Invoice Id" + description: "ID of the invoice that the discount's coupon was applied to, if it was applied directly to a particular invoice." } dimension: customer__discount__invoice_item_id { @@ -102,6 +120,7 @@ type: string group_label: "Customer Discount" group_item_label: "Invoice Item Id" + description: "ID of the invoice item (or invoice line item for invoice line items of `type` = \"subscription\") that the discount's coupon was applied to, if it was applied directly to a particular invoice item or invoice line item." } dimension: customer__discount__promotion_code_id { @@ -109,6 +128,7 @@ type: string group_label: "Customer Discount" group_item_label: "Promotion Code Id" + description: "ID of the promotion code applied to create this discount." } dimension: customer__discount__subscription_id { @@ -116,6 +136,7 @@ type: string group_label: "Customer Discount" group_item_label: "Subscription Id" + description: "ID of the subscription that this coupon is applied to, if it is applied to a particular subscription." } dimension: customer__id { @@ -123,6 +144,7 @@ type: string group_label: "Customer" group_item_label: "Id" + description: "Customer ID." } dimension: customer__is_deleted { @@ -130,6 +152,7 @@ type: yesno group_label: "Customer" group_item_label: "Is Deleted" + description: "Whether the customer is deleted." } dimension: customer__metadata__paypalAgreementId { @@ -137,6 +160,7 @@ type: string group_label: "Customer Metadata" group_item_label: "Paypalagreementid" + description: "The customer's PayPal agreement ID (if any)." } dimension: customer__metadata__userid { @@ -144,6 +168,8 @@ type: string group_label: "Customer Metadata" group_item_label: "Userid" + description: "The customer's Firefox Account user ID. +This isn't available for customers that were deleted before the initial Fivetran Stripe sync." } dimension: customer__metadata__userid_sha256 { @@ -151,6 +177,7 @@ type: string group_label: "Customer Metadata" group_item_label: "Userid Sha256" + description: "SHA256 hash of the customer's Firefox Account user ID." } dimension: customer__shipping__address__country { @@ -158,6 +185,7 @@ type: string group_label: "Customer Shipping Address" group_item_label: "Country" + description: "Two-letter country code (ISO 3166-1 alpha-2)." } dimension: customer__tax_exempt { @@ -165,26 +193,32 @@ type: string group_label: "Customer" group_item_label: "Tax Exempt" + description: "The customer's tax exemption status. One of \"none\", \"exempt\", or \"reverse\". +This isn't available for customers that were deleted before the initial Fivetran Stripe sync." } dimension: days_until_due { sql: ${TABLE}.days_until_due ;; type: number + description: "Number of days a customer has to pay invoices generated by this subscription. This value will be null for subscriptions where `collection_method` = \"charge_automatically\"." } dimension: default_payment_method_id { sql: ${TABLE}.default_payment_method_id ;; type: string + description: "ID of the default payment method for the subscription. It must belong to the customer associated with the subscription. This takes precedence over `default_source_id`. If neither are set, invoices will use the customer's `invoice_settings.default_payment_method` or `default_source`." } dimension: default_source_id { sql: ${TABLE}.default_source_id ;; type: string + description: "ID of the default payment source for the subscription. It must belong to the customer associated with the subscription and be in a chargeable state. If `default_payment_method` is also set, `default_payment_method` will take precedence. If neither are set, invoices will use the customer's `invoice_settings.default_payment_method` or `default_source`." } dimension: default_tax_rates { sql: ${TABLE}.default_tax_rates ;; hidden: yes + description: "The tax rates that will apply to any subscription item that does not have `tax_rates` set. Invoices created will have their `default_tax_rates` populated from the subscription." } dimension: discount__coupon__amount_off { @@ -192,6 +226,7 @@ type: number group_label: "Discount Coupon" group_item_label: "Amount Off" + description: "Amount (in the `currency` specified) that will be taken off the subtotal of any invoices for this customer." } dimension: discount__coupon__currency { @@ -199,6 +234,7 @@ type: string group_label: "Discount Coupon" group_item_label: "Currency" + description: "If `amount_off` has been set, the three-letter ISO code for the currency of the amount to take off." } dimension: discount__coupon__duration { @@ -206,6 +242,10 @@ type: string group_label: "Discount Coupon" group_item_label: "Duration" + description: "One of \"forever\", \"once\", and \"repeating\". Describes how long a customer who applies this coupon will get the discount. +\"forever\" applies to all charges from a subscription with this coupon applied. +\"once\" applies to the first charge from a subscription with this coupon applied. +\"repeating\" applies to charges in the first `duration_in_months` months from a subscription with this coupon applied." } dimension: discount__coupon__duration_in_months { @@ -213,6 +253,7 @@ type: number group_label: "Discount Coupon" group_item_label: "Duration In Months" + description: "If `duration` is \"repeating\", the number of months the coupon applies. Null if coupon `duration` is \"forever\" or \"once\"." } dimension: discount__coupon__id { @@ -220,11 +261,13 @@ type: string group_label: "Discount Coupon" group_item_label: "Id" + description: "Coupon ID." } dimension: discount__coupon__metadata { sql: ${TABLE}.discount.coupon.metadata ;; hidden: yes + description: "Set of key-value pairs attached to the coupon, stored as a JSON object." } dimension: discount__coupon__name { @@ -232,6 +275,7 @@ type: string group_label: "Discount Coupon" group_item_label: "Name" + description: "Name of the coupon displayed to customers on invoices or receipts." } dimension: discount__coupon__percent_off { @@ -239,6 +283,7 @@ type: number group_label: "Discount Coupon" group_item_label: "Percent Off" + description: "Percent that will be taken off the subtotal of any invoices for this customer for the duration of the coupon. For example, a coupon with `percent_off` of 50 will make a $100 invoice $50 instead." } dimension: discount__id { @@ -246,6 +291,7 @@ type: string group_label: "Discount" group_item_label: "Id" + description: "Discount ID." } dimension: discount__invoice_id { @@ -253,6 +299,7 @@ type: string group_label: "Discount" group_item_label: "Invoice Id" + description: "ID of the invoice that the discount's coupon was applied to, if it was applied directly to a particular invoice." } dimension: discount__invoice_item_id { @@ -260,6 +307,7 @@ type: string group_label: "Discount" group_item_label: "Invoice Item Id" + description: "ID of the invoice item (or invoice line item for invoice line items of `type` = \"subscription\") that the discount's coupon was applied to, if it was applied directly to a particular invoice item or invoice line item." } dimension: discount__promotion_code_id { @@ -267,21 +315,25 @@ type: string group_label: "Discount" group_item_label: "Promotion Code Id" + description: "ID of the promotion code applied to create this discount." } dimension: id { sql: ${TABLE}.id ;; type: string + description: "Subscription ID." } dimension: items { sql: ${TABLE}.items ;; hidden: yes + description: "List of subscription items, each with an attached plan." } dimension: latest_invoice_id { sql: ${TABLE}.latest_invoice_id ;; type: string + description: "ID of the most recent invoice this subscription has generated." } dimension: metadata__appliedPromotionCode { @@ -289,6 +341,7 @@ type: string group_label: "Metadata" group_item_label: "Appliedpromotioncode" + description: "Promotion code applied to the subscription (if any)." } dimension: metadata__cancellation_reason { @@ -296,6 +349,7 @@ type: string group_label: "Metadata" group_item_label: "Cancellation Reason" + description: "Reason the subscription was canceled (if any)." } dimension: metadata__previous_plan_id { @@ -303,16 +357,23 @@ type: string group_label: "Metadata" group_item_label: "Previous Plan Id" + description: "ID of the previous plan the customer was subscribed to via this subscription (if any)." } dimension: pending_setup_intent_id { sql: ${TABLE}.pending_setup_intent_id ;; type: string + description: "ID of a setup intent to collect user authentication when creating a subscription without immediate payment or updating a subscription's payment method." } dimension: status { sql: ${TABLE}.status ;; type: string + description: "Possible values are \"incomplete\", \"incomplete_expired\", \"trialing\", \"active\", \"past_due\", \"canceled\", \"unpaid\", or \"paused\". +For `collection_method` = \"charge_automatically\" a subscription moves into \"incomplete\" if the initial payment attempt fails. Once the first invoice is paid, the subscription moves into an \"active\" state. If the first invoice is not paid within 23 hours, the subscription transitions to \"incomplete_expired\". +A subscription that is currently in a trial period is \"trialing\" and moves to \"active\" when the trial period is over. +If subscription `collection_method` = \"charge_automatically\" it becomes \"past_due\" when payment to renew it fails and \"canceled\" or \"unpaid\" (depending on your subscriptions settings) when Stripe has exhausted all payment retry attempts. +If subscription `collection_method` = \"send_invoice\" it becomes \"past_due\" when its invoice is not paid by the due date, and \"canceled\" or \"unpaid\" if it is still not paid by an additional deadline after that." } dimension_group: billing_cycle_anchor { @@ -327,6 +388,7 @@ quarter, year, ] + description: "The time of the first full invoice, and, for plans with month or year intervals, the day of the month for subsequent invoices." } dimension_group: cancel_at { @@ -341,6 +403,7 @@ quarter, year, ] + description: "A time in the future at which the subscription will automatically get canceled." } dimension_group: canceled_at { @@ -355,6 +418,7 @@ quarter, year, ] + description: "If the subscription has been canceled, the time at which it was canceled. If the subscription was canceled with `cancel_at_period_end`, `canceled_at` will reflect the time of the most recent update request, not the end of the subscription period when the subscription is automatically moved to a canceled state." } dimension_group: created { @@ -369,6 +433,7 @@ quarter, year, ] + description: "Time at which the subscription was created." } dimension_group: current_period_end { @@ -383,6 +448,7 @@ quarter, year, ] + description: "End time of the current period that the subscription has been invoiced for. At the end of this period, a new invoice will be created." } dimension_group: current_period_start { @@ -397,6 +463,7 @@ quarter, year, ] + description: "Start time of the current period that the subscription has been invoiced for." } dimension_group: customer__created { @@ -412,6 +479,7 @@ year, ] label: "Customer: Created" + description: "Time at which the customer was created." } dimension_group: customer__discount__coupon__created { @@ -427,6 +495,7 @@ year, ] label: "Customer Discount Coupon: Created" + description: "Time at which the coupon was created." } dimension_group: customer__discount__coupon__redeem_by { @@ -442,6 +511,7 @@ year, ] label: "Customer Discount Coupon: Redeem By" + description: "Time after which the coupon can no longer be redeemed." } dimension_group: customer__discount__end { @@ -457,6 +527,7 @@ year, ] label: "Customer Discount: End" + description: "If the coupon has a duration of \"repeating\", the time that this discount will end. If the coupon has a duration of \"once\" or \"forever\", this attribute will be null." } dimension_group: customer__discount__start { @@ -472,6 +543,7 @@ year, ] label: "Customer Discount: Start" + description: "Time at which the coupon was applied." } dimension_group: customer__metadata__geoip { @@ -487,6 +559,8 @@ year, ] label: "Customer Metadata: Geoip Date" + description: "Time at which IP address-based geo-location was done for the customer. +This isn't available for customers that were deleted before the initial Fivetran Stripe sync." } dimension_group: discount__coupon__created { @@ -502,6 +576,7 @@ year, ] label: "Discount Coupon: Created" + description: "Time at which the coupon was created." } dimension_group: discount__coupon__redeem_by { @@ -517,6 +592,7 @@ year, ] label: "Discount Coupon: Redeem By" + description: "Time after which the coupon can no longer be redeemed." } dimension_group: discount__end { @@ -532,6 +608,7 @@ year, ] label: "Discount: End" + description: "If the coupon has a duration of \"repeating\", the time that this discount will end. If the coupon has a duration of \"once\" or \"forever\", this attribute will be null." } dimension_group: discount__start { @@ -547,6 +624,7 @@ year, ] label: "Discount: Start" + description: "Time at which the coupon was applied." } dimension_group: ended_at { @@ -561,6 +639,7 @@ quarter, year, ] + description: "If the subscription has ended, the time at which the subscription ended." } dimension_group: metadata__cancelled_for_customer_at { @@ -576,6 +655,7 @@ year, ] label: "Metadata: Cancelled For Customer At" + description: "When the customer canceled the subscription, if they've done so." } dimension_group: metadata__plan_change { @@ -591,6 +671,7 @@ year, ] label: "Metadata: Plan Change Date" + description: "The most recent time when the subscription plan was changed (if any)." } dimension_group: start { @@ -605,6 +686,7 @@ quarter, year, ] + description: "Start time of the subscription. This might differ from `created` due to backdating." } dimension_group: trial_end { @@ -619,6 +701,7 @@ quarter, year, ] + description: "If the subscription has a trial, the end time of that trial." } dimension_group: trial_start { @@ -633,6 +716,7 @@ quarter, year, ] + description: "If the subscription has a trial, the start time of that trial." } sql_table_name: `moz-fx-data-shared-prod.subscription_platform_derived.stripe_subscriptions_v2` ;; @@ -642,36 +726,43 @@ dimension: description { sql: ${TABLE}.description ;; type: string + description: "An arbitrary description of the tax rate for your internal use only. It will not be visible to your customers." } dimension: display_name { sql: ${TABLE}.display_name ;; type: string + description: "The display name of the tax rate as it will appear to your customer on their receipt email, PDF, and the hosted invoice page." } dimension: id { sql: ${TABLE}.id ;; type: string + description: "Tax rate ID." } dimension: inclusive { sql: ${TABLE}.inclusive ;; type: yesno + description: "Whether the tax rate is inclusive." } dimension: jurisdiction { sql: ${TABLE}.jurisdiction ;; type: string + description: "The jurisdiction for the tax rate. You can use this label field for tax reporting purposes. It also appears on your customer's invoice." } dimension: metadata { sql: ${TABLE}.metadata ;; hidden: yes + description: "Set of key-value pairs attached to the tax rate, stored as a JSON object." } dimension: percentage { sql: ${TABLE}.percentage ;; type: number + description: "Tax rate percentage out of 100. For tax calculations with `automatic_tax[enabled]=true`, this percentage includes the statutory tax rate of non-taxable jurisdictions." } } @@ -679,11 +770,13 @@ dimension: id { sql: ${TABLE}.id ;; type: string + description: "Subscription item ID." } dimension: metadata { sql: ${TABLE}.metadata ;; hidden: yes + description: "Set of key-value pairs attached to the subscription item, stored as a JSON object." } dimension: plan__aggregate_usage { @@ -691,6 +784,7 @@ type: string group_label: "Plan" group_item_label: "Aggregate Usage" + description: "Specifies a usage aggregation strategy for plans of `usage_type` = \"metered\". Allowed values are \"sum\" for summing up all usage during a period, \"last_during_period\" for using the last usage record reported within a period, \"last_ever\" for using the last usage record ever (across period bounds) or \"max\" which uses the usage record with the maximum reported usage during a period." } dimension: plan__amount { @@ -698,6 +792,7 @@ type: number group_label: "Plan" group_item_label: "Amount" + description: "The unit amount in cents to be charged, represented as a whole integer if possible. Only set if `billing_scheme` = \"per_unit\"." } dimension: plan__billing_scheme { @@ -705,6 +800,7 @@ type: string group_label: "Plan" group_item_label: "Billing Scheme" + description: "Describes how to compute the price per period. Either \"per_unit\" or \"tiered\". \"per_unit\" indicates that the fixed amount (specified in `amount`) will be charged per unit in `quantity` (for plans with `usage_type` = \"licensed\"), or per unit of total usage (for plans with `usage_type` = \"metered\"). \"tiered\" indicates that the unit pricing will be computed using a tiering strategy as defined using the `tiers` and `tiers_mode` attributes." } dimension: plan__currency { @@ -712,6 +808,7 @@ type: string group_label: "Plan" group_item_label: "Currency" + description: "Three-letter ISO currency code, in lowercase." } dimension: plan__id { @@ -719,6 +816,7 @@ type: string group_label: "Plan" group_item_label: "Id" + description: "Plan ID." } dimension: plan__interval { @@ -726,6 +824,7 @@ type: string group_label: "Plan" group_item_label: "Interval" + description: "The frequency at which a subscription is billed. One of \"day\", \"week\", \"month\" or \"year\"." } dimension: plan__interval_count { @@ -733,11 +832,13 @@ type: number group_label: "Plan" group_item_label: "Interval Count" + description: "The number of intervals (specified in the `interval` attribute) between subscription billings." } dimension: plan__metadata { sql: ${TABLE}.plan.metadata ;; hidden: yes + description: "Set of key-value pairs attached to the plan, stored as a JSON object." } dimension: plan__nickname { @@ -745,6 +846,7 @@ type: string group_label: "Plan" group_item_label: "Nickname" + description: "A brief description of the plan, hidden from customers." } dimension: plan__product__description { @@ -752,6 +854,7 @@ type: string group_label: "Plan Product" group_item_label: "Description" + description: "The product's description, meant to be displayable to the customer." } dimension: plan__product__id { @@ -759,11 +862,13 @@ type: string group_label: "Plan Product" group_item_label: "Id" + description: "Product ID." } dimension: plan__product__metadata { sql: ${TABLE}.plan.product.metadata ;; hidden: yes + description: "Set of key-value pairs attached to the product, stored as a JSON object." } dimension: plan__product__name { @@ -771,6 +876,7 @@ type: string group_label: "Plan Product" group_item_label: "Name" + description: "The product's name, meant to be displayable to the customer." } dimension: plan__product__statement_descriptor { @@ -778,6 +884,7 @@ type: string group_label: "Plan Product" group_item_label: "Statement Descriptor" + description: "Extra information about a product which will appear on your customer's credit card statement." } dimension: plan__tiers_mode { @@ -785,6 +892,7 @@ type: string group_label: "Plan" group_item_label: "Tiers Mode" + description: "Defines if the tiering price should be \"graduated\" or \"volume\". In volume-based tiering, the maximum quantity within a period determines the per unit price. In graduated tiering, pricing can change as the quantity grows." } dimension: plan__trial_period_days { @@ -792,6 +900,7 @@ type: number group_label: "Plan" group_item_label: "Trial Period Days" + description: "Default number of trial days when subscribing a customer to this plan using `trial_from_plan=true`." } dimension: plan__usage_type { @@ -799,10 +908,12 @@ type: string group_label: "Plan" group_item_label: "Usage Type" + description: "Configures how the quantity per period should be determined. Can be either \"metered\" or \"licensed\". \"licensed\" automatically bills the quantity set when adding it to a subscription. \"metered\" aggregates the total usage based on usage records." } dimension: quantity { sql: ${TABLE}.quantity ;; type: number + description: "The quantity of the plan to which the customer should be subscribed." } } \ No newline at end of file diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/user_journey/views/events_daily.view.lkml /tmp/workspace/generated-lookml/user_journey/views/events_daily.view.lkml --- /tmp/workspace/looker-hub/user_journey/views/events_daily.view.lkml 2024-11-27 10:12:59.056682407 +0000 +++ /tmp/workspace/generated-lookml/user_journey/views/events_daily.view.lkml 1970-01-01 00:00:00.000000000 +0000 @@ -1,71 +0,0 @@ -view: events_daily { - sql_table_name: `mozdata.messaging_system.events_daily` - ;; - - dimension: addon_version { - type: string - sql: ${TABLE}.addon_version ;; - } - - dimension: app_version { - type: string - sql: ${TABLE}.app_version ;; - } - - dimension: city { - type: string - sql: ${TABLE}.city ;; - } - - dimension: client_id { - type: string - sql: ${TABLE}.client_id ;; - } - - dimension: country { - type: string - map_layer_name: countries - sql: ${TABLE}.country ;; - } - - dimension: events { - type: string - sql: ${TABLE}.events ;; - hidden: yes - } - - dimension: experiments { - hidden: yes - sql: ${TABLE}.experiments ;; - } - - dimension: locale { - type: string - sql: ${TABLE}.locale ;; - } - - dimension: normalized_channel { - type: string - sql: ${TABLE}.normalized_channel ;; - } - - dimension: os { - type: string - sql: ${TABLE}.os ;; - } - - dimension: sample_id { - type: number - sql: ${TABLE}.sample_id ;; - } - - dimension: subdivision1 { - type: string - sql: ${TABLE}.subdivision1 ;; - } - - dimension: submission_date { - type: date - sql: CAST(${TABLE}.submission_date AS TIMESTAMP) ;; - } -} ```

Link to full diff