[Manual QA] Test Snowflake Handler Manually

[martyna-mindsdb]

At MindsDB, we are driven by the open-source community 💚 We aim to ask our community to review the MindsDB handlers in-depth and provide us with feedback/observations.

What

Your task is to run the following commands in the MindsDB editor.

• CREATE DATABASE This confirms that you are able to connect your Snowflake database. Please attach a screenshot once this step executes successfully.

• CREATE MODEL This confirms that you are able to create a model. Please attach a screenshot once this step executes successfully.

• Predict Target value using SELECT FROM This confirms that your model is able to predict target values. Please attach a screenshot once this step executes successfully.

• DROP DATABASE This confirms that you are able to delete the database after completing all your data transactions.

How

Run the commands, record your observations, and append the below content to mindsdb/integrations/handlers/snowflake_handler/Manual_QA.md.

## Testing Snowflake Handler with [Dataset Name](URL to the Dataset)

1. Testing CREATE DATABASE

COMMAND THAT YOU RAN TO CREATE DATABASE. [Format it in code blocks using ```]

![CREATE_DATABASE](Image URL of the screenshot)


2. Testing CREATE MODEL

COMMAND THAT YOU RAN TO CREATE MODEL. [Format it in code blocks using ```]

![CREATE_MODEL](Image URL of the screenshot)


3. Testing SELECT FROM MODEL

COMMAND THAT YOU RAN TO DO A SELECT FROM. [Format it in code blocks using ```]

![SELECT_FROM](Image URL of the screenshot)


4. Testing DROP DATABASE

COMMAND THAT YOU RAN TO DROP THE DATABASE. [Format it in code blocks using ```]

![DROP_DB](Image URL of the screenshot)


### Results

Drop a remark based on your observation.
- [ ] Works Great 💚 (This means that all the steps were executed successfully and the expected outputs were returned.)
- [ ] There's a Bug 🪲 [Issue Title](URL To the Issue you created) (This means you encountered a Bug. Please open an issue with all the relevant details using the Bug Issue Template)

Note

• We are not assigning this issue - multiple people can work on it.
• You must use a unique dataset for your QA test that's not already used.
• Simply drop a comment below mentioning the dataset you will be using.
• Your entry in the QA file should contain the execution of all required commands followed by the respective screenshots.
• If you find a bug, please raise a Bug Issue and attach it in the Results section as mentioned in the template above.

Thank you for contributing to MindsDB!

[Anuraag-CH]

While checking manually shall I use local installation or check it using mindsdb cloud editor?

[martyna-mindsdb]

@Anuraag-CH You can use either of these options.

[NishitSingh2023]

Hi @martyna-mindsdb, is this still open? Can I pick this up?

Do I need to generate a pull request for the same after updating the observations in mindsdb/integrations/handlers/snowflake_handler/Manual_QA.md

[ZoranPandovski]

@NishitSingh2023 Yes