source_db: art_relations
dim_table: dim_genre
export_sql: >-
  SELECT
    genre_id as genreId,
    genre as genreName
  FROM genre
update_sql:
  - >-
    UPDATE
      {db}.{schema}.{dim_table}
    SET
      genreName = st.genreName,
      last_updated = '{current_timestamp}'
    FROM
      {db}.{schema}.{staging_table} st
    WHERE
      {dim_table}.genreId = st.genreId AND
      {dim_table}.genreName <> st.genreName
insert_sql:
  - >-
    INSERT INTO
      {db}.{schema}.{dim_table}
    SELECT
      st.genreId,
      st.genreName,
      '{current_timestamp}',
      '{current_timestamp}'
    FROM
      {db}.{schema}.{staging_table} st
    LEFT JOIN
      {db}.{schema}.{dim_table} dg on dg.genreId = st.genreId
    WHERE
      dg.genreId is null