Acquire a list of fields and date types for creating of your Snowflake table.

Now we have all of our Salesforce fields ready to insert into Snowflake.

Lets go into Snowflake and create our Lead Table. Login to Snowflake with a user that has permission to create Tables. In this example we are going to create a schema and a table.

Go to the database where you want to your Lead table to reside.

We will create a "SFDC" schema first. With the DB selected click "+ Schema"

Name the schema ("SFDC") and Click "Create"

Click the schema where you want to create your Lead table. 

Click after your schema name so you can add the Table name.

Go back to the spreadsheet and copy the rows (not including the column name).

That's it! You now have your table and DDL for the future as you want to update and add columns. Now you can learn how to push data into your table.

Create Snowflake Table with Salesforce Leads Schema