Using a VNet gateway with Notebooks

I'm unsure what you are asking beyond the information i provided.

We have enabled the On-prem gateways so that Pipelines and Gen2 dataflows can connect to an AWS PostGreSQL RDS database. That works fine with the Pipeline. But we want to use Notebooks instead to query and pull that data in. The Notebook query template given to us by Microsoft consultants Was:

# Import necessary libraries
from pyspark.sql import SparkSession
 
# Create a Spark session
spark = SparkSession.builder \
    .appName("Read from PostgreSQL") \
    .getOrCreate()
 
# Define the PostgreSQL connection properties
jdbc_url = "jdbc:postgresql://your-postgres-hostname:5432/your-database"
connection_properties = {
    "user": "your-username",
    "password": "your-password",
    "driver": "org.postgresql.Driver"
}
 
# Read data from a table in the PostgreSQL database
table_name = "your_table_name"
df = spark.read.jdbc(url=jdbc_url, table=table_name, properties=connection_properties)
 
# Show the data
df.show()
 
# Stop the Spark session
spark.stop()

 However, we should be triggering the gateway and not including the username and password in the code.