Connect to your Google CloudSQL instance.

GoogleCloudSQLReader Properties

  • databaseName (Env First): The name of the database.
  • databaseType (Env First): The type of database.
  • username (Env First): The username for the database.
  • sqlQuery (Inline Only): The Postgres or MySQL dialect SQL query to read data from the database.
Example with Environment Credentials
-
    name: myConnectorName
    type: GoogleCloudSQLReader
    properties:
      sqlQuery:  SELECT * FROM xxx 
    #schemaRef: schemaName # optional from "schemas:"
Example with Inline Credentials
-
    name: myConnectorName
    type: GoogleCloudSQLReader
    properties:
      databaseName: myDatabase 
      databaseType: Postgres 
      username: myUsername 
      sqlQuery: SELECT * FROM xxx 
    #schemaRef: schemaName # optional from "schemas:"

GoogleCloudSQLWriter Properties

  • databaseName (Env First): The name of the database.
  • databaseType (Env First): The type of database.
  • tableName (Inline Only): The table name for writing data to the connector.
  • username (Env First): The username for the database.
Example with Environment Credentials
-
    name: myConnectorName
    type: GoogleCloudSQLWriter
    properties:
      tableName:  myTable 

Example with Inline Credentials
-
    name: myConnectorName
    type: GoogleCloudSQLWriter
    properties:
      databaseName:  myDatabase 
      databaseType:  Postgres 
      tableName:  myTable 
      username:  myUsername