Postgres

Instructions to fetch data from Postgres database

JSON Settings for reading data from Postgres database:

    "data" : [{
        "name":"test", 
        "format":"jdbc", 
        "props": {
            "url": "jdbc:postgresql://localhost:5432/<db_name>",
            "dbtable": "<testData>",
            "driver": "org.postgresql.Driver",
            "user": "<postgres>",
            "password": "<postgres>"				
        }
    }],

Please replace <db_name> with the name of the database in addition to other props. For more details, refer to the spark documentation.

Last updated