version: 2

sources:
  - name: "{% if target.name == 'test' %}{{ env_var('SNOWFLAKE_SCHEMA') }}{% else %}{{ env_var('SOURCE_SNOWFLAKE_SCHEMA', env_var('SNOWFLAKE_SCHEMA')) }}{% endif %}"
    database: "{% if target.name == 'test' %}{{ env_var('SNOWFLAKE_DATABASE') }}{% else %}{{ env_var('SOURCE_SNOWFLAKE_DATABASE', env_var('SNOWFLAKE_DATABASE', '')) }}{% endif %}"
    tables:
      # Priority tables managed by Snowflake task graph (not dbt)
      - name: PLAYLISTS_PRIORITY_PLACEMENTS_BY_ISRC_PLAYLIST_PUBLIC
      - name: PLAYLISTS_PRIORITY_PLACEMENTS_BY_PARTICIPANT_ISRC_PLAYLIST_PUBLIC
      - name: PLAYLISTS_PRIORITY_PLACEMENTS_BY_PLAYLIST_PUBLIC
      - name: PLAYLISTS_PRIORITY_BY_PLAYLIST_CURRENT_TRACKLIST
      - name: PLAYLISTS_PRIORITY_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_PUBLIC
      - name: PLAYLISTS_PRIORITY_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_PUBLIC_ONLY_FRESHEST
      - name: RECENT_PLAYLISTS_PRIORITY_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR
      - name: RECENT_PLAYLISTS_PRIORITY_PLACEMENTS_BY_TRACK_PLAYLIST_DISTRIBUTOR_ONLY_FRESHEST
      - name: PRIORITY_PLAYLIST_METADATA