search

eclipseeer / collaba-test

Repo for testing collaba bot
GNU General Public License v3.0
0 stars 0 forks source link

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

Open eclipseeer opened 7 months ago

eclipseeer commented 7 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 7 months ago

@collaba-bot/create_bounty_from_issue

collaba-bot[bot] commented 7 months ago

Title

Develop a CLI Tool for Generating SQL Scripts with dbt & Snowflake

Description

Create a CLI tool that accepts a database table name as input and generates SQL scripts based on a template. These scripts will query the specified table and output the results. The scripts should be saved as new dbt model files on the local machine, added to an existing git repository, and pushed to a remote repository. Experience with bash, PowerShell, or Python is required, with a preference for Python. Familiarity with dbt and Snowflake is highly advantageous.

Payment: 10000 USDT

Deadline: 15.07.2024

Tags: [dbt,Snowflake,Python,Bash,PowerShell,CLI]

collaba-bot[bot] commented 7 months ago

Title

Develop a CLI Tool for Creating SQL Scripts with dbt & Snowflake Integration

Description

Create a CLI tool that takes a database table name as input and generates SQL scripts based on a provided template. The scripts will query the specified table and produce outputs. These SQL scripts will be saved as new files on the local machine, added to an existing git repository, and pushed to a remote server. The tool should be compatible with dbt and Snowflake, and built using Bash, PowerShell, or Python.

Payment: 10000 USDT

Deadline: 15.07.2024

Tags: [dbt,Snowflake,Bash,PowerShell,Python,CLI]