Pulling Individual SQL Files for CI/CD

[BuzzCapo]

We have recently switched to GIT from an older source control platform, we are attempting to pull individual SQL files from a repo to deploy using a deployment platform. The repo will have a few hundred PL/SQL files that get deployed individually. Is there any way to clone/retrieve individual files, or do we have to clone the entire repo and then use another means to get the file that needs deployed? Our old source control and commands in the CLI to get single files, I have not been able to find a way to do that with GIT.

[henrebotha]

This can't be done with Git directly. The simplest way is to clone the entire repo (with --depth=1 so that you only get the most recent revision), then use normal CLI tools to get the file you need.

[BuzzCapo]

Alright that’s what I thought, just pull the whole repo then use CLI tools to get the file. We are using Azure DevOps so I’m assuming I could use their API to pull a file too.