HI All,
We currently have a Catalog Item titled 'Snowflake Tenancy Onboarding Request' in ServiceNow, which is used for onboarding to a Snowflake data application (tenancy).
At present, we're using a JDBC data source to connect to Snowflake, and executing the following SQL query to create a tenancy:
sql - call DATAENG_ADMIN_DB.ADMINISTRATION.sp_create_tenancy('<env>', '<lob>', '<schema>', ' ', 2);
We would like to change the approach and automate the process through Git integration. The new expected workflow is as follows:
- Once the request is approved:
- ServiceNow should connect to a Git repository.
- Dynamically generate a script using parameters from the form.
- Push the script to Git.
- Trigger a Git pipeline that handles the execution (e.g., the Snowflake tenancy creation).
We already have the form and workflow in place, but would appreciate guidance on:
- Best practices for Git integration from ServiceNow.
- How to programmatically generate and push scripts to a Git repository.
- How to securely pass form data to the script.
- Triggering pipelines after push events from ServiceNow.
Any suggestions, references, or example implementations would be very helpful.
Thanks in advance!
