Build a CLI tool/app to create SQL scripts to run on a database, based on a template

eclipseeer commented 6 months ago

I need to create a CLI tool that will take a database table name as input and then based on a template, create sql scripts with some additional logic to query said table. This sql scripts will then be run against the database and table to produce some output.

These sql scripts will be new files on the local machine that need to be created by the CLI, and then added to an existing git repo and subsequently pushed to remote.

For extra context, we're using dbt and Snowflake. So these files that are created will be new dbt models based on the template.

Looking for someone with experience using bash or powershell scripting to create a CLI that takes an input and then creates files on local machine, based on a template. Extra points if you can use Python to create this CLI

Extra extra points if you have experience with dbt & Snowflake

Will pay 10000 USDT for this. Expected dev time - 3 mounth

eclipseeer commented 6 months ago

@collaba-bot/create_bounty_from_issue

collaba-bot[bot] commented 6 months ago

title

Develop a CLI Tool for Generating SQL Scripts Based on Template

description

Create a CLI tool that accepts a database table name as input and generates SQL scripts using a template. These scripts, intended for querying the table, should be created as new files on the local machine, added to an existing git repo, and pushed to a remote repository. The scripts will be used as new dbt models for Snowflake. Experience with bash, PowerShell, or Python is required, with a preference for candidates familiar with dbt and Snowflake.

payment

10000 USDT

deadline

15.07.2024

eclipseeer / collaba-test