2025.09.11 8:38:27
DESCRIBE salesforce.stg_accounts
2025.09.11 8:38:29
MERGE INTO salesforce.stg_accounts t USING ( SELECT CAST(0 AS decimal(18, 0)) AS accountintentscore6sense__c, CAST('Target' AS varchar) AS accountbuyingstage6sense__c, CAST(0 AS int) AS account6qaageindays6sense__c, CAST(false AS boolean) AS account6qa6sense__c, CAST('iron.markets' AS varchar) AS website, CAST('0-6 months' AS varchar) AS accountcategory__c, TRY(from_iso8601_timestamp('2025-09-10T00:06:55.000Z')) AS lastmodifieddate, CAST(NULL AS varchar) AS is_a_customer_of__c, CAST(NULL AS varchar) AS designated_demand_strategist__r_name, CAST(NULL AS varchar) AS designated_demand_strategist__r_email, CAST(NULL AS varchar) AS designated_demand_strategist_backup__r_name, CAST(NULL AS varchar) AS designated_demand_strategist_backup__r_email, CAST(1 AS decimal(18, 2)) AS content_activity_score__c, CAST(0.25 AS decimal(18, 2)) AS content_activity_score_12m__c, CAST(false AS boolean) AS channel_status__c, CAST('Jacqueline Romano' AS varchar) AS cs_responsible__c, CAST('Direct' AS varchar) AS type, CAST(25 AS decimal(18, 2)) AS account_score_number__c, CAST('test_0014T000004Ay89QAC' AS varchar) AS account18digitsfid__c, CAST('Kevin Ebmeyer' AS varchar) AS owner_name, CAST('ebmeyer@infuse.com' AS varchar) AS owner_email, CAST('IRONMARKETS TEST' AS varchar) AS account_natural_name__c, CAST('IRONMARKETS' AS varchar) AS name, CAST('North America' AS varchar) AS accountgeo__c, CAST(false AS boolean) AS agp__c, false AS is_deleted, CAST(NULL AS timestamp) AS deleted_at, TRY_CAST(current_timestamp AS timestamp(6)) AS etl_created, DATE_FORMAT(current_timestamp, '%Y%m%d') AS etl_created_date ) s ON (t.account18digitsfid__c = s.account18digitsfid__c) WHEN MATCHED THEN UPDATE SET accountintentscore6sense__c = s.accountintentscore6sense__c, accountbuyingstage6sense__c = s.accountbuyingstage6sense__c, account6qaageindays6sense__c = s.account6qaageindays6sense__c, account6qa6sense__c = s.account6qa6sense__c, website = s.website, accountcategory__c = s.accountcategory__c, lastmodifieddate = s.lastmodifieddate, is_a_customer_of__c = s.is_a_customer_of__c, designated_demand_strategist__r_name = s.designated_demand_strategist__r_name, designated_demand_strategist__r_email = s.designated_demand_strategist__r_email, designated_demand_strategist_backup__r_name = s.designated_demand_strategist_backup__r_name, designated_demand_strategist_backup__r_email = s.designated_demand_strategist_backup__r_email, content_activity_score__c = s.content_activity_score__c, content_activity_score_12m__c = s.content_activity_score_12m__c, channel_status__c = s.channel_status__c, cs_responsible__c = s.cs_responsible__c, type = s.type, account_score_number__c = s.account_score_number__c, owner_name = s.owner_name, owner_email = s.owner_email, account_natural_name__c = s.account_natural_name__c, name = s.name, accountgeo__c = s.accountgeo__c, agp__c = s.agp__c, is_deleted = s.is_deleted, deleted_at = s.deleted_at, etl_created = s.etl_created WHEN NOT MATCHED THEN INSERT (accountintentscore6sense__c, accountbuyingstage6sense__c, account6qaageindays6sense__c, account6qa6sense__c, website, accountcategory__c, lastmodifieddate, is_a_customer_of__c, designated_demand_strategist__r_name, designated_demand_strategist__r_email, designated_demand_strategist_backup__r_name, designated_demand_strategist_backup__r_email, content_activity_score__c, content_activity_score_12m__c, channel_status__c, cs_responsible__c, type, account_score_number__c, account18digitsfid__c, owner_name, owner_email, account_natural_name__c, name, accountgeo__c, agp__c, is_deleted, deleted_at, etl_created, etl_created_date) VALUES (s.accountintentscore6sense__c, s.accountbuyingstage6sense__c, s.account6qaageindays6sense__c, s.account6qa6sense__c, s.website, s.accountcategory__c, s.lastmodifieddate, s.is_a_customer_of__c, s.designated_demand_strategist__r_name, s.designated_demand_strategist__r_email, s.designated_demand_strategist_backup__r_name, s.designated_demand_strategist_backup__r_email, s.content_activity_score__c, s.content_activity_score_12m__c, s.channel_status__c, s.cs_responsible__c, s.type, s.account_score_number__c, s.account18digitsfid__c, s.owner_name, s.owner_email, s.account_natural_name__c, s.name, s.accountgeo__c, s.agp__c, s.is_deleted, s.deleted_at, s.etl_created, s.etl_created_date);