CSV files to Snowflake table

[FrendsSarlinS]

Closes #85.

Checklist for review:

• [ ] Process name is fine, uses normal casing and descriptive
• [ ] Process description is fine, uses normal casing, dots and is descriptive
  • [ ] Element names use normal casing, no unneeded capital letters.
• [ ] Correct casing used for formats and terms, e.g. CSV, FTP, JSON, Avro
  • [ ] Element names do not contain dots
  • [ ] Comments / note element text are in good language and end with dots.
• [ ] Template parameters checked
  • [ ] Parameter descriptions are good and end with dots.
  • [ ] Sensitive parameters are marked as secrets
• [ ] "Turn off logging" switch is on for any task that has sensitive data as output
• [ ] End "balls" like error throws and return statements have titles (double-click) and reasonable information.
  • [ ] Results have good summaries, preferably with statistics of some sort like "processed X files"
  • [ ] Errors have some error info, usually from task (e.g. some ErrorMessage property contains additional error info)
• [ ] Process is organised with groups (dashed boxes)
• [ ] Straight lines are preferred where possible
• [ ] Subprocesses are forbidden
• [ ] Text mode is preferred over Expressions in expressions, e.g. instead of $"This is {#var.error}" use This is {{#var.error}}
• [ ] Process metadata file is present and content is fine (version number and name)
• [ ] Process export file is present (process.json)
• [ ] Process description file is present (all sections filled in)
• [ ] Process description has a SVG screenshot of the process
• [ ] Tempalte files are going to the correct folder

Summary by CodeRabbit

• New Features
  • Introduced a comprehensive template for uploading local CSV files to a Snowflake table stage and inserting the file content into the Snowflake table.
  • Added detailed guidance on prerequisites, implementation, usage notes, and error handling for the CSV to Snowflake process.
  • Included metadata and configuration details for the CSV upload process.

[coderabbitai[bot]]

Walkthrough

The new additions introduce templates for the process of uploading local CSV files to a Snowflake table stage and subsequently inserting the file contents into the table. These templates include detailed documentation, metadata, and configuration guidelines. The changes aid in establishing a structured and repeatable method for handling CSV to Snowflake data transfers.

Changes

Files	Change Summary
…CSV files to Snowflake table/long-description.md	A new document detailing prerequisites, implementation, usage, and error handling for uploading local CSV files to Snowflake tables.
…CSV files to Snowflake table/metadata.json	A new file providing metadata information for the process of converting CSV files to a Snowflake table, including name, version, and systems used.
…CSV files to Snowflake table/process.json	A new template process detailing the configuration for uploading local CSV files to a Snowflake table stage and inserting file content into the table, including paths and connection strings.

Assessment against linked issues

Objective (Issue #85)	Addressed	Explanation
Have a folder with three data files (CSV format), each with the same structure.	✅
Upload file to staging in Snowflake for each file.	✅
Copy file data into Snowflake table.	✅
Specify relevant statistics in the output (e.g., how many files were uploaded).	❓	Details on output statistics need verification in the implementation.
Provide parameters for folder path, Snowflake credentials, stage name, and table name.	✅

Poem

In fields of data, rabbits leap, Bringing CSVs for Snowflake to keep, With a hop and a bound, To tables they'll ground, Transforming bytes in a blissful sweep. 🌸🗃️📊

---

[!TIP]

Early access features: enabled

We are currently testing the following features in early access: - **OpenAI `gpt-4o` model for code reviews and chat**: OpenAI claims that this model is better at understanding and generating code than the previous models. We seek your feedback over the next few weeks before making it generally available. Note: - You can enable or disable early access features from the CodeRabbit UI or by updating the CodeRabbit configuration file. - Please join our [Discord Community](https://discord.com/invite/GsXnASn26c) to provide feedback and report issues. - OSS projects are currently opted into early access features by default.

Thank you for using CodeRabbit. We offer it for free to the OSS community and would appreciate your support in helping us grow. If you find it useful, would you consider giving us a shout-out on your favorite social media?

Share

- [X](https://twitter.com/intent/tweet?text=I%20just%20used%20%40coderabbitai%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20the%20proprietary%20code.%20Check%20it%20out%3A&url=https%3A//coderabbit.ai) - [Mastodon](https://mastodon.social/share?text=I%20just%20used%20%40coderabbitai%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20the%20proprietary%20code.%20Check%20it%20out%3A%20https%3A%2F%2Fcoderabbit.ai) - [Reddit](https://www.reddit.com/submit?title=Great%20tool%20for%20code%20review%20-%20CodeRabbit&text=I%20just%20used%20CodeRabbit%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20proprietary%20code.%20Check%20it%20out%3A%20https%3A//coderabbit.ai) - [LinkedIn](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fcoderabbit.ai&mini=true&title=Great%20tool%20for%20code%20review%20-%20CodeRabbit&summary=I%20just%20used%20CodeRabbit%20for%20my%20code%20review%2C%20and%20it%27s%20fantastic%21%20It%27s%20free%20for%20OSS%20and%20offers%20a%20free%20trial%20for%20proprietary%20code)

Tips

### Chat There are 3 ways to chat with [CodeRabbit](https://coderabbit.ai): - Review comments: Directly reply to a review comment made by CodeRabbit. Example: - `I pushed a fix in commit .` - `Generate unit testing code for this file.` - `Open a follow-up GitHub issue for this discussion.` - Files and specific lines of code (under the "Files changed" tab): Tag `@coderabbitai` in a new review comment at the desired location with your query. Examples: - `@coderabbitai generate unit testing code for this file.` - `@coderabbitai modularize this function.` - PR comments: Tag `@coderabbitai` in a new PR comment to ask questions about the PR branch. For the best results, please provide a very specific query, as very limited context is provided in this mode. Examples: - `@coderabbitai generate interesting stats about this repository and render them as a table.` - `@coderabbitai show all the console.log statements in this repository.` - `@coderabbitai read src/utils.ts and generate unit testing code.` - `@coderabbitai read the files in the src/scheduler package and generate a class diagram using mermaid and a README in the markdown format.` - `@coderabbitai help me debug CodeRabbit configuration file.` Note: Be mindful of the bot's finite context window. It's strongly recommended to break down tasks such as reading entire modules into smaller chunks. For a focused discussion, use review comments to chat about specific files and their changes, instead of using the PR comments. ### CodeRabbit Commands (invoked as PR comments) - `@coderabbitai pause` to pause the reviews on a PR. - `@coderabbitai resume` to resume the paused reviews. - `@coderabbitai review` to trigger an incremental review. This is useful when automatic reviews are disabled for the repository. - `@coderabbitai full review` to do a full review from scratch and review all the files again. - `@coderabbitai summary` to regenerate the summary of the PR. - `@coderabbitai resolve` resolve all the CodeRabbit review comments. - `@coderabbitai configuration` to show the current CodeRabbit configuration for the repository. - `@coderabbitai help` to get help. Additionally, you can add `@coderabbitai ignore` anywhere in the PR description to prevent this PR from being reviewed. ### CodeRabbit Configration File (`.coderabbit.yaml`) - You can programmatically configure CodeRabbit by adding a `.coderabbit.yaml` file to the root of your repository. - Please see the [configuration documentation](https://docs.coderabbit.ai/guides/configure-coderabbit) for more information. - If your editor has YAML language server enabled, you can add the path at the top of this file to enable auto-completion and validation: `# yaml-language-server: $schema=https://coderabbit.ai/integrations/schema.v2.json` ### Documentation and Community - Visit our [Documentation](https://coderabbit.ai/docs) for detailed information on how to use CodeRabbit. - Join our [Discord Community](https://discord.com/invite/GsXnASn26c) to get help, request features, and share feedback. - Follow us on [X/Twitter](https://twitter.com/coderabbitai) for updates and announcements.