view: sony_applications_data_submit {
  derived_table: {
    sql:
      select
        replace(record_content:AmazonMusicUrl__c, '"', '') AS AmazonMusicUrl,
        replace(record_content:Company, '"', '') AS Company,
        replace(record_content:CorrelationId__c, '"', '') AS CorrelationId,
        replace(record_content:Country, '"', '') AS Country,
        replace(record_content:Currency__c, '"', '') AS Currency,
        replace(record_content:DeezerUrl__c, '"', '') AS DeezerUrl,
        replace(record_content:Email, '"', '') AS Email,
        replace(record_content:FacebookUrl__c, '"', '') AS FacebookUrl,
        replace(record_content:FirstName, '"', '') AS FirstName,
        replace(record_content:InstagramUrl__c, '"', '') AS InstagramUrl,
        replace(record_content:Language__c, '"', '') AS Language,
        replace(record_content:LastName, '"', '') AS LastName,
        replace(record_content:OtherUrl__c, '"', '') AS OtherUrl,
        replace(record_content:RecordTypeId, '"', '') AS RecordTypeId,
        replace(record_content:Role__c, '"', '') AS Role,
        replace(record_content:SigningEntity__c, '"', '') AS SigningEntity,
        replace(record_content:SoundcloudUrl__c, '"', '') AS SoundcloudUrl,
        replace(record_content:SpotifyUrl__c, '"', '') AS SpotifyUrl,
        replace(record_content:TiktokUrl__c, '"', '') AS TikTokUrl,
        replace(record_content:TwitterUrl__c, '"', '') AS TwitterUrl,
        replace(record_content:VoucherCode__c, '"', '') AS VoucherCode,
        replace(record_content:VoucherCodeOwner__c, '"', '') AS VoucherCodeOwner,
        replace(record_content:YoutubeUrl__c, '"', '') AS YouTubeUrl
      FROM
        FACTS.PROD.AUDIT_EVENT_GDA_SUBMIT_APPLICATION;;
  }

  dimension: AmazonMusicUrl {
    type: string
    sql: ${TABLE}.AmazonMusicUrl ;;
    label: "Amazon Music URL"
  }

  dimension: Company {
    type: string
    sql: ${TABLE}.Company ;;
    label: "Company"
  }

  dimension: CorrelationId {
    type: string
    sql: ${TABLE}.CorrelationId ;;
    label: "Correlation ID"
  }

  dimension: Country {
    type: string
    sql: ${TABLE}.Country ;;
    label: "Country"
  }

  dimension: Currency {
    type: string
    sql: ${TABLE}.Currency ;;
    label: "Currency"
  }

  dimension: DeezerFans {
    type: number
    sql: ${TABLE}.DeezerFans ;;
    label: "Deezer Fans"
  }

  dimension: DeezerUrl {
    type: string
    sql: ${TABLE}.DeezerUrl ;;
    label: "Deezer URL"
  }

  dimension: Email {
    type: string
    sql: ${TABLE}.Email ;;
    label: "Email"
  }

  dimension: ExistingLabelParticipants {
    type: string
    sql: ${TABLE}.ExistingLabelParticipants ;;
    label: "Existing Label Participants"
  }

  dimension: ExternalTest {
    type: string
    sql: ${TABLE}.ExternalTest ;;
    label: "External Test"
  }

  dimension: FacebookFollowers {
    type: number
    sql: ${TABLE}.FacebookFollowers ;;
    label: "Facebook Followers"
  }

  dimension: FacebookUrl {
    type: string
    sql: ${TABLE}.FacebookUrl ;;
    label: "Facebook URL"
  }

  dimension: FirstName {
    type: string
    sql: ${TABLE}.FirstName ;;
    label: "First Name"
  }

  dimension: InstagramFollowers {
    type: number
    sql: ${TABLE}.InstagramFollowers ;;
    label: "Instagram Followers"
  }

  dimension: InstagramUrl {
    type: string
    sql: ${TABLE}.InstagramUrl ;;
    label: "Instagram URL"
  }

  dimension: Language {
    type: string
    sql: ${TABLE}.Language ;;
    label: "Language"
  }

  dimension: LastName {
    type: string
    sql: ${TABLE}.LastName ;;
    label: "Last Name"
  }

  dimension: OtherUrl {
    type: string
    sql: ${TABLE}.OtherUrl ;;
    label: "Other URL"
  }

  dimension: RecordTypeId {
    type: string
    sql: ${TABLE}.RecordTypeId ;;
    label: "Record Type ID"
  }

  dimension: Role {
    type: string
    sql: ${TABLE}.Role ;;
    label: "Role"
  }

  dimension: SigningEntity {
    type: string
    sql: ${TABLE}.SigningEntity ;;
    label: "Signing Entity"
  }

  dimension: SoundcloudUrl {
    type: string
    sql: ${TABLE}.SoundcloudUrl ;;
    label: "Soundcloud URL"
  }

  dimension: SpotifyUrl {
    type: string
    sql: ${TABLE}.SpotifyUrl ;;
    label: "Spotify URL"
  }

  dimension: TiktokUrl {
    type: string
    sql: ${TABLE}.TiktokUrl ;;
    label: "Tiktok URL"
  }

  dimension: TwitterUrl {
    type: string
    sql: ${TABLE}.TwitterUrl ;;
    label: "Twitter URL"
  }
  dimension: VoucherCode {
    type: string
    sql: ${TABLE}.VoucherCode ;;
    label: "Referral Code"
  }
  dimension: VoucherCodeOwner {
    type: string
    sql: ${TABLE}.VoucherCodeOwner ;;
    label: "Referral Code Owner"
  }
  dimension: YoutubeUrl {
    type: string
    sql: ${TABLE}.YoutubeUrl ;;
    label: "Youtube URL"
  }
}