source_db: art_relations
dim_table: dim_artist
export_sql: >-
  SELECT
  a.artist_id as artistId,
  stripSpecialChars(a.NAME) AS artistName,
  a.vendor_id AS labelId,
  a.orchard_country AS countryId
  FROM artist_info a
  inner join vendor v on v.vendor_id = a.vendor_id
update_sql:
  - >-
    UPDATE {db}.{schema}.{dim_table}
    SET artistName = st.artistName,
    labelId = st.labelId,
    countryId = st.countryId,
    last_updated = '{current_timestamp}'
    FROM {db}.{schema}.{staging_table} st
    WHERE {dim_table}.artistId = st.artistId
insert_sql:
  - >-
    INSERT INTO {db}.{schema}.{dim_table}
    SELECT
    'first',
    '{current_timestamp}',
    '{current_timestamp}'
    FROM {db}.{schema}.{staging_table} dat
  - >-
    INSERT INTO {db}.{schema}.{dim_table}
    SELECT
    'second'
    '{current_timestamp}',
    '{current_timestamp}'
    FROM {db}.{schema}.{staging_table} dat