How to load data from Sendinblue to Snowflake destination

Begin by exporting the data from Sendinblue. Log in to your Sendinblue account and navigate to the section where your data is stored, such as Contacts or Campaigns. Use the export functionality provided by Sendinblue to download your data in a CSV or Excel format. Ensure you've selected the correct data fields and date range required for your analysis.

Once the data has been exported, review the file to ensure it meets the format requirements for Snowflake. Check for any discrepancies or errors in the data, such as missing values or incorrect data types. Convert the file to a CSV format if it was exported in a different format, as Snowflake supports CSV uploads natively.

Log in to your Snowflake account and navigate to the database where you intend to store the Sendinblue data. If you don't have a database created, set one up by using the Snowflake web interface or by executing the appropriate SQL commands. Ensure you have the necessary permissions to create tables and upload data.

Define a table structure in Snowflake that matches the schema of your Sendinblue data. Use the Snowflake worksheet to execute a CREATE TABLE statement, specifying the column names and data types that correspond to your CSV file. For example:
```sql
CREATE TABLE sendinblue_data (
id INT,
email STRING,
name STRING,
signup_date DATE
);
```

Use the Snowflake web interface or a command-line tool like SnowSQL to upload your CSV file to a Snowflake stage. A stage is a temporary area in Snowflake where files are stored before being loaded into a table. You can create a stage if it doesn’t exist:
```sql
CREATE STAGE my_stage;
```
Then, upload the file using the PUT command:
```bash
PUT file://path/to/your/file.csv @my_stage;
```

Once the file is in the Snowflake stage, load it into your table using the COPY INTO command. This command reads the CSV file and inserts its contents into the specified table:
```sql
COPY INTO sendinblue_data
FROM @my_stage/file.csv
FILE_FORMAT = (TYPE = 'CSV' FIELD_OPTIONALLY_ENCLOSED_BY = '"' SKIP_HEADER = 1);
```

After the data is loaded, verify that the data in the Snowflake table matches what you exported from Sendinblue. Run SELECT queries to check data integrity and completeness. Once verified, clean up any temporary files or staging areas you used during the process to maintain a tidy environment:
```sql
REMOVE @my_stage/file.csv;
```

By following these steps, you can manually transfer data from Sendinblue to Snowflake without using third-party connectors or integrations.