WITH base AS (
  SELECT
    *
  FROM TEST.PUBLIC_qualtrics_source.stg_qualtrics__block_tmp
), fields AS (
  SELECT
    CAST(NULL AS BOOLEAN) AS _fivetran_deleted,
    CAST(NULL AS TIMESTAMP) AS _fivetran_synced,
    CAST(NULL AS TEXT) AS block_locking,
    CAST(NULL AS TEXT) AS block_visibility,
    CAST(NULL AS TEXT) AS description,
    CAST(NULL AS TEXT) AS id,
    CAST(NULL AS TEXT) AS randomize_questions,
    CAST(NULL AS TEXT) AS survey_id,
    CAST(NULL AS TEXT) AS type,
    CAST('' AS TEXT) AS source_relation
  FROM base
), final AS (
  SELECT
    block_locking AS is_locked,
    block_visibility,
    description,
    id AS block_id,
    randomize_questions,
    survey_id,
    type,
    _fivetran_deleted AS is_deleted,
    _fivetran_synced,
    source_relation
  FROM fields
)
SELECT
  *
FROM final

WITH base AS (
  SELECT
    *
  FROM TEST.PUBLIC_qualtrics_source.stg_qualtrics__block_question_tmp
), fields AS (
  SELECT
    CAST(NULL AS BOOLEAN) AS _fivetran_deleted,
    CAST(NULL AS TIMESTAMP) AS _fivetran_synced,
    CAST(NULL AS TEXT) AS block_id,
    CAST(NULL AS TEXT) AS question_id,
    CAST(NULL AS TEXT) AS survey_id,
    CAST('' AS TEXT) AS source_relation
  FROM base
), final AS (
  SELECT
    block_id,
    question_id,
    survey_id,
    _fivetran_deleted AS is_deleted,
    _fivetran_synced,
    source_relation
  FROM fields
)
SELECT
  *
FROM final

SELECT
  CAST(NULL AS TEXT) AS _dbt_source_relation
LIMIT 0

SELECT
  CAST(NULL AS TEXT) AS _dbt_source_relation
LIMIT 0

WITH base AS (
  SELECT
    *
  FROM TEST.PUBLIC_qualtrics_source.stg_qualtrics__contact_mailing_list_membership_tmp
), fields AS (
  SELECT
    CAST(NULL AS TIMESTAMP) AS _fivetran_synced,
    CAST(NULL AS TEXT) AS contact_id,
    CAST(NULL AS TEXT) AS contact_lookup_id,
    CAST(NULL AS TEXT) AS directory_id,
    CAST(NULL AS TEXT) AS mailing_list_id,
    CAST(NULL AS TEXT) AS name,
    CAST(NULL AS TEXT) AS owner_id,
    CAST(NULL AS TIMESTAMP) AS unsubscribe_date,
    CAST(NULL AS BOOLEAN) AS unsubscribed,
    CAST('' AS TEXT) AS source_relation
  FROM base
), final AS (
  SELECT
    contact_id,
    contact_lookup_id,
    directory_id,
    mailing_list_id,
    name,
    owner_id AS owner_user_id,
    CAST(unsubscribe_date AS TIMESTAMP) AS unsubscribed_at,
    unsubscribed AS is_unsubscribed,
    _fivetran_synced,
    source_relation
  FROM fields
)
SELECT
  *
FROM final

SELECT
  CAST(NULL AS TEXT) AS _dbt_source_relation
LIMIT 0

WITH base AS (
  SELECT
    *
  FROM TEST.PUBLIC_qualtrics_source.stg_qualtrics__directory_tmp
), fields AS (
  SELECT
    CAST(NULL AS BOOLEAN) AS _fivetran_deleted,
    CAST(NULL AS TIMESTAMP) AS _fivetran_synced,
    CAST(NULL AS BOOLEAN) AS deduplication_criteria_email,
    CAST(NULL AS BOOLEAN) AS deduplication_criteria_external_data_reference,
    CAST(NULL AS BOOLEAN) AS deduplication_criteria_first_name,
    CAST(NULL AS BOOLEAN) AS deduplication_criteria_last_name,
    CAST(NULL AS BOOLEAN) AS deduplication_criteria_phone,
    CAST(NULL AS TEXT) AS id,
    CAST(NULL AS BOOLEAN) AS is_default,
    CAST(NULL AS TEXT) AS name,
    CAST('' AS TEXT) AS source_relation
  FROM base
), final AS (
  SELECT
    deduplication_criteria_email AS is_deduped_on_email,
    deduplication_criteria_external_data_reference AS is_deduped_on_ext_ref,
    deduplication_criteria_first_name AS is_deduped_on_first_name,
    deduplication_criteria_last_name AS is_deduped_on_last_name,
    deduplication_criteria_phone AS is_deduped_on_phone,
    id AS directory_id,
    is_default,
    name,
    _fivetran_deleted AS is_deleted,
    _fivetran_synced,
    source_relation
  FROM fields
)
SELECT
  *
FROM final

WITH base AS (
  SELECT
    *
  FROM TEST.PUBLIC_qualtrics_source.stg_qualtrics__directory_contact_tmp
), fields AS (
  SELECT
    CAST(NULL AS TIMESTAMP) AS _fivetran_synced,
    CAST(NULL AS TIMESTAMP) AS creation_date,
    CAST(NULL AS TEXT) AS directory_id,
    CAST(NULL AS TIMESTAMP) AS directory_unsubscribe_date,
    CAST(NULL AS BOOLEAN) AS directory_unsubscribed,
    CAST(NULL AS TEXT) AS email,
    CAST(NULL AS TEXT) AS email_domain,
    CAST(NULL AS TEXT) AS ext_ref,
    CAST(NULL AS TEXT) AS first_name,
    CAST(NULL AS TEXT) AS id,
    CAST(NULL AS TEXT) AS language,
    CAST(NULL AS TIMESTAMP) AS last_modified,
    CAST(NULL AS TEXT) AS last_name,
    CAST(NULL AS TEXT) AS phone,
    CAST('' AS TEXT) AS source_relation
  FROM base
), final AS (
  SELECT
    CAST(creation_date AS TIMESTAMP) AS created_at,
    directory_id,
    CAST(directory_unsubscribe_date AS TIMESTAMP) AS unsubscribed_from_directory_at,
    directory_unsubscribed AS is_unsubscribed_from_directory,
    LOWER(email) AS email,
    LOWER(email_domain) AS email_domain,
    ext_ref,
    first_name,
    last_name,
    REGEXP_REPLACE(phone, '[^0-9]', '') AS phone, /* remove any non-numeric chars */
    id AS contact_id,
    language,
    CAST(last_modified AS TIMESTAMP) AS last_modified_at,
    _fivetran_synced,
    source_relation
  FROM fields
)
SELECT
  *
FROM final

SELECT
  CAST(NULL AS TEXT) AS _dbt_source_relation
LIMIT 0

WITH base AS (
  SELECT
    *
  FROM TEST.PUBLIC_qualtrics_source.stg_qualtrics__directory_mailing_list_tmp
), fields AS (
  SELECT
    CAST(NULL AS BOOLEAN) AS _fivetran_deleted,
    CAST(NULL AS TIMESTAMP) AS _fivetran_synced,
    CAST(NULL AS TIMESTAMP) AS creation_date,
    CAST(NULL AS TEXT) AS directory_id,
    CAST(NULL AS TEXT) AS id,
    CAST(NULL AS TIMESTAMP) AS last_modified_date,
    CAST(NULL AS TEXT) AS name,
    CAST(NULL AS TEXT) AS owner_id,
    CAST('' AS TEXT) AS source_relation
  FROM base
), final AS (
  SELECT
    CAST(creation_date AS TIMESTAMP) AS created_at,
    directory_id,
    id AS mailing_list_id,
    CAST(last_modified_date AS TIMESTAMP) AS last_modified_at,
    name,
    owner_id AS owner_user_id,
    _fivetran_deleted AS is_deleted,
    _fivetran_synced,
    source_relation
  FROM fields
)
SELECT
  *
FROM final

SELECT
  CAST(NULL AS TEXT) AS _dbt_source_relation
LIMIT 0