# Package name name: 'dbt_analytics' version: '1.2' config-version: 2 # DB connection profile (specified in profiles.yml) profile: 'snowflake' # Paths for various types of files model-paths: ["models"] analysis-paths: ["analysis"] test-paths: ["tests"] seed-paths: ["data/base", "data/full_refresh", "data/incremental"] macro-paths: ["macros"] # Path to store compiled SQL files after running target-path: "target" # Paths to be removed with "dbt clean" clean-targets: - "target" - "dbt_modules" - "dbt_packages" vars: # Global vars source_schema: "{% if target.name == 'test' %}{{ env_var('SNOWFLAKE_SCHEMA') }}{% else %}{{ env_var('SOURCE_SNOWFLAKE_SCHEMA', env_var('SNOWFLAKE_SCHEMA')) }}{% endif %}" qa_target_name: 'qa' test_target_name: 'test' testing_playlist_ids: - '4Q6sdtgnqSr7Jvlzs2PboM' - '0l39hcFYh8rRPDIQTBUSE8' - '5WVIgjeB6gvHVhCvYxuGvZ' models: +transient: true on-run-start: - '{{ utils.create_udfs() }}' - '{% do utils.create_playlist_udfs() %}' # This is required to get rid of errors caused by automatic type detection. # This list is deduplicated. seeds: dbt_analytics: +enabled: true +quote_columns: false # base tables FACT_ANALYTICS: +column_types: ARTISTID: NUMBER(32,0) DAYID: NUMBER(32,0) LABELID: NUMBER(32,0) STOREID: NUMBER(32,0) GENREID: NUMBER(32,0) RELEASEID: NUMBER(38,0) TRACKID: NUMBER(38,0) COUNTRYID: NUMBER(32,0) TRANSACTIONTYPEID: NUMBER(32,0) ZIPID: NUMBER(38,0) CATALOGID: NUMBER(32,0) ISRCID: NUMBER(38,0) IMPRINTID: NUMBER(32,0) CURRENCYID: NUMBER(32,0) STOREUSERID: NUMBER(38,0) PROCESSEDDAYTIME: TIMESTAMP_NTZ(3) ROYALTY: NUMBER(18,6) ROYALTYDOLLAR: NUMBER(18,6) UNITS: NUMBER(32,0) PAIDUNITS: NUMBER(32,0) FREEUNITS: NUMBER(32,0) UUID: VARCHAR(2000) SUBACCOUNTID: NUMBER(32,0) DOWNLOAD_ACTIVITY_DATE: DATE FORMATID: NUMBER(32,0) LISTENDURATION: NUMBER(38,0) PLAYLISTID: NUMBER(38,0) SOURCETYPEID: NUMBER(38,0) CONTAINERTYPEID: NUMBER(38,0) REPORTDATE: DATE STAGINGRAWID: NUMBER(38,0) FEEDID: NUMBER(38,0) USERID: NUMBER(38,0) STOREUSERID_VARCHAR: VARCHAR(16777216) LICENSORID: NUMBER(38,0) REGIONCODE: VARCHAR(16777216) SUBSCRIPTIONPAYTIERID: NUMBER(38,0) SUBSCRIPTIONTYPEID: NUMBER(38,0) OSID: NUMBER(38,0) DEVICEID: NUMBER(38,0) FACT_POINT_OF_SALE: +column_types: ROW_ID: NUMBER(38,0) INGESTION_DATETIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE LABELID: NUMBER(38,0) SUBACCOUNTID: NUMBER(38,0) ARTISTID: NUMBER(38,0) RELEASEID: NUMBER(38,0) DISPLAY_UPC: VARCHAR(16777216) PROVIDERID: NUMBER(38,0) COUNTRYID: NUMBER(38,0) REGION_NAME: VARCHAR(16777216) DAYID: NUMBER(38,0) UNITS: NUMBER(38,0) UNITS_TO_DATE: NUMBER(38,0) FACT_YOUTUBE_ASSET_ANALYTICS: +column_types: FEEDID: NUMBER(38,0) ARTISTID: NUMBER(38,0) DAYID: NUMBER(38,0) LABELID: NUMBER(38,0) STOREID: NUMBER(38,0) GENREID: NUMBER(38,0) TRACKID: NUMBER(38,0) ACTIVITYCOUNTRYID: NUMBER(38,0) CATALOGID: NUMBER(38,0) ISRCID: NUMBER(38,0) IMPRINTID: NUMBER(38,0) SUBACCOUNTID: NUMBER(38,0) PROCESSEDDAYTIME: TIMESTAMP_NTZ(3) DOWNLOAD_ACTIVITY_DATE: DATE VIDEOID: VARCHAR(16777216) ASSETID: VARCHAR(16777216) CHANNELID: VARCHAR(16777216) UPLOADERTYPE: VARCHAR(16777216) CONTENTOWNER: VARCHAR(16777216) AVERAGE_VIEW_DURATION_PERCENTAGE: FLOAT AVERAGE_VIEW_DURATION_SECONDS: FLOAT VIEWS: NUMBER(38,0) RED_VIEWS: NUMBER(38,0) WATCH_TIME_MINUTES: FLOAT RED_WATCH_TIME_MINUTES: FLOAT COMMENTS: NUMBER(38,0) DISLIKES: NUMBER(38,0) LIKES: NUMBER(38,0) SHARES: NUMBER(38,0) VIDEOS_ADDED_TO_PLAYLISTS: NUMBER(38,0) VIDEOS_REMOVED_FROM_PLAYLISTS: NUMBER(38,0) ESTIMATED_PARTNER_REVENUE: FLOAT ESTIMATED_PARTNER_AD_REVENUE: FLOAT ESTIMATED_PARTNER_RED_REVENUE: FLOAT LICENSORID: NUMBER(38,0) ASSET_TYPE: VARCHAR(16777216) FACT_YOUTUBE_VIDEO_ANALYTICS: +column_types: FEEDID: NUMBER(38,0) DAYID: NUMBER(38,0) STOREID: NUMBER(38,0) ACTIVITYCOUNTRYID: NUMBER(38,0) PROCESSEDDAYTIME: TIMESTAMP_NTZ(3) DOWNLOAD_ACTIVITY_DATE: DATE VIDEOID: VARCHAR(16777216) CHANNELID: VARCHAR(16777216) UPLOADERTYPE: VARCHAR(16777216) CONTENTOWNER: VARCHAR(16777216) AVERAGE_VIEW_DURATION_PERCENTAGE: FLOAT AVERAGE_VIEW_DURATION_SECONDS: FLOAT VIEWS: NUMBER(38,0) RED_VIEWS: NUMBER(38,0) WATCH_TIME_MINUTES: FLOAT RED_WATCH_TIME_MINUTES: FLOAT SUBSCRIBERS_GAINED: NUMBER(38,0) SUBSCRIBERS_LOST: NUMBER(38,0) AD_IMPRESSIONS: NUMBER(38,0) ESTIMATED_CPM: FLOAT ESTIMATED_MONETIZED_PLAYBACKS: NUMBER(38,0) ESTIMATED_PLAYBACK_BASED_CPM: FLOAT ESTIMATED_YOUTUBE_AD_REVENUE: FLOAT ESTIMATED_PARTNER_REVENUE: FLOAT ESTIMATED_PARTNER_AD_REVENUE: FLOAT ESTIMATED_PARTNER_RED_REVENUE: FLOAT COMMENTS: NUMBER(38,0) SHARES: NUMBER(38,0) VIDEOS_ADDED_TO_PLAYLISTS: NUMBER(38,0) VIDEOS_REMOVED_FROM_PLAYLISTS: NUMBER(38,0) LIKES: NUMBER(38,0) DISLIKES: NUMBER(38,0) LICENSORID: NUMBER(38,0) FACT_YOUTUBE_VIDEO_DEMOGRAPHICS: +column_types: FEEDID: NUMBER(38,0) DAYID: NUMBER(38,0) STOREID: NUMBER(38,0) ACTIVITYCOUNTRYID: NUMBER(38,0) PROCESSEDDAYTIME: TIMESTAMP_NTZ(3) DOWNLOAD_ACTIVITY_DATE: DATE VIDEOID: VARCHAR(16777216) CHANNELID: VARCHAR(16777216) CLAIMEDSTATUS: VARCHAR(16777216) UPLOADERTYPE: VARCHAR(16777216) CONTENTOWNER: VARCHAR(16777216) DEVICEID: NUMBER(38,0) OSID: NUMBER(38,0) PLAYBACKID: NUMBER(38,0) TRAFFICSOURCEID: NUMBER(38,0) VIEWS: NUMBER(38,0) RED_VIEWS: NUMBER(38,0) WATCH_TIME_MINUTES: FLOAT RED_WATCH_TIME_MINUTES: FLOAT AVERAGE_VIEW_DURATION_PERCENTAGE: FLOAT AVERAGE_VIEW_DURATION_SECONDS: FLOAT LICENSORID: NUMBER(38,0) APPLE_ID_MAPPING: +column_types: APPLE_ID: NUMBER(38,0) ORCHARD_RELEASE_ID: VARCHAR(100) ORCHARD_TRACK_ID: VARCHAR(200) APPLE_RELEASE_ID: VARCHAR(200) APPLE_TRACK_ID: VARCHAR(200) VENDOR_IDENTIFIER: VARCHAR(200) VENDOR_OFFER_CODE: VARCHAR(200) ALBUM_OR_TRACK: VARCHAR(10) DEMOGRAPHICS_REGION_MAPPING_V2: +column_types: STORE_ID: NUMBER(38,0) TERRITORY_CODE: VARCHAR(16777216) REGION_CODE: VARCHAR(16777216) ORCHARD_REGION_NAME: VARCHAR(16777216) ORCHARD_REGION_CODE: VARCHAR(16777216) DIM_ALGORITHMIC_PLAYLISTS: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38, 0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) DIM_ARTIST: +column_types: ARTISTID: NUMBER(32,0) ARTISTNAME: VARCHAR(2000) LABELID: NUMBER(32,0) COUNTRYID: NUMBER(32,0) DATE_CREATED: TIMESTAMP_NTZ(3) LAST_UPDATED: TIMESTAMP_NTZ(3) DIM_CLAIM: +column_types: CLAIMID: VARCHAR(16777216) VIDEOID: VARCHAR(16777216) ASSETID: VARCHAR(16777216) ISRCID: NUMBER(38,0) MATCHDURATION: NUMBER(38,0) TRACKDURATION: NUMBER(38,0) ISPREMIUMUGC: BOOLEAN CLAIMTYPE: VARCHAR(16777216) CLAIMCREATEDDATE: DATE VIDEOTITLE: VARCHAR(16777216) CHANNELDISPLAYNAME: VARCHAR(16777216) VIDEOUPLOADDATE: DATE CHANNELID: VARCHAR(16777216) CONTENTTYPE: VARCHAR(16777216) CLAIMSTATUS: VARCHAR(16777216) CLAIMPOLICYMONETIZE: VARCHAR(16777216) CLAIMPOLICYTRACK: VARCHAR(16777216) CLAIMPOLICYBLOCK: VARCHAR(16777216) CUSTOMID: VARCHAR(16777216) VIEWS: NUMBER(38,0) DIM_CONTAINERTYPE: +column_types: CONTAINERTYPEID: NUMBER(38,0) STOREID: NUMBER(38,0) STORECONTAINERTYPEID: VARCHAR(16777216) CONTAINERTYPENAME: VARCHAR(16777216) DIM_COUNTRY: +column_types: COUNTRYID: NUMBER(32,0) COUNTRYNAME: VARCHAR(255) COUNTRY_CODE: VARCHAR(2) CONTINENT: VARCHAR(30) LATITUDE: NUMBER(10,6) LONGITUDE: NUMBER(10,6) DATE_CREATED: TIMESTAMP_NTZ(3) LAST_UPDATED: TIMESTAMP_NTZ(3) CONTINENT_ID: NUMBER(32,0) DIM_DAY: +column_types: DAYID: NUMBER(16,0) DISPLAYDATE: DATE WEEKID: NUMBER(16,0) MONTHID: NUMBER(16,0) DIM_FEED: +column_types: FEEDID: NUMBER(38,0) FEEDNAME: VARCHAR(16777216) STOREID: NUMBER(38,0) DIM_GENRE: +column_types: GENREID: NUMBER(32,0) GENRENAME: VARCHAR(20) DATE_CREATED: TIMESTAMP_NTZ(3) LAST_UPDATED: TIMESTAMP_NTZ(3) DIM_LABEL: +column_types: LABELID: NUMBER(32,0) LABELNAME: VARCHAR(1000) PRIORITY: NUMBER(32,0) COUNTRYID: NUMBER(32,0) OWNER: VARCHAR(200) LAST_UPDATED: TIMESTAMP_NTZ(3) DATE_CREATED: TIMESTAMP_NTZ(3) ISDISTRIBUTOR: VARCHAR(3) OWNERID: NUMBER(32,0) BRANDID: VARCHAR SERVICETIERID: VARCHAR IS_DELETED: BOOLEAN DELETED_AT: TIMESTAMP_LTZ DIM_LICENSOR: +column_types: LICENSORID: NUMBER(38,0) STORELICENSORID: VARCHAR(16777216) LICENSORNAME: VARCHAR(16777216) STOREID: NUMBER(38,0) FEEDID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(16777216) DIM_PLAYLIST: +column_types: PLAYLISTID: NUMBER(38,0) STOREPLAYLISTID: VARCHAR(16777216) PLAYLISTAUTHOR: VARCHAR(16777216) PLAYLISTNAME: VARCHAR(16777216) PLAYLISTURL: VARCHAR(16777216) STOREID: NUMBER(38,0) PLAYLISTURI: VARCHAR(16777216) PLAYLISTIMAGE: VARCHAR(16777216) PLAYLISTTYPEID: VARCHAR(16777216) PLAYLISTTYPENAME: VARCHAR(16777216) CREATEDDATETIME: TIMESTAMP_LTZ(9) UPDATEDDATETIME: TIMESTAMP_LTZ(9) FEEDID: NUMBER(38,0) DIM_RELEASE: +column_types: RELEASEID: NUMBER(38,0) RELEASENAME: VARCHAR(1400) RELEASEDATE: TIMESTAMP_NTZ(3) GENREID: NUMBER(32,0) ARTISTID: NUMBER(32,0) VENDOR_CATALOG_NUMBER: VARCHAR(1000) IMPRINT: VARCHAR(255) SALE_START_DATE: TIMESTAMP_NTZ(3) DATE_ADDED: TIMESTAMP_NTZ(3) ORIGINAL_RELEASE_DATE: TIMESTAMP_NTZ(3) DELETIONS: VARCHAR(1) MKT_PRIORITY: VARCHAR(10) MANUFACTURER_UPC: VARCHAR(255) VERSION: VARCHAR(1000) LAST_UPDATED: TIMESTAMP_NTZ(3) DATE_CREATED: TIMESTAMP_NTZ(3) LABELID: NUMBER(32,0) SUBACCOUNTID: NUMBER(32,0) DISPLAY_UPC: VARCHAR(255) VENDOR_RELEASE_IDENTIFIER: VARCHAR(1000) PRODUCT_TYPE_ID: NUMBER(32,0) CATALOGID: NUMBER(32,0) IMPRINTID: NUMBER(32,0) PRODUCT_SUBTYPE_ID: NUMBER(32,0) COMPILATION: VARCHAR(2) PREORDER_DATE: DATE PHYSICAL_RELEASE_DATE: DATE THEATRICAL_RELEASE_DATE: DATE VOD_START_DATE: DATE ORIGINAL_DIGITAL_RELEASE_DATE: DATE RELEASE_STATUS: VARCHAR(50) CHANNEL_ID: NUMBER(32,0) ITUNES_PREVIEWABLE: VARCHAR(3) NEW_RELEASE: VARCHAR(30) SYNC_ONLY: VARCHAR(2) EST: VARCHAR(2) VOD: VARCHAR(2) DIGITAL_ONLY: VARCHAR(2) PROJECTID: NUMBER(38,0) PRODUCT_CODE: VARCHAR(128) NOT_FOR_DISTRIBUTION: VARCHAR(128) PRODUCT_ID: NUMBER(32,0) PRODUCT_TYPE: VARCHAR(128) PHYSICAL_PRODUCT_TYPE: VARCHAR(512) PHYSICAL_PRODUCT_FORMAT: VARCHAR(512) DISPLAY_CONFIGURATION: VARCHAR(512) FORMAT: VARCHAR(100) DELIVERED_VERSION: VARCHAR(16777216) P_LINE: VARCHAR(16777216) C_LINE: VARCHAR(16777216) DIM_SOURCETYPE: +column_types: SOURCETYPEID: NUMBER(38,0) STOREID: NUMBER(38,0) STORESOURCETYPEID: VARCHAR(16777216) SOURCETYPENAME: VARCHAR(16777216) FEEDID: NUMBER(38,0) DIM_SUBACCOUNT: +column_types: SUBACCOUNTID: NUMBER(32,0) LABELID: NUMBER(32,0) SUBACCOUNTNAME: VARCHAR(1000) PRIMARYGENRE: NUMBER(32,0) WEBSITEURL: VARCHAR(2000) MYSPACEURL: VARCHAR(2000) CITY: VARCHAR(200) STATEPROVINCE: VARCHAR(200) COUNTRY: NUMBER(32,0) DESCRIPTION: VARCHAR(30000) COMMISSIONOVERRIDE: NUMBER(12,6) DATE_DELETED: TIMESTAMP_NTZ(3) DATE_CREATED: TIMESTAMP_NTZ(3) LAST_UPDATED: TIMESTAMP_NTZ(3) SUBACCOUNT_SPLIT_TYPE: VARCHAR(10) DIM_TRACK_CLEAN_MV: +column_types: TRACKID: NUMBER(38,0) TRACK_UNIQUE_ID: NUMBER(32,0) TRACKNAME: VARCHAR(2000) UPC: NUMBER(38,0) CD: NUMBER(32,0) TRACK_ID: NUMBER(32,0) ISRC: VARCHAR(200) P_LINE: VARCHAR(1000) TRACK_TYPE: VARCHAR(100) VERSION: VARCHAR(2550) SOURCE: VARCHAR(2550) LAST_UPDATED: TIMESTAMP_NTZ(3) DATE_CREATED: TIMESTAMP_NTZ(3) LABELID: NUMBER(32,0) VENDOR_TRACK_IDENTIFIER: VARCHAR(255) ISRCID: NUMBER(32,0) THIRD_PARTY_PUBLISHER: VARCHAR(10) RESOLUTION: VARCHAR(500) DURATION: NUMBER(32,0) OFFER_TYPE: VARCHAR DIM_USER: +column_types: USERID: NUMBER(38,0) STOREUSERID: VARCHAR(16777216) BIRTHYEAR: NUMBER(38,0) GENDER: VARCHAR(16777216) REGIONCODE: VARCHAR(16777216) COUNTRYCODE: VARCHAR(16777216) STOREID: NUMBER(38,0) LICENSORID: NUMBER(38,0) CREATEDDATETIME: TIMESTAMP_LTZ(9) UPDATEDDATETIME: TIMESTAMP_LTZ(9) FEEDID: NUMBER(38,0) DIM_YOUTUBE_CHANNEL_NAMES: +column_types: CHANNEL_ID: VARCHAR(16777216) CHANNEL_DISPLAY_NAME: VARCHAR(16777216) DESCRIPTION: VARCHAR(16777216) PUBLISHED_AT: TIMESTAMP_NTZ(3) THUMBNAIL_URL: VARCHAR(16777216) SUBSCRIBER_COUNT: NUMBER(38,0) UPDATED_AT: TIMESTAMP_NTZ(3) VIEW_COUNT: NUMBER(38,0) VIDEO_COUNT: NUMBER(38,0) IS_IN_MCN: BOOLEAN CHANNEL_OWNER: VARCHAR(100) YOUTUBE_VIDEO_ASSET_TYPE_MAPPING: +column_types: VIDEOID: VARCHAR(16777216) ASSET_TYPE: VARCHAR(16777216) SONY_APPLE_ID_MAPPING: +column_types: APPLE_ID: NUMBER(38,0) UPC: VARCHAR(100) ISRC: VARCHAR(200) ALBUM_OR_TRACK: VARCHAR(16777216) AWAL_APPLE_ID_MAPPING: +column_types: APPLE_ID: NUMBER(38,0) UPC: VARCHAR(100) ISRC: VARCHAR(200) ALBUM_OR_TRACK: VARCHAR(16777216) STAGING_RAW_APPLE_MUSIC_DEMOGRAPHICS: +column_types: PROCESSED_DATETIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE FILENAME: VARCHAR(200) VENDOR_NAME: VARCHAR(20) DATESTAMP: DATE INGEST_DATESTAMP: DATE APPLE_IDENTIFIER: NUMBER(38,0) STOREFRONT_NAME: VARCHAR(2) MEMBERSHIP_TYPE: VARCHAR(250) MEMBERSHIP_MODE: VARCHAR(250) ACTION_TYPE: NUMBER(1,0) GENDER: NUMBER(1,0) AGE_BAND: VARCHAR(250) LISTENERS: NUMBER(12,0) STREAMS: NUMBER(12,0) ISRC: VARCHAR(20) TITLE: VARCHAR(2000) ARTIST: VARCHAR(2000) ARTIST_ID: VARCHAR(500) ITEM_TYPE: VARCHAR(2000) MEDIA_TYPE: VARCHAR(2000) VENDOR_IDENTIFIER: VARCHAR(2000) STAGING_RAW_APPLE_MUSIC_CONTAINER: +column_types: ROW_ID: NUMBER(38,0) PROCESSED_DAYTIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE FILENAME: VARCHAR(200) VENDOR_NAME: VARCHAR(20) INGEST_DATESTAMP: DATE STOREFRONT_NAME: VARCHAR(2000) APPLE_IDENTIFIER: NUMBER(38,0) CONTAINER_SUBTYPE: NUMBER(38,0) CONTAINER_ID: VARCHAR(16777216) CONTAINER_NAME: VARCHAR(16777216) STREAMS: NUMBER(38,0) ISRC: VARCHAR(100) ITEM_TITLE: VARCHAR(2000) ITEM_ARTIST: VARCHAR(2000) ITEM_TYPE: VARCHAR(2000) MEDIA_TYPE: VARCHAR(2000) VENDOR_IDENTIFIER: VARCHAR(2000) ITEM_ARTIST_ID: VARCHAR(500) MEDIA_DURATION: NUMBER(38,0) STAGING_RAW_APPLE_MUSIC_STREAMS: +column_types: ROW_ID: NUMBER(38,0) PROCESSED_DAYTIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE FILENAME: VARCHAR(200) VENDOR_NAME: VARCHAR(20) DATESTAMP: DATE INGEST_DATESTAMP: DATE APPLE_IDENTIFIER: NUMBER(38,0) STOREFRONT_NAME: VARCHAR(2000) MEMBERSHIP: VARCHAR(2000) MEMBERSHIP_MODE: VARCHAR(2000) POSTAL_CODE: VARCHAR(1000) DEVICE: NUMBER(38,0) OPERATING_SYSTEM: NUMBER(32,0) UTC_OFFSET: VARCHAR(6) ACTION_TYPE: NUMBER(32,0) END_REASON_TYPE: NUMBER(32,0) OFFLINE: NUMBER(32,0) SOURCE_OF_STREAM: NUMBER(32,0) CONTAINER_TYPE: NUMBER(32,0) STREAM_TIMESTAMP: NUMBER(38,0) STREAM_START_POSITION: NUMBER(38,0) STREAM_DURATION: NUMBER(38,0) MEDIA_DURATION: NUMBER(38,0) PLAYLIST_TYPE: NUMBER(32,0) PLAYLIST_ID: VARCHAR(2000) PLAYLIST_NAME: VARCHAR(2000) ISRC: VARCHAR(20) ITEM_TITLE: VARCHAR(2000) ITEM_ARTIST: VARCHAR(2000) ITEM_TYPE: VARCHAR(2000) MEDIA_TYPE: VARCHAR(2000) VENDOR_IDENTIFIER: VARCHAR(2000) ITEM_ARTIST_ID: VARCHAR(500) CUSTOMER_IDENTIFIER: VARCHAR(64) CITY: VARCHAR(2000) STATE_PROVINCE: VARCHAR(2000) STAGING_RAW_APPLE_MUSIC_SUMMARY_STREAMS: +column_types: ROW_ID: NUMBER(38,0) PROCESSED_DAYTIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE FILENAME: VARCHAR(200) VENDOR_NAME: VARCHAR(20) DATESTAMP: DATE INGEST_DATESTAMP: DATE APPLE_IDENTIFIER: NUMBER(38,0) STOREFRONT_NAME: VARCHAR(2000) TIME_BUCKET: NUMBER(38,0) SUBSCRIPTION_TYPE: VARCHAR(16777216) SUBSCRIPTION_MODE: VARCHAR(16777216) CHANNEL_PARTNER: VARCHAR(16777216) DEVICE_TYPE: NUMBER(38,0) SOURCE_OF_STREAM: NUMBER(38,0) CONTAINER_SUBTYPE: NUMBER(38,0) CONTAINER_ID: VARCHAR(16777216) CONTAINER_NAME: VARCHAR(16777216) END_REASON_TYPE: NUMBER(38,0) OFFLINE: NUMBER(38,0) AUDIO_FORMAT: VARCHAR(16777216) STREAMS: NUMBER(38,0) ISRC: VARCHAR(100) ITEM_TITLE: VARCHAR(2000) ITEM_ARTIST: VARCHAR(2000) ITEM_TYPE: VARCHAR(2000) MEDIA_TYPE: VARCHAR(2000) VENDOR_IDENTIFIER: VARCHAR(2000) ITEM_ARTIST_ID: VARCHAR(500) MEDIA_DURATION: NUMBER(38,0) STAGING_RAW_LINE_SEX_AGE: +column_types: ROW_ID: NUMBER(38,0) PROCESSED_DATETIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE DT: DATE LABEL_NO: VARCHAR(16777216) LABEL_NM: VARCHAR(16777216) TRACK_EX_ID: VARCHAR(16777216) TRACK_NM: VARCHAR(16777216) ISRC: VARCHAR(16777216) TRACK_PRODUCT_NO: VARCHAR(16777216) TRACK_GRID: VARCHAR(16777216) ARTIST_EX_ID: VARCHAR(16777216) ARTIST_NM: VARCHAR(16777216) ALBUM_DISC_NO: VARCHAR(16777216) ALBUM_TRACK_NO: VARCHAR(16777216) ALBUM_EX_ID: VARCHAR(16777216) ALBUM_NM: VARCHAR(16777216) UPC: VARCHAR(16777216) CATALOG_NO: VARCHAR(16777216) PACKAGE_NO: VARCHAR(16777216) ALBUM_GRID: VARCHAR(16777216) SEX: VARCHAR(16777216) AGE_RANGE: VARCHAR(16777216) PLAY_COUNT: NUMBER(38,0) MASKED_FLAG: VARCHAR(16777216) STAGING_RAW_SOUNDCLOUD_STREAMLEVELREPORT: +column_types: ROW_ID: NUMBER(38,0) INGESTION_TIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE REPORTING_START_DATE: DATE REPORTING_END_DATE: DATE COUNTRY: VARCHAR(16777216) CUSTOMER_ID: VARCHAR(16777216) TRACK_ID: NUMBER(38,0) ISRC: VARCHAR(16777216) TIME_STAMP: TIMESTAMP_LTZ(9) OPERATING_SYSTEM: VARCHAR(16777216) CLIENT_APPLICATION: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_ID: VARCHAR(16777216) POSITION_IN_PLAYLIST: VARCHAR(16777216) TRACK_TO_PLAYLIST: NUMBER(38,0) PLAY_LENGTH: NUMBER(38,0) TRACK_FAVOURITED: NUMBER(38,0) TRACK_REPOSTED_SHARED: NUMBER(38,0) TRACK_MESSAGE_POSTED: NUMBER(38,0) TRACK_TO_PLAYLIST_ADDED: NUMBER(38,0) STAGING_RAW_SOUNDCLOUD_TRACKINFORMATION: +column_types: ROW_ID: NUMBER(38,0) INGESTION_TIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE REPORTING_START_DATE: DATE REPORTING_END_DATE: DATE TRACK_ID: NUMBER(38,0) ISRC: VARCHAR(16777216) ALBUM_CODE: NUMBER(38,0) ALBUM_ARTIST: VARCHAR(16777216) TRACK_ARTIST: VARCHAR(16777216) TRACK_TITLE: VARCHAR(16777216) ALBUM_NAME: VARCHAR(16777216) TRACK_PERMALINK: VARCHAR(16777216) ALBUM_PERMALINK: VARCHAR(16777216) TRACK_SUPPLY_CHAIN_STATUS: VARCHAR(16777216) TRACK_LENGTH: NUMBER(38,0) STAGING_RAW_SOUNDCLOUD_CUSTOMERDATA: +column_types: ROW_ID: NUMBER(38,0) INGESTION_TIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE REPORTING_START_DATE: DATE REPORTING_END_DATE: DATE COUNTRY: VARCHAR(16777216) CUSTOMER_ID: VARCHAR(16777216) SIGNUP_YEAR: NUMBER(38,0) SUBS_LAST_PREMIUM_TRIAL_END: DATE SUBS_LAST_SUBSCRIPTION_START: DATE SUBS_LAST_SUBSCRIPTION_END: DATE USER_AGE: VARCHAR(16777216) USER_GENDER: VARCHAR(16777216) USER_CITY: VARCHAR(16777216) USER_REGION: VARCHAR(16777216) SUBS_LAST_SUBSCRIPTION_TIER: VARCHAR(16777216) STAGING_RAW_SPOTIFY_AGGREGATED_STREAMS: +column_types: ROW_ID: NUMBER(38,0) PROCESSED_DATETIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE FILENAME: VARCHAR(16777216) COUNTRY: VARCHAR(16777216) TRACK: VARCHAR(16777216) TRACK_HREF: VARCHAR(16777216) TRACK_ISRC: VARCHAR(16777216) ALBUM_NAME: VARCHAR(16777216) ALBUM_HREF: VARCHAR(16777216) ARTISTS_NAMES: VARCHAR(16777216) ARTISTS_HREFS: VARCHAR(16777216) ACTIVITY_DATE: DATE LABEL: VARCHAR(16777216) LICENSOR: VARCHAR(16777216) MESSAGE_NAME: VARCHAR(16777216) VERSION: VARCHAR(16777216) STREAMS: NUMBER(38,0) SKIPS: NUMBER(38,0) SAVES: NUMBER(38,0) SAVES_FREE: NUMBER(38,0) SAVES_PREMIUM: NUMBER(38,0) TRACK_ID: VARCHAR(16777216) ALBUM_CODE: VARCHAR(16777216) UPC: NUMBER(38,0) ALBUM_ARTIST: VARCHAR(16777216) TRACK_MESSAGE: VARCHAR(16777216) TRACK_VERSION: VARCHAR(16777216) API_LICENSOR: VARCHAR(16777216) GENDER: VARCHAR(16777216) AGE_GROUP: VARCHAR(16777216) STAGING_RAW_SPOTIFY_V2: +column_types: ROW_ID: NUMBER(38,0) USER_ID: VARCHAR(16777216) CACHED: VARCHAR(16777216) DOWNLOAD_DATE: DATE TMSTAMP: TIMESTAMP_NTZ(3) SOURCE_URI: VARCHAR(16777216) TRACK_ID: VARCHAR(16777216) SOURCE: VARCHAR(16777216) LENGTH: NUMBER(32,0) VERSION: NUMBER(32,0) DEVICE_TYPE: VARCHAR(16777216) OFFLINE_TIMESTAMP: TIMESTAMP_NTZ(3) MESSAGE: VARCHAR(16777216) OS: VARCHAR(16777216) TRACK_ARTISTS: VARCHAR(16777216) TRACK_NAME: VARCHAR(16777216) TRACK_URI: VARCHAR(16777216) TRACK_ALBUM_ARTIST: VARCHAR(16777216) ISRC: VARCHAR(16777216) TRACK_MESSAGE: VARCHAR(16777216) ALBUM_NAME: VARCHAR(16777216) ALBUM_CODE: VARCHAR(16777216) UPC: NUMBER(38,0) PRODUCT: VARCHAR(16777216) USER_COUNTRY: VARCHAR(16777216) USER_REGION: VARCHAR(16777216) ZIPCODE: VARCHAR(16777216) USER_ACCESS: VARCHAR(16777216) GENDER: VARCHAR(16777216) PARTNER: VARCHAR(16777216) USER_MESSAGE: VARCHAR(16777216) REFERRAL: VARCHAR(16777216) USER_TYPE: VARCHAR(16777216) BIRTH_YEAR: NUMBER(32,0) SHUFFLE: VARCHAR(16777216) REPEAT_PLAY: VARCHAR(16777216) UTC_TIMESTAMP_OFFSET: VARCHAR(16777216) CONTENT_TYPE_FLAG: VARCHAR(16777216) COMPLETION_FLAG: VARCHAR(16777216) LICENSOR: VARCHAR(16777216) SOURCE_URI_LEGACY: VARCHAR(16777216) NEW_USER_ID: VARCHAR(16777216) AGE_GROUP: VARCHAR(16777216) DISCOVERY_FLAG: VARCHAR(16777216) STAGING_RAW_YOUTUBE_CLAIM: +column_types: ROW_ID: NUMBER(38,0) INGESTION_TIME: TIMESTAMP_NTZ(3) DOWNLOAD_DATE: DATE FILENAME: VARCHAR(2000) FILESIZE: NUMBER(38,0) VIDEO_ID: VARCHAR(255) CLAIM_ID: VARCHAR(255) ASSET_ID: VARCHAR(255) UPLOADER: VARCHAR(2000) VIDEO_TITLE: VARCHAR(5000) VIEWS: NUMBER(32,0) CLAIM_STATUS: VARCHAR(255) CLAIM_ORIGIN: VARCHAR(255) CLAIM_TYPE: VARCHAR(255) IS_PARTNER_UPLOADED: VARCHAR(255) IS_PREMIUM: VARCHAR(255) REFERENCE_VIDEO_ID: VARCHAR(255) APPLIED_POLICY: VARCHAR(2000) CLAIM_CREATED_DATE: DATE VIDEO_UPLOAD_DATE: DATE CUSTOM_ID: VARCHAR(255) ISRC: VARCHAR(255) GRID: VARCHAR(255) ARTIST: VARCHAR(2000) ASSET_TITLE: VARCHAR(5000) ALBUM: VARCHAR(255) RECORD_LABEL: VARCHAR(255) UPC: NUMBER(38,0) DISPLAY_UPC: VARCHAR(255) NOTES: VARCHAR(5000) RELEASE_DATE: VARCHAR(11) ISWC: VARCHAR(255) WRITERS: VARCHAR(5000) IS_IN_VIDEO_REPORT: VARCHAR(1) IS_ART_TRACK: VARCHAR(1) ASSET_LABELS: VARCHAR(16777216) CHANNEL_ID: VARCHAR(255) CHANNEL_DISPLAY_NAME: VARCHAR(16777216) CLAIM_STATUS_DETAIL: VARCHAR(255) MATCHING_DURATION: NUMBER(32,0) LONGEST_MATCH: NUMBER(32,0) CONTENT_TYPE: VARCHAR(255) REFERENCE_ID: VARCHAR(65535) CLAIM_POLICY_ID: VARCHAR(255) ASSET_POLICY_ID: VARCHAR(255) CLAIM_POLICY_MONETIZE: VARCHAR(5000) CLAIM_POLICY_TRACK: VARCHAR(5000) CLAIM_POLICY_BLOCK: VARCHAR(5000) ASSET_POLICY_MONETIZE: VARCHAR(5000) ASSET_POLICY_TRACK: VARCHAR(5000) ASSET_POLICY_BLOCK: VARCHAR(5000) VIDEO_DURATION_SEC: NUMBER(32,0) TMS: VARCHAR(255) DIRECTOR: VARCHAR(5000) STUDIO: VARCHAR(500) SEASON: NUMBER(32,0) EPISODE_NUMBER: NUMBER(32,0) EPISODE_TITLE: VARCHAR(5000) HFA_SONG_CODE: VARCHAR(255) STAGING_RAW_YOUTUBE_VIDEO_REPORT: +column_types: VIDEO_ID: VARCHAR(16777216) CHANNEL_ID: VARCHAR(16777216) CHANNEL_DISPLAY_NAME: VARCHAR(16777216) TIME_UPLOADED: TIMESTAMP_NTZ(9) TIME_PUBLISHED: TIMESTAMP_NTZ(9) VIDEO_TITLE: VARCHAR(16777216) VIDEO_LENGTH: NUMBER(38,0) VIEWS: NUMBER(38,0) COMMENTS: NUMBER(38,0) VIDEO_PRIVACY_STATUS: VARCHAR(16777216) VIDEO_URL: VARCHAR(16777216) CATEGORY: VARCHAR(16777216) EMBEDDING_ALLOWED: VARCHAR(16777216) RATINGS_ALLOWED: VARCHAR(16777216) COMMENTS_ALLOWED: VARCHAR(16777216) CLAIM_ORIGIN: VARCHAR(16777216) CONTENT_TYPE: VARCHAR(16777216) UPLOAD_SOURCE: VARCHAR(16777216) CLAIMED_BY_THIS_OWNER: VARCHAR(16777216) CLAIMED_BY_ANOTHER_OWNER: VARCHAR(16777216) OTHER_OWNERS_CLAIMING: VARCHAR(16777216) OFFWEB_SYNDICATABLE: VARCHAR(16777216) CLAIM_ID: VARCHAR(16777216) ASSET_ID: VARCHAR(16777216) CUSTOM_ID: VARCHAR(16777216) EFFECTIVE_POLICY: VARCHAR(16777216) THIRD_PARTY_VIDEO_ID: VARCHAR(16777216) IN_VIDEO_ADS_ENABLED: VARCHAR(16777216) THIRD_PARTY_ADS_ENABLED: VARCHAR(16777216) DISPLAY_ADS_ENABLED: VARCHAR(16777216) SPONSORED_CARDS_ENABLED: VARCHAR(16777216) OVERLAY_ADS_ENABLED: VARCHAR(16777216) NONSKIPPABLE_VIDEO_ADS_ENABLED: VARCHAR(16777216) LONG_NONSKIPPABLE_VIDEO_ADS_ENABLED: VARCHAR(16777216) SKIPPABLE_VIDEO_ADS_ENABLED: VARCHAR(16777216) PREROLLS_ENABLED: VARCHAR(16777216) MIDROLLS_ENABLED: VARCHAR(16777216) POSTROLLS_ENABLED: VARCHAR(16777216) ISRC: VARCHAR(16777216) EIDR: VARCHAR(16777216) IS_MADE_FOR_KIDS_USER_SELECTION: VARCHAR(16777216) IS_MADE_FOR_KIDS_EFFECTIVE_SETTING: VARCHAR(16777216) IS_MADE_FOR_KIDS_MODIFIABLE: VARCHAR(16777216) INGESTION_TIME: TIMESTAMP_NTZ(9) FILENAME: VARCHAR(16777216) FILESIZE: NUMBER(38,0) DOWNLOAD_DATE: DATE LICENSOR: VARCHAR(16777216) ORCHTBLSPOTIFYPLAYLISTTRACKLISTHISTORY: +column_types: SNAPSHOT_TIMESTAMP: TIMESTAMP_NTZ(9) ADDED: TIMESTAMP_NTZ(9) EARLIESTADDED: TIMESTAMP_NTZ(9) PLAYLISTID: VARCHAR(16777216) PLAYLISTINDEX: NUMBER(38,0) FETCH_TIMESTAMP: TIMESTAMP_NTZ(9) TRACKID: VARCHAR(16777216) REL_PLAYLISTINDEX: NUMBER(38,0) VIEWS_BY_CHANNEL_COUNTRY_FEED_DISTRIBUTOR_DAILY_MOCK: +column_types: CHANNEL_ID: VARCHAR(16777216) COUNTRY_CODE: VARCHAR(2) FEED_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(16777216) DOWNLOAD_ACTIVITY_DATE: DATE VIEWS: NUMBER(38,0) PREMIUM_VIEWS: NUMBER(38,0) AVERAGE_VIEW_DURATION_SECONDS: NUMBER(38,12) AVERAGE_VIEW_DURATION_PERCENTAGE: NUMBER(38,12) WATCH_TIME_MINUTES: NUMBER(38,5) PREMIUM_WATCH_TIME_MINUTES: NUMBER(38,5) IMPRESSIONS_CTR: VARCHAR(16777216) ESTIMATED_PARTNER_AD_REVENUE: NUMBER(38,5) ESTIMATED_PARTNER_PREMIUM_REVENUE: NUMBER(38,5) ESTIMATED_MONETIZED_PLAYBACKS: NUMBER(38,0) AD_IMPRESSIONS: NUMBER(38,0) ESTIMATED_YOUTUBE_AD_REVENUE: NUMBER(38,5) CPM: NUMBER(38,5) COMMENTS: NUMBER(38,0) COUNT: VARCHAR(16777216) VIEWS_BY_CHANNEL_COUNTRY_FEED_DISTRIBUTOR_ROLLUP_MOCK: +column_types: CHANNEL_ID: VARCHAR(16777216) COUNTRY_CODE: VARCHAR(2) FEED_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(16777216) VIEWS: NUMBER(38,0) PREMIUM_VIEWS: NUMBER(38,0) AVERAGE_VIEW_DURATION_SECONDS: NUMBER(38,12) AVERAGE_VIEW_DURATION_PERCENTAGE: NUMBER(38,12) WATCH_TIME_MINUTES: NUMBER(38,5) PREMIUM_WATCH_TIME_MINUTES: NUMBER(38,5) IMPRESSIONS_CTR: VARCHAR(16777216) ESTIMATED_PARTNER_AD_REVENUE: NUMBER(38,5) ESTIMATED_PARTNER_PREMIUM_REVENUE: NUMBER(38,5) ESTIMATED_MONETIZED_PLAYBACKS: NUMBER(38,0) AD_IMPRESSIONS: NUMBER(38,0) ESTIMATED_YOUTUBE_AD_REVENUE: NUMBER(38,5) CPM: NUMBER(38,5) COUNT: VARCHAR(16777216) VIEWS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_DAILY_MOCK: +column_types: VIDEO_ID: VARCHAR(16777216) COUNTRY_CODE: VARCHAR(2) FEED_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(16777216) DOWNLOAD_ACTIVITY_DATE: DATE CONTENT_TYPE: VARCHAR(16777216) STORE_ID: NUMBER(38,0) CHANNEL_ID: VARCHAR(16777216) VIEWS: NUMBER(38,0) PREMIUM_VIEWS: NUMBER(38,0) AVERAGE_VIEW_DURATION_SECONDS: NUMBER(38,11) AVERAGE_VIEW_DURATION_PERCENTAGE: NUMBER(38,11) WATCH_TIME_MINUTES: NUMBER(38,5) PREMIUM_WATCH_TIME_MINUTES: NUMBER(38,5) IMPRESSIONS_CTR: VARCHAR(16777216) ESTIMATED_PARTNER_AD_REVENUE: NUMBER(38,5) ESTIMATED_PARTNER_PREMIUM_REVENUE: NUMBER(38,5) ESTIMATED_MONETIZED_PLAYBACKS: NUMBER(38,0) AD_IMPRESSIONS: NUMBER(38,0) ESTIMATED_YOUTUBE_AD_REVENUE: NUMBER(38,5) CPM: NUMBER(38,5) COMMENTS: NUMBER(38,0) COUNT: VARCHAR(16777216) VIEWS_BY_VIDEO_FEED_DISTRIBUTOR_DAILY_MOCK: +column_types: VIDEO_ID: VARCHAR(16777216) FEED_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(16777216) DOWNLOAD_ACTIVITY_DATE: DATE CONTENT_TYPE: VARCHAR(16777216) STORE_ID: NUMBER(38,0) CHANNEL_ID: VARCHAR(16777216) VIEWS: NUMBER(38,0) PREMIUM_VIEWS: NUMBER(38,0) AVERAGE_VIEW_DURATION_SECONDS: NUMBER(38,11) AVERAGE_VIEW_DURATION_PERCENTAGE: NUMBER(38,11) WATCH_TIME_MINUTES: NUMBER(38,5) PREMIUM_WATCH_TIME_MINUTES: NUMBER(38,5) IMPRESSIONS_CTR: VARCHAR(16777216) ESTIMATED_PARTNER_AD_REVENUE: NUMBER(38,5) ESTIMATED_PARTNER_PREMIUM_REVENUE: NUMBER(38,5) ESTIMATED_MONETIZED_PLAYBACKS: NUMBER(38,0) AD_IMPRESSIONS: NUMBER(38,0) ESTIMATED_YOUTUBE_AD_REVENUE: NUMBER(38,5) CPM: NUMBER(38,5) COMMENTS: NUMBER(38,0) COUNT: VARCHAR(16777216) EXPECTED_METRICS_BY_CHANNEL_COUNTRY_FEED_DISTRIBUTOR_ROLLUP: +column_types: CHANNEL_ID: VARCHAR(16777216) COUNTRY_CODE: VARCHAR(2) FEED_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(16777216) CHANNEL_OWNER: VARCHAR(16777216) IS_IN_MCN: BOOLEAN SUBSCRIBER_COUNT: NUMBER(38,0) TOTAL_VIEWS: NUMBER(38,0) TOTAL_ESTIMATED_GROSS_REVENUE: NUMBER(38,5) AVERAGE_VIEW_DURATION_SECONDS: NUMBER(38,12) VIEWS_1_MONTH_BACK: NUMBER(38,0) VIEWS_2_MONTHS_BACK: NUMBER(38,0) VIEWS_3_MONTHS_BACK: NUMBER(38,0) VIEWS_4_MONTHS_BACK: NUMBER(38,0) EXPECTED_METRICS_BY_VIDEO_COUNTRY_FEED_DISTRIBUTOR_ROLLUP: +column_types: VIDEO_ID: VARCHAR(16777216) COUNTRY_CODE: VARCHAR(2) FEED_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(16777216) CHANNEL_ID: VARCHAR(16777216) VIDEO_CONTENT_TYPE: VARCHAR(16777216) CHANNEL_OWNER: VARCHAR(16777216) IS_IN_MCN: BOOLEAN SUBSCRIBER_COUNT: NUMBER(38,0) TOTAL_VIEWS: NUMBER(38,0) TOTAL_ESTIMATED_GROSS_REVENUE: NUMBER(38,5) AVERAGE_VIEW_DURATION_SECONDS: NUMBER(38,12) VIEWS_1_MONTH_BACK: NUMBER(38,0) VIEWS_2_MONTHS_BACK: NUMBER(38,0) VIEWS_3_MONTHS_BACK: NUMBER(38,0) VIEWS_4_MONTHS_BACK: NUMBER(38,0) EXPECTED_METRICS_BY_VIDEO_FEED_DISTRIBUTOR_ROLLUP: +column_types: VIDEO_ID: VARCHAR(16777216) FEED_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(16777216) CHANNEL_ID: VARCHAR(16777216) VIDEO_CONTENT_TYPE: VARCHAR(16777216) CHANNEL_OWNER: VARCHAR(16777216) IS_IN_MCN: BOOLEAN SUBSCRIBER_COUNT: NUMBER(38,0) TOTAL_VIEWS: NUMBER(38,0) TOTAL_ESTIMATED_GROSS_REVENUE: NUMBER(38,5) AVERAGE_VIEW_DURATION_SECONDS: NUMBER(38,12) VIEWS_1_MONTH_BACK: NUMBER(38,0) VIEWS_2_MONTHS_BACK: NUMBER(38,0) VIEWS_3_MONTHS_BACK: NUMBER(38,0) VIEWS_4_MONTHS_BACK: NUMBER(38,0) # Empty in test scenario — types must be specified so dbt seed does # not infer everything as NUMBER and break MINUS against the model's # ARRAY/TIMESTAMP columns. EXPECTED_METRICS_BY_TRACK_COUNTRY_CREATIONS_THRESHOLD_ROLLUP_PRODUCT_TRANSFER: +column_types: ISRC: VARCHAR(16777216) COUNTRY_CODE: VARCHAR(2) LABEL_IDS: ARRAY MIN_RELEASE_DATE: TIMESTAMP_NTZ(9) SALE_START_DATE: TIMESTAMP_NTZ(9) DELETIONS_FOR_ISRC: VARCHAR(16777216) NOT_FOR_DISTRIBUTION: VARCHAR(16777216) EXPECTED_METRICS_BY_TRACK_CREATIONS_THRESHOLD_ROLLUP_PRODUCT_TRANSFER: +column_types: ISRC: VARCHAR(16777216) LABEL_IDS: ARRAY MIN_RELEASE_DATE: TIMESTAMP_NTZ(9) SALE_START_DATE: TIMESTAMP_NTZ(9) DELETIONS_FOR_ISRC: VARCHAR(16777216) NOT_FOR_DISTRIBUTION: VARCHAR(16777216) EXPECTED_PLACEMENTS_POSITIONS_BY_PLAYLIST_ISRC_TIMESTAMP_HOURLY: +column_types: STOREFRONT: VARCHAR(16777216) EXPECTED_PLACEMENTS_BY_PLAYLIST_ISRC_PARTICIPANT_ROLLUP: +column_types: GLOBAL_PARTICIPANT_ID: VARCHAR(16777216) GLOBAL_PLAYLIST_ID: VARCHAR(40) ISRC: VARCHAR(200) CURRENT_POSITION: NUMBER(38,0) PREVIOUS_POSITION: NUMBER(38,0) PEAK_POSITION: NUMBER(38,0) STORE_ID: NUMBER(3,0) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) LAST_UPDATED_ON: TIMESTAMP_LTZ(9) LAST_ADDED_ON_DATE: TIMESTAMP_LTZ(9) REMOVED_ON: TIMESTAMP_LTZ(9) STAT_ID: VARCHAR(40) PLACEMENTS_BY_PLAYLIST_ISRC_PARTICIPANT_ROLLUP: +column_types: GLOBAL_PARTICIPANT_ID: VARCHAR(16777216) GLOBAL_PLAYLIST_ID: VARCHAR(40) ISRC: VARCHAR(200) CURRENT_POSITION: NUMBER(38,0) PREVIOUS_POSITION: NUMBER(38,0) PEAK_POSITION: NUMBER(38,0) STORE_ID: NUMBER(3,0) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) LAST_UPDATED_ON: TIMESTAMP_LTZ(9) LAST_ADDED_ON_DATE: TIMESTAMP_LTZ(9) REMOVED_ON: TIMESTAMP_LTZ(9) STAT_ID: VARCHAR(40) GLOBAL_SOUND_RECORDING: +column_types: NAME: VARCHAR(16777216) ID: VARCHAR(16777216) IMAGE_URL: VARCHAR(16777216) IMPRINT: VARCHAR(16777216) ISRC: VARCHAR(16777216) MONTHLY_LISTENERS: NUMBER(38, 0) POPULARITY: NUMBER(38, 0) SPOTIFY_POPULARITY: NUMBER(38, 0) RELEASE_DATE: VARCHAR(16777216) TYPES: VARCHAR(16777216) EXPECTED_PLACEMENTS_PLAYLIST_METADATA: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(18,5) STOREFRONT: VARCHAR(16777216) GLOBAL_PLAYLIST_ID: VARCHAR(16777216) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) PLAYLIST_CREATED_AT: TIMESTAMP_NTZ(9) PLAYLIST_MODIFIED_AT: TIMESTAMP_NTZ(9) PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) EXPECTED_PLACEMENTS_BY_TRACK_PLAYLIST_COUNTRY_ROLLUP: +column_types: TRACK_ID: NUMBER(38,0) PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) STORE_ID: NUMBER(3,0) FEED_ID: NUMBER(1,0) PRODUCT_ID: NUMBER(32,0) COUNTRY: VARCHAR(16777216) ISRC: VARCHAR(200) LABEL_ID: NUMBER(32,0) SUBACCOUNT_ID: NUMBER(32,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) ARTWORK_URL: VARCHAR(16777216) ADDED: TIMESTAMP_LTZ(9) TRACK_COUNT: NUMBER(38,0) FOLLOWERS: NUMBER(38,0) POSITION: VARIANT PREVIOUS_POSITION: VARIANT USER: VARCHAR(16777216) USER_DISPLAY_NAME: VARCHAR(16777216) STREAMS_7_DAYS: NUMBER(38,0) OWNER_CATEGORY: VARCHAR(14) EXPECTED_RECENT_PLACEMENTS_BY_TRACK_PLAYLIST_COUNTRY_FEED_ROLLUP: +column_types: TRACK_ID: NUMBER(38,0) PLAYLIST_ID: VARCHAR(16777216) COUNTRY: NUMBER(38,0) FEED_ID: NUMBER(38,0) LABEL_ID: NUMBER(38,0) SUBACCOUNT_ID: NUMBER(38,0) STORE_ID: NUMBER(38,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) ISRC: VARCHAR(16777216) PRODUCT_ID: NUMBER(38,0) USER_DISPLAY_NAME: NUMBER(38,5) OWNER_CATEGORY: VARCHAR(16777216) STOREFRONT: NUMBER(38,0) ADDED: VARCHAR(16777216) ARTWORK_URL: VARCHAR(16777216) FOLLOWERS: NUMBER(38,0) STOREFRONTS: ARRAY TRACK_COUNT: NUMBER(38,0) POSITION: NUMBER(38,0) PREVIOUS_POSITION: NUMBER(38,0) TOTAL_STREAMS: NUMBER(38,0) COUNT: NUMBER(18,0) CM_TAG: +column_types: ID: NUMBER(38,0) NAME: VARCHAR(16777216) SOURCE: VARCHAR(16777216) TYPE: VARCHAR(16777216) URL: VARCHAR(16777216) CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) WEIGHT: NUMBER(38,0) PLAYLIST_CURATOR_MAPPINGS: +column_types: STORE_ID: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_MAPPINGS: +column_types: STORE_ID: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) L_AMAZON_PLAYLIST: +column_types: ID: NUMBER(38,0) AMAZON: VARCHAR(16777216) AMAZON_PLAYLIST: VARCHAR(16777216) POSITION: NUMBER(38,0) START_SYS_PERIOD: TIMESTAMP_NTZ(9) END_SYS_PERIOD: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) AMAZON_PLAYLIST: +column_types: ID: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) ARTWORK_URL: VARCHAR(16777216) NAME: VARCHAR(16777216) DESCRIPTION: VARCHAR(16777216) LAST_UPDATED: TIMESTAMP_NTZ(9) RANK: NUMBER(38,0) CODE2: VARCHAR(2) CREATED_AT: TIMESTAMP_NTZ(9) ORIGINAL: BOOLEAN MODIFIED_AT: TIMESTAMP_NTZ(9) WITH_STOREFRONTS: BOOLEAN AMAZON: +column_types: ID: VARCHAR(16777216) NAME: VARCHAR(16777216) ISRC: VARCHAR(16777216) GENRE: VARCHAR(16777216) AMAZON_ARTIST: VARCHAR(16777216) AMAZON_ALBUM: VARCHAR(16777216) DURATION: NUMBER(38,0) CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) ORIGINAL: BOOLEAN ORIGINAL_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(2) L_DEEZER_PLAYLIST_TAG: +column_types: ID: NUMBER(38,0) CM_TAG: NUMBER(38,0) DEEZER_PLAYLIST: NUMBER(38,0) CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) DEEZER_PLAYLIST: +column_types: ID: NUMBER(38,0) NAME: VARCHAR(16777216) DESCRIPTION: VARCHAR(16777216) ARTWORK_URL: VARCHAR(16777216) DEEZER_USER: NUMBER(38,0) LAST_UPDATED: DATE CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) DEEZER_PLAYLIST_STAT: +column_types: ID: NUMBER(38,0) DEEZER_PLAYLIST: NUMBER(38,0) FANS: NUMBER(38,0) TIMESTP: DATE CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) L_DEEZER_PLAYLIST: +column_types: ID: NUMBER(38,0) DEEZER: NUMBER(38,0) DEEZER_PLAYLIST: NUMBER(38,0) POSITION: NUMBER(38,0) START_SYS_PERIOD: TIMESTAMP_NTZ(9) END_SYS_PERIOD: TIMESTAMP_NTZ(9) CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) DEEZER_USER: +column_types: ID: NUMBER(38,0) NAME: VARCHAR(16777216) ARTWORK_URL: VARCHAR(16777216) COUNTRY: VARCHAR(2) OFFICIAL: BOOLEAN CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) L_ITUNES_PLAYLIST_TAG: +column_types: ID: NUMBER(38,0) CM_TAG: NUMBER(38,0) ITUNES_PLAYLIST: NUMBER(38,0) STOREFRONT: VARCHAR(2) CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) ITUNES_PLAYLIST: +column_types: ID: NUMBER(38,0) PLAYLIST_URL: VARCHAR(16777216) NAME: VARCHAR(16777216) ARTWORK_URL: VARCHAR(16777216) DESCRIPTION: VARCHAR(16777216) OWNER_NAME: VARCHAR(16777216) NUM_TRACK_LATEST: NUMBER(38,0) LAST_UPDATED: TIMESTAMP_NTZ(9) PLAYLIST_ID: VARCHAR(16777216) ITUNES_PLAYLIST_OWNER: NUMBER(38,0) CURATOR_ID: NUMBER(38,0) WITH_STOREFRONTS: BOOLEAN CREATED_AT: TIMESTAMP_NTZ(9) LAST_MODIFIED: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) ITUNES_PLAYLIST_STOREFRONT: +column_types: ID: NUMBER(38,0) ITUNES_PLAYLIST: NUMBER(38,0) STOREFRONT: VARCHAR(2) LAST_UPDATED: DATE REAL_UPDATED: DATE ACTIVE: BOOLEAN ITUNES_PLAYLIST_OWNER: +column_types: ID: NUMBER(38,0) CURATOR_ID: NUMBER(38,0) NAME: VARCHAR(16777216) ARTWORK_URL: VARCHAR(16777216) DESCRIPTION: VARCHAR(16777216) CURATOR_URL: VARCHAR(16777216) OFFICIAL: BOOLEAN CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) CODE2: VARCHAR(16777216) L_SPOTIFY_PLAYLIST_TAG: +column_types: ID: NUMBER(38,0) CM_TAG: NUMBER(38,0) SPOTIFY_PLAYLIST: NUMBER(38,0) CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) SPOTIFY_PLAYLIST: +column_types: ID: NUMBER(38,0) PLAYLIST_ID: VARCHAR(16777216) CATEGORY_ID: VARCHAR(16777216) USER_ID: VARCHAR(16777216) NAME: VARCHAR(16777216) URL: VARCHAR(2048) DESCRIPTION: VARCHAR(16777216) OWNER_NAME: VARCHAR(16777216) SPOTIFY_PLAYLIST_OWNER: NUMBER(38,0) FOLLOWERS_LATEST: NUMBER(38,0) NUM_TRACK_LATEST: NUMBER(38,0) LAST_UPDATED: TIMESTAMP_NTZ(9) CODE2: VARCHAR(2) PLAYLIST_UPDATED: TIMESTAMP_NTZ(9) PERSONALIZED: BOOLEAN PUBLIC: BOOLEAN COLLABORATIVE: BOOLEAN CREATED_AT: TIMESTAMP_NTZ(9) RADIO: BOOLEAN MODIFIED_AT: TIMESTAMP_NTZ(9) ACTIVE: BOOLEAN PLAYLIST_CURATOR_OWNER_OVERRIDES: +column_types: CURATOR_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) OWNER: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) SPOTIFY_PLAYLIST_OWNER: +column_types: ID: NUMBER(38,0) USER_ID: VARCHAR(16777216) NAME: VARCHAR(16777216) URL: VARCHAR(16777216) GENRES: VARCHAR(16777216) OFFICIAL: BOOLEAN CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) VERIFIED: BOOLEAN SPOTIFY_PLAYLIST_STAT: +column_types: ID: NUMBER(38,0) FOLLOWERS: NUMBER(38,0) NUM_TRACK: NUMBER(38,0) SPOTIFY_PLAYLIST: NUMBER(38,0) TIMESTP: DATE LISTENERS: NUMBER(38,0) CREATED_AT: TIMESTAMP_NTZ MODIFIED_AT: TIMESTAMP_NTZ YOUTUBE_PLAYLIST_STAT: +column_types: YOUTUBE_PLAYLIST: VARCHAR(16777216) VIEWS: NUMBER(38,0) NUM_VIDEOS: NUMBER(38,0) TIMESTP: DATE ID: NUMBER(38,0) CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) YOUTUBE_PLAYLIST: +column_types: ID: VARCHAR(16777216) NAME: VARCHAR(16777216) ARTWORK_URL: VARCHAR(16777216) CHANNEL_ID: VARCHAR(16777216) LAST_UPDATED: TIMESTAMP_NTZ(9) DESCRIPTION: VARCHAR(16777216) YOUTUBE_UPDATED: DATE CREATED_AT: TIMESTAMP_NTZ(9) MODIFIED_AT: TIMESTAMP_NTZ(9) EXPECTED_PLAYLISTS_STATE: +column_types: TABLE_NAME: VARCHAR(16777216) PREV_MODIFIED_AT: TIMESTAMP_NTZ(9) NEXT_MODIFIED_AT: TIMESTAMP_NTZ(9) PRIMARY_PLAYLIST_TYPE_BY_PLAYLIST: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) MAPPING_ISRC_TO_GLOBAL_PARTICIPANT_DBT_MOCK: +column_types: isrc: VARCHAR(16777216) global_participant_id: VARCHAR(16777216) PRODUCT_OWNERSHIP_ACCESS_MOCK: +column_types: PRODUCT_ID: NUMBER(38,0) LABEL_ID: NUMBER(32,0) SUBACCOUNT_ID: NUMBER(32,0) ACCESS_UNTIL_DATE: DATE IS_CURRENT: BOOLEAN PLAYLISTS_PRIORITY_PLACEMENTS_BY_PLAYLIST_PUBLIC: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) STOREFRONT: VARCHAR(16777216) CURRENT_POSITION: NUMBER(38,0) PREVIOUS_POSITION: NUMBER(38,0) PREVIOUS_POSITION_DATE: TIMESTAMP_NTZ(9) PEAK_POSITION: NUMBER(38,0) POSITION_CHANGE: NUMBER(38,0) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: TIMESTAMP_NTZ(9) STOREFRONT_COUNT: NUMBER(18,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) PLAYLISTS_PRIORITY_BY_PLAYLIST_CURRENT_TRACKLIST: +column_types: ISRC: VARCHAR(16777216) STORE_ID: NUMBER(38,0) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) CURRENT_POSITION: NUMBER(38,0) PEAK_POSITION: NUMBER(38,0) PREVIOUS_POSITION: NUMBER(38,0) POSITION_CHANGE: NUMBER(38,0) PREVIOUS_POSITION_DATE: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) FIRST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: TIMESTAMP_NTZ(9) DAYS_ON_PLAYLIST: NUMBER(10,0) STOREFRONT_COUNT: NUMBER(18,0) STREAMS_COUNTRY: VARCHAR(16777216) FIRST_PLAY: DATE STREAMS_ALL_TIME: NUMBER(38,0) STREAMS_LAST_365_DAYS: NUMBER(38,0) STREAMS_LAST_183_DAYS: NUMBER(38,0) STREAMS_LAST_28_DAYS: NUMBER(38,0) STREAMS_LAST_7_DAYS: NUMBER(38,0) STREAMS_LAST_1_DAY: NUMBER(38,0) COMPLETIONS_STREAMS_ALL_TIME: NUMBER(38,0) COMPLETIONS_COMPLETIONS_ALL_TIME: NUMBER(38,0) COMPLETIONS_STREAMS_LAST_365_DAYS: NUMBER(38,0) COMPLETIONS_COMPLETIONS_LAST_365_DAYS: NUMBER(38,0) COMPLETIONS_STREAMS_LAST_183_DAYS: NUMBER(38,0) COMPLETIONS_COMPLETIONS_LAST_183_DAYS: NUMBER(38,0) COMPLETIONS_STREAMS_LAST_28_DAYS: NUMBER(38,0) COMPLETIONS_COMPLETIONS_LAST_28_DAYS: NUMBER(38,0) COMPLETIONS_STREAMS_LAST_7_DAYS: NUMBER(38,0) COMPLETIONS_COMPLETIONS_LAST_7_DAYS: NUMBER(38,0) COMPLETIONS_STREAMS_LAST_1_DAY: NUMBER(38,5) COMPLETIONS_COMPLETIONS_LAST_1_DAY: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) GSR_ID: VARCHAR(16777216) CHARTMETRIC_TRACK_NAME: VARCHAR(16777216) CHARTMETRIC_ARTIST_NAME: VARCHAR(16777216) CHARTMETRIC_ARTWORK_URL: VARCHAR(16777216) INFERRED_COMPILATION: BOOLEAN LABEL_IDS: ARRAY SUBACCOUNT_IDS: ARRAY LABEL_PARTICIPANT_IDS: ARRAY PLAYLISTS_PRIORITY_PLACEMENTS_BY_PARTICIPANT_ISRC_PLAYLIST_PUBLIC: +column_types: GLOBAL_PARTICIPANT_ID: VARCHAR(16777216) ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) STOREFRONT: VARCHAR(16777216) CURRENT_POSITION: NUMBER(38,0) PREVIOUS_POSITION: NUMBER(38,0) PREVIOUS_POSITION_DATE: TIMESTAMP_NTZ(9) PEAK_POSITION: NUMBER(38,0) POSITION_CHANGE: NUMBER(38,0) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: TIMESTAMP_NTZ(9) STOREFRONT_COUNT: NUMBER(18,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) PLAYLISTS_PRIORITY_PLACEMENTS_BY_ISRC_PLAYLIST_PUBLIC: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) STOREFRONT: VARCHAR(16777216) CURRENT_POSITION: NUMBER(38,0) PREVIOUS_POSITION: NUMBER(38,0) PREVIOUS_POSITION_DATE: TIMESTAMP_NTZ(9) PEAK_POSITION: NUMBER(38,0) POSITION_CHANGE: NUMBER(38,0) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: TIMESTAMP_NTZ(9) STOREFRONT_COUNT: NUMBER(18,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) PLAYLISTS_PRIORITY_PLACEMENTS_BY_PARTICIPANT_ISRC_PLAYLIST_PUBLIC_ROLLUP:PLAYLISTS_PRIORITY_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_PUBLIC: +column_types: TRACK_ID: NUMBER(38,0) STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(10) LABEL_ID: NUMBER(32,0) SUBACCOUNT_ID: NUMBER(32,0) LABEL_PARTICIPANT_IDS: ARRAY LABEL_PARTICIPANT_UUIDS: ARRAY ISRC: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) STOREFRONT_COUNT: NUMBER(18,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) PLAYLISTS_PRIORITY_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_PUBLIC: +column_types: TRACK_ID: NUMBER(38,0) STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(10) LABEL_ID: NUMBER(32,0) SUBACCOUNT_ID: NUMBER(32,0) LABEL_PARTICIPANT_IDS: ARRAY LABEL_PARTICIPANT_UUIDS: ARRAY ISRC: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) STOREFRONT_COUNT: NUMBER(18,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) PLAYLISTS_PRIORITY_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_PUBLIC_ONLY_FRESHEST: +column_types: TRACK_ID: NUMBER(38,0) STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(10) LABEL_ID: NUMBER(32,0) SUBACCOUNT_ID: NUMBER(32,0) LABEL_PARTICIPANT_IDS: ARRAY LABEL_PARTICIPANT_UUIDS: ARRAY ISRC: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) STOREFRONT_COUNT: NUMBER(18,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) RECENT_PLAYLISTS_PRIORITY_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR: +column_types: TRACK_ID: NUMBER(38,0) STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(10) LABEL_ID: NUMBER(32,0) SUBACCOUNT_ID: NUMBER(32,0) LABEL_PARTICIPANT_IDS: ARRAY LABEL_PARTICIPANT_UUIDS: ARRAY ISRC: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) STREAMS_LAST_7_DAYS: NUMBER(38,0) STREAMS_LAST_1_DAY: NUMBER(38,0) RECENT_PLAYLISTS_PRIORITY_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_ONLY_FRESHEST: +column_types: TRACK_ID: NUMBER(38,0) STORE_PLAYLIST_ID: VARCHAR(16777216) STORE_ID: NUMBER(38,0) DISTRIBUTOR: VARCHAR(10) LABEL_ID: NUMBER(32,0) SUBACCOUNT_ID: NUMBER(32,0) LABEL_PARTICIPANT_IDS: ARRAY LABEL_PARTICIPANT_UUIDS: ARRAY ISRC: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_GENRES: ARRAY PLAYLIST_TRACK_COUNT: NUMBER(38,0) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) STREAMS_LAST_7_DAYS: NUMBER(38,0) STREAMS_LAST_1_DAY: NUMBER(38,0) EXPECTED_V_PLAYLISTS_BY_PLAYLIST: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_HISTORICAL_PLAYLIST_TRACKLISTS_AGGREGATED: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) SNAPSHOT_DATE: DATE ISRC: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) PLAYLIST_NAME: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: TIMESTAMP_NTZ(9) FIRST_PLAY: DATE GSR_ID: VARCHAR(16777216) CHARTMETRIC_TRACK_NAME: VARCHAR(16777216) CHARTMETRIC_ARTIST_NAME: VARCHAR(16777216) CHARTMETRIC_ARTWORK_URL: VARCHAR(16777216) CREATED_AT: TIMESTAMP_NTZ(9) EXPECTED_V_HISTORICAL_PLAYLIST_TRACKLISTS_BY_MARKET: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) SNAPSHOT_DATE: DATE ISRC: VARCHAR(16777216) STREAMING_MARKET: VARCHAR(16777216) PLAYLIST_NAME: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: DATE FIRST_PLAY: DATE GSR_ID: VARCHAR(16777216) CHARTMETRIC_TRACK_NAME: VARCHAR(16777216) CHARTMETRIC_ARTIST_NAME: VARCHAR(16777216) CHARTMETRIC_ARTWORK_URL: VARCHAR(16777216) CREATED_AT: TIMESTAMP_LTZ(9) EXPECTED_V_PLAYLIST_TRACK_COMPANY_BRAND: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) ISRC: VARCHAR(16777216) FINALISED_COMPANY_BRAND: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_BY_PLAYLIST_CURRENT_TRACKLIST: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) PREVIOUS_POSITION_DATE: VARCHAR(16777216) STREAMS_COUNTRY: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) FIRST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: TIMESTAMP_NTZ(9) FIRST_PLAY: DATE PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) GSR_ID: VARCHAR(16777216) CHARTMETRIC_TRACK_NAME: VARCHAR(16777216) CHARTMETRIC_ARTIST_NAME: VARCHAR(16777216) CHARTMETRIC_ARTWORK_URL: VARCHAR(16777216) INFERRED_COMPILATION: BOOLEAN EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_PLAYLIST_PRIVATE: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) FIRST_PLAY: DATE PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_PLAYLIST_PUBLIC: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) PREVIOUS_POSITION_DATE: TIMESTAMP_NTZ(9) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: TIMESTAMP_NTZ(9) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_PLAYLIST_COUNTRY_PRIVATE: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) STREAMS_COUNTRY: VARCHAR(16777216) FIRST_PLAY: DATE PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_FOLLOWERS_BY_PLAYLIST_DATE_SPOTIFY: +column_types: store_playlist_id: VARCHAR(16777216) DATE: DATE MODIFIED_AT: TIMESTAMP_NTZ EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_ISRC_PLAYLIST_PUBLIC: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) PREVIOUS_POSITION_DATE: TIMESTAMP_NTZ(9) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: TIMESTAMP_NTZ(9) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_ISRC_PLAYLIST_PRIVATE: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) FIRST_PLAY: DATE PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_ISRC_PLAYLIST_PRIVATE_CLEAN: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) FIRST_PLAY: DATE PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_ISRC_PLAYLIST_COUNTRY_PRIVATE: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) STREAMS_COUNTRY: VARCHAR(16777216) FIRST_PLAY: DATE PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_PARTICIPANT_ISRC_PLAYLIST_PUBLIC: +column_types: GLOBAL_PARTICIPANT_ID: VARCHAR(16777216) ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) PREVIOUS_POSITION_DATE: TIMESTAMP_NTZ(9) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) REMOVED_ON: TIMESTAMP_NTZ(9) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_PARTICIPANT_ISRC_PLAYLIST_PRIVATE: +column_types: GLOBAL_PARTICIPANT_ID: VARCHAR(16777216) ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) FIRST_PLAY: DATE PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_PARTICIPANT_ISRC_PLAYLIST_PRIVATE_CLEAN: +column_types: GLOBAL_PARTICIPANT_ID: VARCHAR(16777216) ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) FIRST_PLAY: DATE PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_PARTICIPANT_ISRC_PLAYLIST_COUNTRY_PRIVATE: +column_types: GLOBAL_PARTICIPANT_ID: VARCHAR(16777216) ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) STREAMS_COUNTRY: VARCHAR(16777216) FIRST_PLAY: DATE PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_PUBLIC: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) ISRC: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_PLAYLISTS_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_PUBLIC_ONLY_FRESHEST: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) ISRC: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_RECENT_PLAYLISTS_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) ISRC: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_RECENT_PLAYLISTS_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_ONLY_FRESHEST: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) DISTRIBUTOR: VARCHAR(16777216) ISRC: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) LAST_ADDED_ON_DATE: TIMESTAMP_NTZ(9) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) EXPECTED_V_GSR_AND_CHARTMETRIC_METADATA: +column_types: GSR_ID: VARCHAR(16777216) CM_TRACK_ID: VARCHAR(16777216) ISRC: VARCHAR(16777216) CHARTMETRIC_TRACK_NAME: VARCHAR(16777216) CHARTMETRIC_ARTIST_NAME: VARCHAR(16777216) CHARTMETRIC_ARTWORK_URL: VARCHAR(16777216) PRIORITY_PLAYLIST_METADATA: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TRACK_COUNT: NUMBER(38,0) LAST_UPDATED: TIMESTAMP_NTZ(9) PLAYLIST_DESCRIPTION: VARCHAR(16777216) STORE_ID: NUMBER(38,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) PLAYLIST_GENRES: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) CREATED_AT: TIMESTAMP_NTZ(9) SMG_PERCENT: VARCHAR(16777216) FRONTLINE_PERCENT: VARCHAR(16777216) LOCAL_PERCENT: VARCHAR(16777216) OWNER: VARCHAR(16777216) EXPECTED_V_PLAYLIST_METADATA: +column_types: STORE_PLAYLIST_ID: VARCHAR(16777216) PLAYLIST_FOLLOWER_COUNT: NUMBER(38,0) PLAYLIST_ARTWORK_URL: VARCHAR(16777216) PLAYLIST_TRACK_COUNT: NUMBER(38,0) LAST_UPDATED: TIMESTAMP_NTZ(9) PLAYLIST_DESCRIPTION: VARCHAR(16777216) STORE_ID: NUMBER(38,0) PLAYLIST_NAME: VARCHAR(16777216) PLAYLIST_URI: VARCHAR(16777216) CURATOR_NAME: VARCHAR(16777216) CURATOR_ID: VARCHAR(16777216) CURATOR_COUNTRY: VARCHAR(16777216) PLAYLIST_TYPE: VARCHAR(16777216) PRIMARY_PLAYLIST_TYPE: VARCHAR(16777216) CREATED_AT: TIMESTAMP_NTZ(9) OWNER: VARCHAR(16777216) EXPECTED_V_DIM_EDITORIAL_PLAYLIST_TOP_NON_EDITORIAL_PLAYLIST: +column_types: PLAYLISTID: NUMBER(38,0) STOREPLAYLISTID: VARCHAR(16777216) PLAYLISTAUTHOR: VARCHAR(16777216) PLAYLISTNAME: VARCHAR(16777216) PLAYLISTURL: VARCHAR(16777216) STOREID: NUMBER(38,0) PLAYLISTURI: VARCHAR(16777216) PLAYLISTIMAGE: VARCHAR(16777216) PLAYLISTTYPEID: VARCHAR(16777216) PLAYLISTTYPENAME: VARCHAR(16777216) CREATEDDATETIME: TIMESTAMP_LTZ(9) UPDATEDDATETIME: TIMESTAMP_LTZ(9) FEEDID: NUMBER(38,0) PLAYLIST_RANK: NUMBER(18,0) NOTIFY: VARCHAR(1) EXPECTED_V_PLAYLISTS_PLACEMENT_EVENTS_BY_ISRC_PLAYLIST: +column_types: ISRC: VARCHAR(16777216) STORE_PLAYLIST_ID: VARCHAR(16777216) STOREFRONT: VARCHAR(16777216) TIMESTAMP: TIMESTAMP_NTZ(9) EVENT_TYPE: VARCHAR(16777216) EVENT_PRIORITY: VARCHAR(16777216)