Sync with Lucas

Need to see data in ADS direct and see what it looks like Is the data one huge file? Two way to put data in Snowflake

• Through copy into and/or snowpipe

1993cd6960e88090919de6ac08a2dea2
• Through Bettrdata to Snowflake: Snowflake outbound integration

Create tables for the data based on the data

• people
• emails
• children
• vehicle

Create views according to customer needs

Access in S3 Load data in Snowflake Create Views over table

Action Items: Put ADS base script in bettrdatga-professional services for client Send notes/steps Put in examples for copy into command with CSV or JSON Walk through a base set up next time Propose to them to use BD to help standard and format data

Set up environment Set up tables Set up views

Questions Do we need to in a specific format

Put in ADS direct internal client folder

Onboarind/PoC Synch

Get Sow for RMG CRM

https://bettrdata.atlassian.net/issues/?filter=10030&atlOrigin=eyJpIjoiM2VlNjQ5NjU4MDYwNDRmZGIxYTVkOTI0MTIxYjI5ZDkiLCJwIjoiaiJ9

Email to Trent, Mike, Stepheh, and Adam Cc Charels, Dan

Get a sample of what ??? data