How to Run a SQL Query Using Jenkins

Need help with your Jenkins questions?
Visit https://community.jenkins.io/c/using-...

Timecodes ⏱:

00:00 Introduction
00:19 Overview
00:49 Starting point
02:12 Run a query using the CLI
03:20 Create a pipeline version 1
06:05 Create a Jenkins credential and update the pipeline job
08:47 Is the credential really good enough?
09:32 Update the pipeline job to secure the credential
11:33 Parameterize the pipeline job
14:32 Using jq to parse the SQL results
15:47 Conclusion

#jenkins #jenkinspipeline #sql

Information referenced in this video:

Jenkins LTS 2.277.3
https://www.jenkins.io/changelog-stab...

Supported Credentials Type
https://www.jenkins.io/doc/book/pipel...

Gist with SQL definition and example Jenkinsfiles:
https://gist.github.com/darinpope/2d0...

CloudBees on Twitter:
  / cloudbees  

Darin on Twitter:
  / darinpope