How to load data from ZohoCRM to Snowflake destination

Begin by exporting the necessary data from Zoho CRM. Log into your Zoho CRM account, navigate to the data you wish to export (such as Leads, Contacts, etc.), and use the export functionality available in Zoho CRM to download the data as a CSV file. Ensure that you have the necessary permissions to export data.

Open the exported CSV file using a spreadsheet application like Microsoft Excel or Google Sheets. Review the data for any inconsistencies or errors. Clean the data by removing any duplicates, correcting erroneous entries, and ensuring that the data types are consistent. This step is crucial to maintaining data integrity during the transfer.

Set up your Snowflake environment by creating the necessary database and schema to hold the incoming data. Log into your Snowflake account and use the following SQL commands to create a new database and schema:
```sql
CREATE DATABASE zoho_data;
USE DATABASE zoho_data;
CREATE SCHEMA crm_data;
USE SCHEMA crm_data;
```

Define the structure of the table in Snowflake that will store the exported data. Based on the columns in your CSV file, create a table with corresponding columns and appropriate data types. For example:
```sql
CREATE TABLE leads (
lead_id INTEGER,
lead_name STRING,
email STRING,
phone STRING,
company STRING,
created_date TIMESTAMP
);
```

Use the Snowflake web interface or SnowSQL command-line tool to upload the CSV file to a Snowflake internal stage. If using SnowSQL, execute the following command:
```bash
snowsql -q "PUT file:///path/to/your/exported_data.csv @%leads"
```
Replace `/path/to/your/exported_data.csv` with the actual path of your CSV file.

Load the data from the staged CSV file into the Snowflake table using the `COPY INTO` command. Execute the command via Snowflake's SQL interface:
```sql
COPY INTO leads
FROM @%leads/exported_data.csv
FILE_FORMAT = (TYPE = 'CSV', FIELD_OPTIONALLY_ENCLOSED_BY = '"', SKIP_HEADER = 1);
```
This command loads the CSV data into the `leads` table, ensuring any headers in the CSV are skipped.

After loading the data, verify that the data in Snowflake matches the data exported from Zoho CRM. Execute SQL queries to count records, check for null values, and compare sample entries. For example:
```sql
SELECT COUNT(*) FROM leads;
SELECT * FROM leads WHERE lead_id IS NULL;
```
Address any discrepancies found during this verification step to ensure the integrity and completeness of the data transfer.

By following these steps, you can successfully move data from Zoho CRM to Snowflake Data Cloud without the use of third-party connectors or integrations.