.vscode folder for getting started with dbt in VSCode

extensions.json

{
    "recommendations": [
        "ms-python.python",
        "mechatroner.rainbow-csv",
        "samuelcolvin.jinjahtml",
        "bastienboutonnet.vscode-dbt",
        "amodio.find-related"
    ]
}

settings.json

{
    // change this for your desired path!
    "python.pythonPath": "./.dbtenv/bin/python",
    // this is to render Jinja in your .sql files
    // it will also not-render any sql files in the target folder.
    // this is to make things easier
    "files.associations": {
        "*.sql": "jinja-sql",
        "**/target/**": ""
    },
    // this is so you can easily jump to your compiled SQL files
    "findrelated.workspaceRulesets": [
        {
            "name": "sql",
            "rules": [
                {
                    "pattern": "^(.*/)?models/(.*/)?(.+\\.sql)$",
                    "locators": [
                        "**/compiled/**/$3"
                    ]
                },
                {
                    "pattern": "^(.*/)?compiled/(.*/)?(.+\\.sql)$",
                    "locators": [
                        "**/run/**/$3"
                    ]
                },
                {
                    "pattern": "^(.*/)?run/(.*/)?(.+\\.sql)$",
                    "locators": [
                        "**/models/**/$3"
                    ]
                }
            ]
        }
    ],
    "findrelated.applyRulesets": [
        "sql"
    ],
    // I personally like these settings
        // easier to see if there are unsaved changed
        "workbench.editor.highlightModifiedTabs": true,
        // make Command Prompt the default shell for Windows
        "terminal.integrated.shell.windows": "C:\\Windows\\System32\\cmd.exe",
        "editor.rulers": [80],
        "editor.renderWhitespace": "all",
}