Skip to content

Instantly share code, notes, and snippets.

View sheelstera's full-sized avatar

sheelstera

View GitHub Profile
@sheelstera
sheelstera / scripts.sql
Created November 1, 2024 18:48
ALTER TABLE main.schema1.ExtendedCustomerProfile ALTER COLUMN customer_id
SET TAGS ('tag1' = 'identifier', 'tag2' = 'unique_id');
ALTER TABLE main.schema1.ExtendedCustomerProfile ALTER COLUMN first_name
SET TAGS ('tag1' = 'demographic', 'tag2' = 'name');
ALTER TABLE main.schema1.ExtendedCustomerProfile ALTER COLUMN last_name
SET TAGS ('tag1' = 'demographic', 'tag2' = 'name');
ALTER TABLE main.schema1.ExtendedCustomerProfile ALTER COLUMN email
@sheelstera
sheelstera / Customer_Interactions_Table.csv
Created November 1, 2024 17:04
interaction_id customer_id interaction_date interaction_type issue_type resolution_status
INTER000001 CUST0001 2024-10-07 Email Request Unresolved
INTER000002 CUST0001 2024-05-11 Email Complaint Resolved
INTER000003 CUST0001 2024-06-01 Support Call Complaint Unresolved
INTER000004 CUST0001 2024-04-17 Support Call Request Pending
INTER000005 CUST0001 2024-02-09 In-person Inquiry Resolved
INTER000006 CUST0002 2024-03-24 In-person Feedback Pending
INTER000007 CUST0002 2024-01-06 Email Request Unresolved
INTER000008 CUST0002 2024-01-05 Chat Request Pending
INTER000009 CUST0002 2024-03-04 Chat Feedback Resolved
@sheelstera
sheelstera / Customer_Address_Table.csv
Created November 1, 2024 17:02
customer_id address_id street_address city state postal_code country
CUST0001 ADDR0001 7898 Stephen Coves Apt. 741 Melbourne 29914 Australia
CUST0002 ADDR0002 564 Munoz Spring Munich 63081 Germany
CUST0003 ADDR0003 47379 West Courts Suite 314 Vancouver NS 97748 Canada
CUST0004 ADDR0004 5514 Arnold Port Suite 119 Toronto QC 24663 Canada
CUST0005 ADDR0005 9050 Christopher Causeway Apt. 235 Toronto BC 89123 Canada
CUST0006 ADDR0006 823 Sandra Grove Suite 029 Lyon 17310 France
CUST0007 ADDR0007 52561 Beck Lane Sydney 33557 Australia
CUST0008 ADDR0008 2480 Moore Lodge Apt. 818 Johannesburg 72329 South Africa
CUST0009 ADDR0009 47774 Webb Ferry Apt. 619 Lyon 74069 France
@sheelstera
sheelstera / Customer_Profile_Table.csv
Created November 1, 2024 17:02
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 31 columns, instead of 25 in line 2.
customer_id,first_name,last_name,email,phone_number,date_of_birth,gender,registration_date,education_level,employment_status,annual_income,marital_status,household_size,home_ownership,children_in_household,household_income_bracket,vehicles_owned,primary_vehicle_type,gadgets_owned,has_smart_home_device,primary_interest,secondary_interest,lifestyle_segment,avg_monthly_spend,purchase_frequency,preferred_shopping_channel,loyalty_program_member,has_high_credit_card_limit,technology_adopter_type,number_of_devices,preferred_social_media_platform
CUST0001,Jasmine,Kelley,trancaroline@gonzalez.com,430.499.8737x904,1949-01-26,Other,2020-02-18,Bachelor's,Self-employed,152000.0,Widowed,3,Own,4,100-150K,1,Luxury,Smartwatch,True,Luxury Cars,Music,Single Professional,3891.63,Quarterly,Online,False,False,Early Adopter,1,Facebook
CUST0002,Cynthia,Perry,zguerrero@williams-owen.com,+1-269-165-6290,1966-08-14,Other,2024-04-17,PhD,Retired,66000.0,Married,3,Rent,1,100-150K,1,Sedan,Laptop,True,Fashion,Gaming,Family Oriented,6380.94,