How to Run a SQL Query Using Jenkins

Need help with your Jenkins questions? Visit https://community.jenkins.io/c/using-jenkins/support/8 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-stable/#v2.277.3 Supported Credentials Type https://www.jenkins.io/doc/book/pipeline/syntax/#supported-credentials-type Gist with SQL definition and example Jenkinsfiles: https://gist.github.com/darinpope/2d07c6f5d959a351e27d4669603de9b6 CloudBees on Twitter: https://twitter.com/CloudBees Darin on Twitter: https://twitter.com/DarinPope