This repository contains scripts and documentation for performing database operations using Snowflake and SQL worksheets. The focus of this project is on loading data from AWS S3 buckets into Snowflake and executing SQL operations.
These instructions will guide you through setting up the project and running the scripts on your local environment.
- Snowflake account with appropriate permissions
- Access to an AWS S3 bucket
- SQL development environment (e.g., Snowflake Worksheet, SQL client)
- Clone the repository to your local machine.
git clone https://github.com/swapniltake1/snowflake-sql-worksheets.git
- Set up your Snowflake connection parameters and AWS S3 credentials in the configuration file (if applicable).
config/config.json
- Navigate to the
scripts
directory.
cd scripts
-
Run the SQL scripts in your SQL development environment to perform various database operations. The scripts are organized based on their functionality.
-
Monitor the execution and verify the results.
Contributions are welcome! If you'd like to contribute to this project, please follow these guidelines:
- Fork the repository.
- Create a new branch (
git checkout -b feature/your-feature
). - Make your changes and commit them (
git commit -am 'Add new feature'
). - Push to the branch (
git push origin feature/your-feature
). - Create a new Pull Request.
This project is licensed under the MIT License - see the LICENSE file for details.
- Snowflake documentation: https://docs.snowflake.com/
- AWS S3 documentation: https://docs.aws.amazon.com/s3/